Question: Database Management Systems - Project Instructions: You are required to accomplish your work in teams provided that each team consists of maximum 4 students. A
Database Management Systems - Project Instructions: You are required to accomplish your work in teams provided that each team consists of maximum 4 students. A hard copy of the project report must be submitted to the instructor. A soft copy of the project report must be submitted through the Moodle Website which is available at https://lms.ectmoodle.ae. The project report should not exceed 15 pages. The submitted SQL code should be run-able on SQL server. Project Task The project for this module consists of 6 phases,. The work of each phase should be documented and submitted to the instructor according to the due date. The tasks for each phase are described below. Phase 1: Scenario (3 marks) Write a scenario summarizes the business rules for the business that you are creating database for. Phase 2: Entity Relationship Diagram (ERD) (3 marks) Draw an ERD reflects the elements (entities and attributes) that are described in the scenario. Phase 3: Mapping (3 marks) Apply mapping to the ERD. Phase 4: Normalization (2 marks) Apply normalization and define the final entities and their attributes. Note: provide justification if normalization is not required for your project. Phase 5: Database Implementation (5 marks) Create the database using SQL. Write all the SQL commands for each table. Write at least 3 SQL commands to select, insert, update or delete a specific data in the database. Phase 6: Presentation (4 marks) Each group members should present their work in front of their classmates. The evaluation of your presentation will be based on the following criteria: - Clarity of demonstration - Utilization of time - Awareness of the contents being presented and the response to examiners questions. The requirements above have to be documented in a report. Project Report Includes Title Page Table of Contents Database Design for all the phases References Proposed Project topics: Course administration System Library Management system Bus station Management system Hospital Management system Supermarket Management System 20 marks to be converted to10 marks.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
