Relational Database Systems COMP 1005 - Design the logical

Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal strategies for efficient management of databases.

Intended Learning Outcomes covered:

1. Design the logical structure of a database using Entity-Relationship diagram.

2. Apply normalization techniques to reduce redundancy in a database.

Task 1:

Complete the work proposal in Microsoft Word file format (may include possible answers based on your initial understanding). Work proposal for the assignment must be submitted before the end of week 7 and must include:

a) Understanding of deliverables - a detail description of deliverables.

b) General overview of proposed plan - initial understanding of solution to task 2 which includes, the name of entities, associative entities and relationships and a brief write up on the concept of referential integrity. Initial understanding of solution to task 3 which includes the process to be followed for normalization and a brief write up on the concept of data integrity.

c) Timeline and references for completion of task 2 and task 3.

Task 2:

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, time and location. Each participant can be identified by their ID and has name, address and contact number. An event can have any number of participants but a participant belongs to one event only.

The Festival offers several commercial shops to promote the business sectors in Oman. A shop can be owned by one vendor and a vendor can own any number of shops. Each shop is given a unique identification number, name, location and an in-charge. A vendor is identified by a vendor ID, and has name, address and phone number. Once a visitor visits the shop, the details of the visitor such as name, contact number, address and resident ID number, which is unique to every visitor will be recorded. A shop can have one or many visitors, a visitor may visit one or more shops. Whenever a visitor visits a shop, the date and amount he spent will be recorded to track the profit of the outlet.

The festival also offers different rides for children. Each ride has a unique ID, name, and price. A visitor can use any number of rides, or may not use any ride. A ride can be played by any number of visitors or need not be used at all. In addition to the rides and shops, the visitors may also participate in events. The Festival organizers have imposed a condition that each visitor should participate in an event only once or may not participate at all, but an event may have any number of visitors.

a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, associative entities, attributes of each entity including primary key, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design.

b) Analyze the above given scenario and discuss about the possible structure of the relations (the number and name of the columns, datatypes etc.) and any integrity constraints to be implemented in the above design. State any assumptions necessary to support your design.

Task 3:

a) Normalize the below given Form to First Normal Form, Second Normal Form and Third Normal Form. Make assumptions for the identification of the primary key wherever necessary.

b) Give a reflection of how referential integrity is implemented in the process of normalization. Support your answer with reference to the above Question. (At least 400 words)

Task 4:

Be ready for a written viva to demonstrate your knowledge with the different concepts used in preparing the assignment. Schedule for the written viva will be announced in the class and on Moodle/MEC mail. Marks for task 2 and task 3 will depend on the satisfactory pass for the demonstration in task 4.

Guidelines

Follow the guidelines mentioned below for your assignment.

- Submit a work proposal detailing aspects such as initial understanding of the given tasks, timelines to complete each task, literature sources for solving the tasks.


- Assignment should be typed and uploaded to Moodle and will undergo plagiarism detection test through Turnitin (a plagiarism detection tool)
- - Handwritten assignments will not be accepted.
- Assignment should have a Title Page. Title Page should contain the following information.
 Assignment Name
 Class
 Student name
 Student ID
- It should have Table of Contents
- Use page numbers
- Assignment should be typed in your own words using Times New Roman font size 12.
- Heading should be with Font Size 14, Bold, Underline - Use Diagrams and Examples to explain your topic.
- Copy paste from the Internet or other student work is strictly not acceptable.
- References should be included in the last page as follows
 Author name, Book Title, Publisher, Year in case of books
 In case of web site references type the full path of the web page with referenced date
 In case of journals/magazines/periodicals type article name, magazine name, Issue Number and date


Order Assignment gulfassignmenthelp Rated 4.9 / 5 based on 22789 reviews.
  • Rahat

    Dear beloved team I can’t find enough words to thank your squad of the team. After receiving the assignment, I am bound to say that you need to say anything in your praise as the work you are providing to the students speaks for you — the work I received I was non-plagiarised and helped me to get appreciation from my class teacher also. It was because of your writers only that I gained this appreciation and I am here to pay my regards to them as all of this was possible just because of them.

  • Tariq

    Hello Dear Students You can get this “Relational Database Systems COMP 1005 - Design the logical structure of a database using Entity-Relationship diagram and Apply normalisation techniques” assignment done by our excellent pool of tutors who are having their masters and PhDs in Computer Science. They can draft a perfect solution file for you since they have years of experience in writing assignments for college students and they also have industrial experience in this field of Relational Database. So we make sure that our clients that they will get all the ER diagrams explained well and the tables will be inevitably normalised. Our Tutors know that it is complicated to understand the concept of normalization, so we also provide online tutoring sessions to make the ideas clear. We cater all these services at a very nominal rate, and innumerable students have thanked our company for keeping such low prices. This service allowed all the students to opt for our services without digging much into their pockets.

Captcha

Seeking Trusted Advice of High Skilled Tutors for Gulf Assignments? Order Now