CHAPTER 7 answers - CHAPTER 7 RELATIONAL DATABASE DESIGN BY ER AND EER-TORELATIONAL MAPPING Answers to Selected Exercises 7.3 Try to map the relational

CHAPTER 7 answers - CHAPTER 7 RELATIONAL DATABASE DESIGN BY...

This preview shows page 1 - 2 out of 2 pages.

CHAPTER 7: RELATIONAL DATABASE DESIGN BY ER- AND EER-TO- RELATIONAL MAPPING Answers to Selected Exercises 7.3 Try to map the relational schema of Figure 6.12 into an ER schema. This is part of a process known as reverse engineering, where a conceptual schema is created for an existing implemented database. State any assumptions you make. Answer: Note: We represented BOOK_AUTHORS as a multi-valued attribute of BOOK in the above ER diagram. Alternatively, it can be represented as a weak entity type. 7.4 Figure 7.7 shows an ER schema for a database that may be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema, and specify all primary keys and foreign keys. Answer: SHIP SNAME OWNER TYPE PNAME
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '08
  • 5odfatrek
  • Relational model, f.k. f.k. f.k, f.k. f.k

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes