Western Governors University DATABASE 0047 Sophia Database Milestone 5 UNIT 5 — MILESTONE 5 Score 14/17

Document Content and Description Below

UNIT 5 — MILESTONE 5 Score 14/17 You passed this Milestone 14 questions were answered correctly. 3 questions were answered incorrectly. 1 What is a key feature of fifth normal form? This norm... al form resolves any multivalued dependencies. Foreign keys are created in this normal form. This normal form has the tables broken down into as many tables as possible to avoid redundancy. A key step in this normal form has every determinant in a table as a candidate key. CONCEPT Higher Normalization 2 What is a disadvantage of reducing the complexity of data models? Decreased redundancy Faster application development Simpler queries Simpler application code CONCEPT ERD Example: Complexity 3 Review the sample eCommerce ERD after 3NF. 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 2/11 What is the relationship between table Customer and Order? N:1 M:N 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 3/11 1:M 1:1 CONCEPT ERD Example: eCommerce 4 Review the sample movie ratings ERD after 3NF. 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 4/11 What is the relationship between table Movie and Rating? 1:M M:N 0:1 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 5/11 1:1 CONCEPT ERD Example: Movie Ratings 5 What is true about normalization? Have report data simplified as the report may not be possible to generate using plain SQL. Normalization uses the concept of functional dependencies to identify which attribute determines other attributes. Increase performance for reports. Reduce the joining of tables as that takes additional input/output operations. CONCEPT Normalization Overview 6 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ What is wrong with the following ERD meant to show a relationship between two entities? There is nothing wrong with the ERD. Both of the objects are attributes. One of the items is set up as an attribute. There is no relationship between the entities. CONCEPT What is a criterion of a table being in first normal form? No cell should have repeating groups. No non-prime attributes dependent on the candidate key should be included. This normal form guarantees that there will be no data redundancies due to functional dependencies. All transitive functional dependencies of a non-prime attribute of a super key should be removed. CONCEPT First Normal Form 8 What could be a reason to denormalize a database? We want to remove multivalued dependencies. We want to increase performance for inserts, updates, and deletes. We want to reduce redundancy. The reports needed may not be possible to generate through plain SQL. CONCEPT Denormalization 9 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ What is used to indicate a weak relationship in an ERD? Single diamond Single dotted diamond Double rectangular box 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 7/11 Double diamond CONCEPT Weak Relationships and Entities 10 Is this dataset in 2NF or not? If not why not? No, the dataset is not yet in 1NF. No, there are no transitive functional dependencies. It is in 2NF. No, there are still functional dependencies. CONCEPT Second Normal Form 11 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ What type of cardinality is demonstrated by the following ERD? 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 8/11 A country can have a capital city. A capital city can belong to multiple countries. A country can have multiple capital cities. A capital city can be part of one country. A country can have multiple capital cities. A capital city can belong to multiple countries. A country can have a capital city. A capital city can be part of one country. CONCEPT Relationships and Cardinality 12 What is a benefit of using a lookup table? They resolve weak entities. They centralize data about the key. They transform an M:N relationship into two 1:M relationships. They model pure relationships rather than entities. CONCEPT Reference Tables 13 Identify the normal form in which we have all of the key attributes defined. 3NF 2NF 1NF None of the first 3 normal forms CONCEPT 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 9/11 Normal Forms 14 Is this dataset in 3NF? If not, why not? No, there are repeating groups. No, it is not yet in 2NF. Yes, it is in 3NF. No, there is an issue with the functional dependency. CONCEPT Third Normal Form 15 What type of key can be used in an associative entity? No key is needed with an associative entity. A surrogate primary key. A composite primary key. A natural primary key. 1/1/22, 4:05 AM Sophia :: Welcome https://app.sophia.org/spcc/introduction-to-relational-databases/milestone_take_feedbacks/12141998 10/11 CONCEPT Associative Entities 16 What type of connection trap could be created due to a parent-child form of two one-to-many relationships? Design trap Fan trap System trap Chasm trap CONCEPT ERD Connection Traps 17 In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. https://postgres.sophia.org/ What is wrong with the following ERD meant to show the attributes of an entity? The primary key is not indicated correctly. The attributes are not correctly linked to the entity. There is nothing wrong with the ERD. The symbols used are swapped. 1/1/22, 4:05 AM Sophia :: Welcome. CONCEPT Adding Attributes About Contact Us Privacy Policy Terms of Use [Show More]

Last updated: 1 year ago

Preview 1 out of 11 pages