Question: On QUESTIONS 1. What is data modeling? Why is it important? 2. What is the Entity-Relationship model? 3. What is a relationship? 4. What are
1. What is data modeling? Why is it important? 2. What is the Bntity-Relationship model? 3. What is a relationship? 4. What are the differenoes among a unacy relationship, a binary relationship, and a ternary relationship? 5. Bxplain and compare the cardinnlity of arelationship and the modality of a relationship. 6. Explatin the differenco between a one-to-ono, a oneto-many, and a many-to-many binary relationship. 7. What is intersection dath in a many-to-many binary relationship? What does the intersection data doseribe? 8. Can a meny-to-many binary relationship have no intersection data? Explatn. 9. Can intersection data be plnood in the entity box of one of the two entities in the many-to-many relationship? Rxplain. 10. What is an associativo entity? How does intersection data relate to an associativo entity? 11. Describe the three cases of unique identifiers for associative entities. 12. Describe the concopt of the unary relationship. 13. Explain how a unnry relationship can be described as one-to-one, one-to-many, and many-to-many if only one entity type is involved in the relationship. 14:- Describe the ternary relationship concept. 15. Can a ternary relationship have intersection data? Explain. 16. What is a dependent entity? (Seo the description in the General Hardware example.) EXERCISES 1. Draw an entity-rolationship diagram that describes tho following business environment. The city of Chicago, It, wants to maintain information about its extenaive aystem of high schools, including its tenchecs and their university degrees, its studonts, administrators, and the sobjects that it teaches. Bach school has a uniquo name, jerrin address] Rea Students have a student number, pame, home Gdorns, hotio totephono number, cuncent grade, budase. Kogarding a student's school assignment, tho school system is only interestod in keeping Bach school hes several administrators, meh as the principal and assiatsutprincipals, Administntors are. identified bx-an-employee number and jiso hive a thinc, telephono numbar, und office number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
