Reference no: EM132685366
COMP 20002 Fundamentals of Relational Database Management Systems - Middle East College
1) Design diagrammatic representation of the conceptual structure of a database using Entity Relationship diagram.
2) Apply techniques of normalization to reduce redundancy in a database.
Task 1:
1) Submit a work proposal for this assignment or before 4/11/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 and task3.
• Timeline and resources required for completion of the given tasks.
Task 2:
You may choose/imagine any one tourism companies/organization which are spreads across 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 as website of the company, publications about the company in newspapers, magazines, specialized journals, if needed you may also conduct interview with organization'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.
ii. Minimum one associative entity with attributes and referential constraints.
iii. Minimum 4 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.
Task 3:
Normalize the below given receipt to First Normal Form, Second Normal Form and Third Normal Form Make the appropriate assumptions and provide Justification for the same. The assumptions could be with respect to the identification of the primary keys, data to be inserted in each row of the table (attached).
Attachment:- Fundamentals of Relational Database Management Systems.rar