-
Scarlett
Turn three of your Scarlett Talent Agency entities into relations.
-
Converting extended E-R model
Describe the process of converting an extended E-R model into a relational database design.
-
one to many
Explain the representation of a one-to-many strong entity relationship in a relational database design.
-
Intersection table
What is an intersection table and why is it important?
-
Primary Key
Why is the choice of primary key important and are three characteristics of an ideal primary key?
-
Unique and Non-unique keys
Discuss the difference between unique and non-unique keys
-
Requirement Gathering
Name three activities involved in requirement gathering
-
Type of Participation
What is meant by type of participation? Name the three types of relationship participation.
-
Integrity Rules
List the rules used to enforce table level integrity.
-
Tree Relationship
What is a tree relationship and give an example
-
Degree of Relationship
What is the degree of relationship? Name the three degrees.