Posted: February 1st, 2024

Create and manipulate relational database systems using SQL|Management System

Create and manipulate relational database systems using SQL|Management System

Project Task

The project for this module consists of 6 phases, which should be accomplished within 8 weeks. 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

Write a scenario summarizes the business rules for the business that you are creating database for.

Phase 2: Entity Relationship Diagram (ERD)

Draw an ERD reflects the elements (entities and attributes) that are described in the scenario.

Phase 3: Mapping

Apply mapping to the ERD.

Phase 4: Normalization

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

– 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 & Final Report due date:

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

Order | Check Discount

Tags: Best Research Paper Topics for Examples, Dissertation App, Dissertation Topics for Students in, I need help writing a doctoral thesis online, I need help writing a page paper assignment