Relational database using entity-relationship diagram

Assignment Help Database Management System

Reference no: EM132848438

BIT305 Database Management Systems - Emirates College of Technology

Topic - Hospital Management system (Sheikh Khalifa Medical City)

CLO 1: Explain the Basic Database Concepts

CLO 2: Design a Relational Database using Entity-Relationship Diagram (ER-D)

CLO 3: Design a Relational Database by Mapping Entity-Relationship Diagram (ER-D) into Relational Models

Project topic:
Supermarket Management System

Project Task
The project for this module consists of 3phases;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 summarizing the business rules for the business that you are designing database for.

Phase 2: Entity Relationship Diagram (ERD)
Draw an ERD reflecting the elements (entities and attributes) that are described in the scenario. A minimum of 10entities is required.

Phase 3: Mapping
Apply mapping to convert the ERD to a relational Schema.

Project structures:
• Title Page
• Table of Contents (as attached style)
• Introduction
• Database Design for all the phases
• References

Attachment:- Project.rar

Reference no: EM132848438

Questions Cloud

How changes have affected corporations : Compare and contrast the views of management and accountants regarding the changes required by the Sarbanes-Oxley Act on internal controls.

How managerial accounting helps manager to improve financial : Provide one specific, real-life example of how either financial accounting helps external stakeholders make informed decisions or how managerial accounting help

What is the probability that a randomly selected canadian : What is the probability that a randomly selected Canadian has a smartphone or a tablet? 94% 55% 122% 67%

Risk of developing retinopathy in patients : A study was conducted to evaluate whether an intensive therapy program reduces the risk of developing retinopathy in patients with diabetes

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)

How the functions work together in business : Explain the management functions of planning, organizing, leading, and controlling in your own words. how the functions work together in business.

Provide two factors that suggest DDI is acting as an agent : All warranty and any issues after delivery are solely the responsibility of the dealership. Provide two factors that suggest DDI is acting as an agent

How outsourcing entities affect the operation of businesses : Under which management function (planning, organizing, leading, or controlling) would outsourcing and offshoring take place.?

Prepare the journal entries that DSB record transactions : Prepare the journal entries that DSB should record for all the transactions pertaining to Jayne's agreement during 2020

Reviews

len2848438

4/4/2021 9:44:10 PM

Topic about Hospital Management system (Sheikh Khalifa Medical City), Need to follow project structures & consists of 3 phases as the requirement for each and you can see the examples attached and do similar to them, but be sure for Phase 2: Entity Relationship Diagram (ERD) with minimum of 10 entities

Write a Review

Required(*) Message

User Account

All Pages