Assume you are designing a data model for a property rental agency that helps customers find houses and apartments they want to rent. You interviewed the manager and collected a sample to present the data. The interview is shown in Figure 1. You also have collected an example of how a property is given to a customer (Figure 2)
Figure 1: An interview with the real-estate agency
Figure 2: A sample form used by the real-estate agency
Based on the interview and the sample, you are required to work on the following:
A) Ask another interview question that may be helpful in obtaining more data.
B) A list of subjects (tables) extracted from the interview (Figure 1) and the data sample (Figure 2). Document the process of extracting the tables from the interview script and the data sample. For instance, you may underline the subjects (e.g., table names). Also, ensure to remove the duplicated table names if they exist.
C) A list of characteristics (fields) extracted from the interview (Figure 1) and the data sample (Figure 2). For instance, you may underline the characteristics (e.g., field names). Also, ensure to remove the duplicated field names if they exist.
D) Table Structures (Tables with fields associated with them). This is a diagram listing the table names and associated fields underneath them. Provide a description for each table.
E) An E-R diagram showing the tables, fields, the relationships between the tables, the participation types, and degrees. Provide a brief explanation for each relationship (relationship type, participation type, and degree) and justify your choices. Apply normalization if needed.
Submission
Submit a report (single PDF file) that has the following sections:
Interview Question.
A list of Subjects (Tables).
A list of Characteristics (Fields).
Table Structures.
An E-R diagram.
Keys (including foreign keys, and relationship matrix)
Submission deadline: 17th February, 2025
Learning Outcomes:
#LO1_FundamentalDataModel: Design a data model that is accurate, complete, and fulfills the system requirements.
#LO2_DataNormalization: Apply data normalization concepts to structure the data and reduce redundancies
Instructions for Students
You can use AI tools (such as ChatGPT or Bard) to help answer the questions. You must only utilize the data modelling concepts that have been instructed in class thus far to receive complete credit. Answers with advanced concepts not covered in the course will get a score of 0. In addition, you must understand every single line of submitted answer. The extent to which you know the answer will be used to evaluate the assignment. · If you have used an AI tool (e.g., ChatGPT, Bard), please report the prompts you used to help you in this assignment.
Make sure that you submit your original work. Suspected plagiarism cases will be treated as possible academic misconduct and will be reported to the College Academic Integrity Committee for formal investigation. As part of this procedure, your instructor may require you to meet with them for an oral exam on the assignment.
Failure to comply with the instructions will result in a 0 grade on the relevant portions of the assignment. Your instructor will grade your submission based on what you submitted on Forum within the allowed deadlines. Do not submit your assignment via email. Failure to submit an assignment or submitting an assignment for another student from the same class or another class will result in a 0 grade without the opportunity to resubmit.
List any assumptions you have made about concepts not explicitly mentioned in the assignment.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|