Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
Database Design Using Normalization
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
True
Correct Answer:
False
← Previous Question
Next Question→
More Questions from
Database Design Using Normalization
One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
We use the SQL construct COUNT(*) to count the number of rows in a table.
One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.
We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
We can eliminate modification anomalies with proper normalization that results in tables in BCNF.
When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.
We have normalized a table into BCNF if all candidate keys are determinants.
When building a database from an existing set of tables, we still need to consider normalization principles.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments