Programming > QUESTIONS & ANSWERS > Questions and Answers > University of West Florida: COP 4710 Database Systems: ER Chapter 9 (All)

Questions and Answers > University of West Florida: COP 4710 Database Systems: ER Chapter 9

Document Content and Description Below

COP 4710 Database Systems: ER Chapter 9 June 11, 2018 Checkpoint 9.1 1. What is a ternary relationship? 2. What is an n-ary relationship? 4. Using the three entities presente... d (PRODUCT, SUPPLIER, and CUSTOMER), draw an ER diagram that depicts the following: A customer must buy one and only one product from a supplier at a particular price on a particular date. Checkpoint 9.2 2. Come up with some attributes and entities of a relationship that you think could be a ternary relationship. Can this relationship be expressed in the form of a binary relationship? Checkpoint 9.3 1. Could Figure 9.5 be described in the form of binary relationships? Discuss. 2. What mapping rules would you follow to map Figure 9.5? 3. Map Figure 9.5 to a relational database and show some sample data. Chapter 9 Excercises 9.3 In this chapter we are focusing on ER Diagrams with Binary Relationships. Using three entities—INSTRUCTOR, CLASS, and ROOM—draw an ER diagram that depicts the following: Each CLASS in a ROOM has one INSTRUCTOR, but each INSTRUCTOR in a room may have many CLASSes, and each INSTRUCTOR of a CLASS may be in many ROOMs. [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: