ntity Set has a relationship with has an attribute is a specialization of is a generalization, computer science homework help
- Consider the entity sets and attributes shown in the table below. Place a checkmark in one column in each row to indicate the relationship between the far left and the far right columns.
|
Entity Set |
has a relationship with |
has an attribute |
is a specialization of |
is a generalization of |
Entity Set or Attribute |
|
Student |
Person |
||||
|
Animal |
Horse |
||||
|
Employee |
SSN |
||||
|
School |
Student |
- Consider the following relation R, and assume that each of the following letters represents an attribute in R:
R (A, B, C, D, E, F)
Suppose the following dependencies exist:
A, B -> C, D, E, F
B -> D
E -> F
Your assignment is as follows:
- Draw a relational schema for your 1NF relation and diagram the functional dependencies.
- Draw a relational schema for your 2NF relations, diagram the functional dependencies, and show the referential integrity constraints.
- Draw a relational schema for your 3NF relations, diagram the functional dependencies, and show the referential integrity constraints.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
