Reference no: EM13761608
Design a Relational Database using Entity-Relationship Diagram (ER-D)
Design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.
Apply Normalization to the database design.
Apply Relational Algebra operations on real database.
Create and manipulate relational database systems using SQL.
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
|
Versions of unix
: Early versions of UNIX were available only with a command-driven interface. In more recent years, graphical user interfaces have become popular. Explain in your own words why these GUIs made an impact on the popularity of this operating system.
|
|
Develop a work breakdown structure
: Develop a Work Breakdown Structure (WBS) for the activities of the project using a phase or deliverable approach for determining the format of the WBS
|
|
Four basic financial statements
: 1) Look at the four basic financial statements for any publicly traded corporation. You can find them at the SEC website using their search tool. Find the total assets, liabilities, and shareholders' equity for the most recent year (in the annual ..
|
|
Would image of change chosen affect diagnostic model used
: Would the image of change chosen affect the diagnostic model used? Explain why and how, or why not with examples based on the readings thus far in the course.
|
|
Design relational database using entity-relationship diagram
: Design a Relational Database using Entity-Relationship Diagram (ER-D) and design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models.
|
|
Nursing theorist presentation problems
: The relationship between the theory and the concepts in nursing metaparadigm.
|
|
Explain strings are an important part of programming
: Strings are an important part of programming. They are used to transfer all sorts of data between the user and program, as well as from program to program. Humans communicate with streams because they are flexible enough to encode words and vari..
|
|
What is the value of additional capacity on the polisher
: Western Chassis produces high-quality polished steel and aluminum sheeting and two lines of industrial chassis for the rack mounting of Internet routers, modems, and other telecommunications equipment. What is the value of additional capacity on the ..
|
|
Determine cash generated from operations
: 1) Which financial statement is used to determine cash generated from operations?
|