Question

Entity Relationship

Diagram
• Total Points: 21
• Consist of three sections
• Section 01: You will create 6 business rules for three fundamental entities – 6
points
• Note: Each entity must have a minimum of 1 Primary key, 1 foreign key, and 4 non-key
fields
• Section 02: Create an ER Diagram that is in Third normal form – 10 points
• Note: The attributes and relationships must be included.
• Section 03: Create a data dictionary for one of the fundamental entities
• Your data dictionary should include the following: Field Name, Field description, Data
Type & Length, and Any constraints imposed on the field

Answer 1

The question pertains to database design, specifically in creating an ERD adhering to Third Normal Form, formulating business rules, and compiling a data dictionary for college level students.

Step-by-step explanation:

The question involves the creation of an Entity Relationship Diagram (ERD) and a corresponding data dictionary for a given set of entities, which is a common task within the field of database design and information systems. In Section 01, the task is to create six business rules for three fundamental entities, ensuring each has at least one primary key, one foreign key, and four non-key fields.

In Section 02, the student is required to construct an ER Diagram that adheres to the Third Normal Form (3NF), which is a design form in database normalization that seeks to prevent data duplication and update anomalies. Finally, in Section 03, the student must create a data dictionary for one of the fundamental entities, detailing field names, descriptions, data types, lengths, and any constraints.

You are required to create a data dictionary for one of the fundamental entities. The data dictionary should include the Field Name, Field description, Data Type & Length, and any constraints imposed on the field. This helps in documenting and understanding the structure and properties of the data in your database.