27) What are the different types of relationships represented in a data model? 28) Explain the difference between maximum and minimum cardinality. 29) The process of converting poorly structured...





27) What are the different types of relationships represented in a data model?



28) Explain the difference between maximum and minimum cardinality.



29) The process of converting poorly structured tables into two or more well-structured tables is referred to as ________.



A) replication



B) integration



C) actualization



D) normalization



30) The data integrity problem can occur only if data are ________.



A) duplicated



B) missing



C) inefficient



D) insufficient



31) Normalized tables eliminate ________.



A) data dependency



B) data duplication



C) data insufficiency



D) data conversion



32) The general goal of normalization is to ________.



A) create a copy of an existing table



B) establish relationships among the entities in a table



C) convert two or more tables into a single table



D) construct tables such that every table has a single topic



33) According to the kinds of problems they have, database practitioners classify tables into various ________.



A) solved forms



B) cardinalities



C) normal forms



D) relationships



34) Normalization is a database design concept that helps to construct well-structured tables.



35) The data integrity problem can occur only if data are missing.



36) The general goal of normalization is to construct tables such that every table has a single topic or theme.



37) Tables that are not normalized can have data integrity problems.



38) Database practitioners classify tables into various normal forms according to the kinds of problems they have.



39) To represent an N:M relationship between two entities, two normalized tables are sufficient.





May 15, 2022
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here