Week 3&4 Assignment.docx - Running head Modeling Data in...

This preview shows page 1 - 7 out of 7 pages.

Running head: Modeling Data in the OrganizationWeek 3&4 AssignmentEnterprise Data and Information Management (BAN 520)Sujitha DindigalaID 21078011Bellevue University
Exercise #22: Entity relationship diagram (ERD) for a real estate firm:
Employee: He is the worker of the firm. An employee works for the sales work place and must handle that work place. Sales Office: It is a realty work place which is sold out.Property: House, Condos, home buildings available.Owner: Independent World Health Organization owns one or many properties.Employee Attributes: Employee ID: It identifies the employee. It must be different.Employee Name: Name of the employee.Sales office attributes:Office number: It is symbol for work place. Office Location: Workplace physical location. This knowledge is also created for sate or town.Property Attributes:Property ID: It is different symbol for the property.Property Location:It is combination of attributes like address, city, state, ZIP code.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture