CS122A: Introduction to Data Management
(1 point for each part) Consider the above ER diagram for designing a database for our class, CS122A, in Spring 2016. Now, identify the following:
1. Entities –
2. Relationship(s) –
3. Simple key(s) –
4. Composite key(s) –
5. Composite attribute(s) –
6. Derived attribute(s) –
7. Multi-valued attribute(s) –
8. Entity set(s) (with more than one entity) –
9. Aggregation(s) –
10. Binary relationship(s) –
11. Ternary relationship(s) –
12. Check the following participation constraint: “Every discussion has a TA”.
a. True
b. False
13. Check the following participation constraint: “Every TA has a discussion section”.
a. True
b. False