Reference no: EM132161955
Objective: This is an individual assignment aimed to allow the students to design database systems and apply optimal strategies for efficient management of databases.
Outcome:
1) Creating visual representation of the logical structure of a database using Entity-Relationship diagram.
2) Apply normalization techniques to reduce redundancy in a database.
Task 1:
Submit a work proposal for this assignment by the end of week 8 which must include:
a) Understanding of deliverables - a detail description of deliverables.
b) General overview of proposed plan - initial understanding of solution to task2 and task 3.
c) Timeline for completion of task2 and task 3.
d) Resources required for completion of the assignment.
The work proposal must be submitted in a word file through the link available in Moodle. The proposal can also include draft answers.
Scenario:
Consider the following scenario modeling project management activities in an organization.
Oman science club is an education center in the Sultanate of Oman. It has many offices in Oman, each office is identified by its ID, and has a name, location and contact number. Each office employs many faculties and a faculty belongs to only one office. A faculty can be identified by his ID and has name, qualification and contact number.
Oman science club offers several educative programmes to develop team work and improve their academic skills in children. A faculty can teach one or more programme and a programme is taught by only one faculty. Each programme has a unique ID, name, tenure and venue. Once a child visits the office, the Customer Relation Officer will record the details of the child such as name, contact number, address and residence ID number, which is unique to every child. A child can choose any number of Programme or he may not choose any programme, a programme can be chosen by at least one child. Whenever a child chooses a programme, the date and score will be recorded to track the level of the child. The recreation center also offers different packages such as Abacus, All-round development, communication skills etc. to its children. Each package has unique code, name, term and price. A child can buy any number of packages, or need not buy one. A package will be bought by at least one child; otherwise the office cancels the package. When a child buys a package, the office wishes to record the date to maintain the term of the package.
Task 2:
a) Construct an 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 3:
a. Normalize the below given Item Request Form to UNF, First Normal Form, Second Normal Form, Third Normal Form.
b) Write your refection by describing the normalization process carried in the task above in connection with concepts taken from literature in 400 to 500 words. The literature can include conference papers, scholarly articles, text & reference books.
Be ready for a presentation and Viva to demonstrate your knowledge with the different concepts used in preparing the assignment. Schedule for the presentation will be announced in the class. Marks for task 2-3 will depend on the presentation and viva.
Attachment:- DBMS.rar