Everything provided below

Based on the interview in Figure 1 and the sample booking in Figure 2, complete the following:

1. Additional Interview Questions

• Propose additional interview questions that would help gather more data requirements for the system to help identify relationships, attributes or deletion rules.

2. Identify Subjects (Tables)

• Extract a list of subjects (tables).
• Clearly document how each table was identified from the interview and booking sample (e.g., underlining or highlighting).
• Remove any duplicate table names.

3. Identify Characteristics (Fields)

• Extract the list of characteristics (fields) for each table.
• Remove duplicate fields where applicable.

4. Table Structures

• Create table structures showing table names and their associated fields.
• Clearly identify primary keys and foreign keys.
• Provide a short description for each table.

5. Populate Tables

• Populate each table with three realistic records.

6. Normalization (Up to 3NF)

• Ensure all tables are normalized up to Third Normal Form (3NF).
• Provide a clear justification explaining how 1NF, 2NF, and 3NF are achieved for each table.

7. Relationship Matrix

• Create a relationship matrix.
• Justify each relationship by explaining:
• Relationship type.
• Participation type and degree.
• Foreign key specification forms.

8. Entity-Relationship Diagram (ERD)

• Draw an ER diagram showing:
• Entities and attributes
• Relationships
• Participation types and degrees
• Deletion rules

Justify your deletion rules choices.

Submission

Submit a report (single PDF file) that contains all the above requirements.

(Please be advised that submitting more than one file or an external link to an ERD or a Google Document will result in a reduction in your grade.)

Instructions for Students

1. You may use AI tools (such as ChatGPT or Gemini or any other) to help answer the questions. You must only utilize the data modeling concepts that have been taught in class so 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 your submitted work. Please be prepared to explain your work, as you might be called for a technical interview to explain your answers. 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, Gemini …), please submit all the prompts (screenshots) you used to help you in this assignment.
2. Make sure that you submit your own 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.
3. 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 the 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.
4. Clearly list any assumptions you have made about concepts not explicitly mentioned in the assignment.

Assignment Information