Property owners

There are two main types of property owner: private owners and business owners. The data stored on private owners includes owner number, name (first and last name), address, telephone number, email, and password. The data stored on business owners includes owner number, name of business, business type, address, telephone number, email, password, and contact name.

Clients

When a prospective client registers with DreamHome, the data stored includes the client number, name (first and last name), telephone number, email, and some data on the desired property, including the preferred type of accommodation and the maximum rent that the client is prepared to pay. Also stored is the name of the member of staff who registered the new client.

Property viewings

Clients may request to view property. The data stored includes client number, name and telephone number, property number and address, date the client viewed the property, and any comments made by the client regarding the suitability of the property. A client may view the same property only once on a given date.

Question:

1.Design a Fist Cut "Top Down" ERD (do not normalize) based on the initial set of information that has been provided. Show the basic entity relationships without concern for M:N or Crowfoot Notation. Remember the ERD is the initial output of your design process to show to the business and validate your understanding of its needs.

2. Design an ERM (Conceptual Model) Using Crowsfoot Notation (Resolve M:N Relationships and Note Cardinality).

3. Design a Logical Relational Model - Assign Primary and Foreign Keys a) Identify the Types of Entities in Your Model. For example: Composite,

Super-type and Sub-type. Strong vs. Weak. Recursive.

b) Determine Entity Integrity and Referential Integrity (see Entity tables below).