1 / 5

National Polytechnic Institute of Cambodia Faculty of Computer Science

National Polytechnic Institute of Cambodia Faculty of Computer Science Practical Learning with Mapping ER to Relational Schema (Chapter 3). Exercise 1 Transform the following ER diagram to a relational schema that shows referential integrity constraints.

lynn
Download Presentation

National Polytechnic Institute of Cambodia Faculty of Computer Science

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Polytechnic Institute of Cambodia Faculty of Computer Science Practical Learning with Mapping ER to Relational Schema (Chapter 3)

  2. Exercise 1 • Transform the following ER diagram to a relational schema that • shows referential integrity constraints. Chapter 3 Practical Learning with Mapping ER to Relational schema 1

  3. Exercise 1 (Solution) Bank A_C Code Addr Name AcctNo SSN ACCOUNT AcctNo Balance Type BCode BNo BANK_BRANH L_C SSN BCode BranchNo Addr LoanNo LOAN LoanNo Amount Type BCode BNo CUSTOMER SSN Name Phone Addr 2 Chapter 3 Practical Learning with Mapping ER to Relational schema

  4. Exercise 2 • Map the following relational schema 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. 5 Chapter 3 Practical Learning with Mapping ER to Relational schema

  5. Exercise 2 (Solution) BookID Title PName PAddress PPhone N 1 B-P BOOK PUBLISHER M AuthorName DateOut BOOK- LOANS BOOK- COPIES NoOfCopies DueDate BranchID N LIBRARY-BRANCH BORROWER CardNo BranchName Address BName BAddress BPhone Chapter 3 Practical Learning with Mapping ER to Relational schema 6

More Related