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 normal form resolves any m
...
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 normal 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]