Map the BANK ER schema of Exercise 7.23 (shown in Figure 7.21) into a relational schema. Specify all primary keys and foreign keys. Repeat for the AIRLINE schema (Figure 7.20) of Exercise 7.19 and for the other schemas for Exercises 7.16 through 7.24.
What will be an ideal response?
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.
You might also like to view...
A general path is ________.
a. a set of polylines that do not result in a closed shape b. a shape constructed from straight lines and complex curves c. the shape of the curve in a font’s characters d. represented by an object of class GraphicsPath
Briefly describe the basic hybrid network model.
What will be an ideal response?
A cell that contains a comment is marked with a green triangle
Indicate whether the statement is true or false
Define the term latency.
What will be an ideal response?