 Related Questions Latest Answer : Normalization is based on the functional dependency and primary key.1NF- Attribute should be atomic value and there must be no composite attribute, no multivalued attribute and no relation with in relation. By default what ever relation we are creating ... Latest Answer : We can normalize the many to many realationship, by creating a third table contaaining the primary keys of both the tables ... Read Answers (2) | Asked by : usman hassan Latest Answer : It is the property of the database to utilize the additional resources such as the memory and processors to meet the increased demand. By scaling performance is increased to a greater extend ... Latest Answer : HI, In simple words databse is generic and database server is specific to computers. Database is collection of data in a defined manner.Database sever is software that helps us to operate on the databaseRegards,PRASAD ... Read Answers (7) | Asked by : Rana Irfan Latest Answer : 1) Transaction database is designed for a specific application.Datawarehouse is designed to integrate data from multiple datasource.2) Transaction focuses on the details, Datawarehouse focuses on high level aggregates.3) Transaction database is volatile. ... Read Answers (8) | Asked by : Mojtaba Kamalian Latest Answer : Other than those mentioned above the different indexes are1)ClusteredRequires the date to be sortedwe can create 1 clustered2)Non-Clustereddoesnt require the data to be sortedWe can create 249 non-clustered indexes ... Latest Answer : This may be considered as the mapping of the data and data relations into an indefinitely large linear address space. This specifies some or all of the data structures necessary to support the data and data relations declared in the conceptual schema. ... Read Answers (2) | Asked by : beenu Latest Answer : no up to 3nf it is not sufficient to normilize...coz 3nf contains redundancy problem....that can be removed by BCNF...so up to BCNF it is sufficient..... ... There is a new project to acquire a new data feed from a vendor and add it to a database to enhance coverage for a neglected market. The data feed consists of a daily set of 6 files, one primary file with one row per main object, 4 other files which relate to the main file, and a secondary object file which is loosely related to the first. The data is in plain text. What sort of information would you expect to see in the feed specification from the vendor? List at least eight. Give the reason View Question | Asked by : Ming You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen. For example, consider a system for a gift wishlist. The main object is a person and different categories of items are stored in separate tables (movies View Question | Asked by : Ming
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
