Fundamentals of Relational Database Management Systems
Fundamentals of Relational Database Management Systems
Creating visual representation of the logical structure of a database using Entity-Relationship diagram. And apply normalization techniques to reduce redundancy in a database.
Scenario:
Consider the following scenario modeling project management activities in an organization.
Muscat Festival is conducted every year during spring in the Sultanate of Oman. The festival comprises of many events showcased by participants from various countries. Each event is identified by its unique ID, and has a name and location. Each participant can be identified by their ID and has name, specialization and contact number. An event can have any number of participants but a participant belongs to one event only.
The Festival offers several commercial outlets to develop commercial sectors in Oman. An Outlet can be owned by one registered vender and a vendor can own any number of outlets. Each Outlet is given a unique number, name, location and contact person and a vendor is identified by an ID, and has name and phone number. Once a visitor visits the outlet, the details of the visitor such as name, contact number, address and residence ID number, which is unique to every visitor will be recorded. An outlet can have any number of visitors or it may not have any visitors, a visitor may visit one or more outlets. Whenever a visitor visits an outlet, the date and amount he spent will be recorded to track the profit of the outlet.
The festival also offers different games. Each game has unique ID, name, and price. A visitor can play any number of games, or need not play. A game can be played by at least one visitor or need not be played at all; when a visitor plays a game, score and date will be recorded. In addition to games and outlets, the visitors may also participate in events. The Festival organizers have imposed a condition that each visitor should participate in an event only once, but an event may have any number of visitors.
Task 1:
a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, attributes of each entity including primary key, not null, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design.
b) For the above task, write your refection by describing the ERD in connection with concepts taken from literature in 400 to 500 words. The literature can include conference papers, scholarly articles, text & reference books.
Task 2:
An attachment has been uploaded for Task 2.
*** In-text citations and references CU-Harvard style if available.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
