OWNER (ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME, COMPANY_NAME, EMAIL_ADDRESS, PHONE_NUMBER,TYPE_OF_BUSINESS) PROPERTY (ID, STREET_NUMBER, STREET_NAME, CITY, PROVINCE, ZIP, TYPE, EMPLOYEE_ID, OWNER_ID) EMPLOYEE (ID, NAME, ADDRESS, PHONE, EMAIL, GENDER, POSITION, SALARY, MANAGER_ID, BRANCH_ID) BRANCH (ID, ADDRESS, PHONE) RENTOR (ID, NAME, ADDRESS, PHONE, EMAIL) RENTAL (ID, PROPERTY_ID, RENTER_ID, DATE_SIGNED, START_DATE, END_DATE) VIEWING (ID, PROPERTY_ID, RENTOR_ID, DATE)
OWNER (ID, FIRST_NAME, MIDDLE_NAME, LAST_NAME, COMPANY_NAME, EMAIL_ADDRESS, PHONE_NUMBER,TYPE_OF_BUSINESS)
PROPERTY (ID, STREET_NUMBER, STREET_NAME, CITY, PROVINCE, ZIP, TYPE, EMPLOYEE_ID, OWNER_ID)
EMPLOYEE (ID, NAME, ADDRESS, PHONE, EMAIL, GENDER, POSITION, SALARY, MANAGER_ID, BRANCH_ID)
BRANCH (ID, ADDRESS, PHONE)
RENTOR (ID, NAME, ADDRESS, PHONE, EMAIL)
RENTAL (ID, PROPERTY_ID, RENTER_ID, DATE_SIGNED, START_DATE, END_DATE)
VIEWING (ID, PROPERTY_ID, RENTOR_ID, DATE)
ADVERTISING (ID, NEWSPAPER_NAME, PROPERTY_ID, DATE_OF_AD)
For the above use case for each entity identify their data types and if the fields are required (NOT NULL). Create the ERD document using Word, Excel, PowerPoint documents (or equivalent software) of your choice. Be sure to include Primary/Foreign Key relationship lines between the fields (not the entities) to show the relationship.
This is a
Identifies the proper data types of the attributes and include a required indicator
Proper implementation of Primary Key / Foreign Key Relationship LINES
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
