ASSIGNMENT 3 DATABASE SCHEMA

In the previous assignment, you identified the classes associated with the business events. Use the solution from the previous assignment to complete this homework.

SOLUTION FROM PREVIOUS ASSIGNMENT (TABLES WITH ATTRIBUTES):

Using the domain model class diagram completed in the previous assignment (displayed above), develop a Relational Database Schema. In the schema, identify the primary and foreign keys for each table. You may need to add a key field if there isnt an attribute that could logically serve as the key. Remember that a candidate key for an association class is the combination of the keys of the connected classes. However, it may make sense to define a shorter, more concise key field. Verify that each table is in third normal form (3NF).

RealEstateOffice RealEstate Agent bfficeNumber name Office Manager address phone agent Number name address bffice Phone cellphone JemailAddress Owner owner Name ownerAddress ownerPhone ForSaleListing Structures Listing asking Price soldPrice description yearBuilt square Feet number Bedrooms numberBathrooms isting Number Address statusCode date Listed date Sold dateUnlisted ForLease Listing rentalAmount rentedAmount dateAvailable furnishings Desc utilitiesDesc