Reference no: EM132511622

COMP 20002 Fundamentals of Relational Database Management Systems - Middle East College

Learning Outcome 1: Creating visual representation of the logical structure of a database using Entity- Relationship diagram.
Learning Outcome 2: Apply normalization techniques to reduce redundancy in a database.

This is an individual assignment aimed to give the student exposure to the Entity Relationship Diagram and the concepts of Normalization.

Problem 1:
1) Submit a work proposal for this assignment or before 09/05/2020 (23:59) which must include:
• Understanding of deliverables - a detail description of deliverables.
• General overview of proposed plan - initial understanding of solution to task2.
• Timeline and resources required for completion of the given tasks.
The work proposal must be submitted in a word file through the link available in Moodle.

Problem 2:

You may choose any one organization in Oman to solve this task.
a. For the chosen organization, find the data needs, you may use different sources of information for the data collection such a : website of the company, publications about the company in newspapers, magazines, specialized journals, if needed you may also conduct interview with company's representatives. After analyzing the data needs, you have to write a detailed scenario, containing at least four entities, their attributes and the relationships between them in the organization with appropriate cardinality constraints. You have to also identify at least one associative entity in the scenario. Use appropriate citations and references on the data collected from various source.

b. Construct the Entity Relationship Diagram (ERD) for the drafted scenario in the above task. Include all the entities, attributes of each entity assuming the primary key and not null constraints, relationship between the entities with cardinality constraints.
The ERD is expected to have:

i. Minimum 4 Entities with suitable attributes and constraints.
ii. Minimum one associative entity with attributes and referential constraints.
iii. Minimum 5 relationships between the identified entities with appropriate names and cardinality constraints.
iv. All the Primary keys in the all entities are properly identified and marked.

Problem 3:
Normalize the below given voyage attendance report to First Normal Form, Second Normal Form and Third Normal Form. Make assumptions for the identification of the primary key wherever necessary.

Attachment:- Fundamentals of Relational Database Management Systems.rar