Following is an ORM model for customer. Map the schema to a relational database schema. Any possible constraints need to be included (e.g., primary key, foreign key).

Write the relations clearly showing the Primary key bolded and underlined (e.g., CustomerId).

Foreign key shown in italics (e.g., OrderNumber ) and separately defined beneath the relation (e.g. ShoppingCart OrderNumber FK to Order OrderNumber).

1 Phone Name Email DOB (dmy) Has Has First Name [FirstName] Has Last Name [Surname] Has [BranchName] Has Has Address Has Employee (.ld) Branch (.code) Job Allocation Belongs to Works Has Has Has Has Street no Has Street (.name) Suburb (.name) State (.code) Role (.Code) Description Has Has PostCode PayScale (.Code) [APS 1,2,3,4,5]