CSC 455 Chapter 4 Lab

A modified ER diagram for the bank scenario is below.  Map it to a database schema breaking down any composite attributes into their atomic forms.  Hand in your schema on paper or submit into BB.  Be sure to identify primary keys by underlining them.  Identify foreign keys using dot notation.

Flowchart: Decision: To

1
 
Oval: dateOval: amountOval: Payment_no - - - - - - - - - - - - -

Balance
 

1
 

M
 

M
 
Text Box: PAYMENTFlowchart: Decision: MakesDescription: Description: fig03_21

 

 

In class example: Map this diagram to a schema. Assume and include standard attributes for student (You do not need to hand this in.)