This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Copyright AWL2004 1 Chapter 7: Relational Database Design by ER- and EER-to-Relational Mapping SHIP_MOVEMENT SSNAME DATE TIME LONGITUDE LATITUTE PORT S_C_NAME PNAME S_O_L_NAME VISIT VSNAME VPNAME STARTDATE ENDDATE f.k. f.k. f.k. f.k. f.k. f.k. f.k. 7.5 Map the BANK ER schema of Exercise 3.23 (shown in Figure 3.17) into a relational schema. Specify all primary keys and foreign keys. Repeat for the AIRLINE schema (Figure 3.16) of Exercise 3.19 and for the other schemas for Exercises 3.16 through 3.24. Partial Answer: BANK CODE NAME ADDR ACCOUNT ACCTNO BALANCE TYPE BCODE BNO CUSTOMER SSN NAME PHONE ADDR LOAN LOANNO AMOUNT TYPE BCODE BNO BANK_BRANCH BCODE BRANCHNO ADDR A_C SSN ACCTNO L_C SSN LOANNO f.k. f.k. f.k. f.k. f.k. f.k. f.k. f.k. f.k. Pre-Publication Material: This is draft manuscript yet to be copy edited or paged. Copyright AWL2004 2...
View Full Document
This note was uploaded on 03/21/2010 for the course CS 145 taught by Professor Markjan during the Spring '10 term at Abilene Christian University.
- Spring '10
- Relational Database