Convert the ERD shown in into tables List the conversion rul

Convert the ERD shown in into tables. List the conversion rules used and table design. For each table, you should list the primary key, foreign keys, other columns, and NOT NULL constraints for foreign keys if necessary. You do not need to write CREATE TABLE statements.

Property Owner StartWeek EndWeek Ownld Propld OwnName -Shares Bldg Name Own Phone UnitNo Bdrms Figure 3: ERD for Conversion Problem 6

Solution

Owner Table:

Primary key:OwnId INTEGER

Not Null:OwnId as primary key cannot be null

OwnName:varchar

===============================================================================

OwnPhone:INTEGER

===============================================

Property Table:

Primary Key: PropId INTEGER

Not Null:PropId as primary key cannot be null

BldgName:varchar

Bdrms:INTEGER

=========================================================================

Table shares

CONSTRAINT PKShares_In PRIMARY KEY (Propid, OwnId),(Not null)

CONSTRAINT FKOwnId FOREIGN KEY (OwnId) REFERENCES Owner,

CONSTRAINT FKPropidN FOREIGN KEY (Propid) REFERENCES Property

Start Week:Varchar or Integer

End Week:Varchar or Integer