Solution-Needs your help to design database

Needs your help to design database

Assignment Help Basic Computer Science

Reference no: EM131646872

Scenario

A small surgery center needs your help to design database. The office manager has identified the following types of data (entities): Patients, Doctors, Procedures and Appointments.

Please identify the attributes and primary keys needed for each of the entities.
Identify the Data Types you would use for each of the Attributes.
Determine the relationships between the entities and find the one-to-many and many-to-many relationships.Use the ER Matrix to determine the relationships
Create an ER diagram using Visio based on your analysis.
Identify all foreign keys needed in the database design.
Create the database in Access and populate the tables.
To use the database as the main office application, what other entities and attributes might be needed?

Activities

Complete the case study's tasks which includes a completed Access database, Visio diagram, and a Word file reporting the results of the analysis and the additional entities needed to use the database as the main office application.

Reference no: EM131646872

Questions Cloud

Desribe the each sampling method for given statements : We need to survey a random sample of the 300 passengers on a flight from San Francisco to Tokyo. Name each sampling method described below.

Choice of operating systems : Desrcibe whether the processes that were followed to complete the activity would influence the choice of operating systems.

Basics of socket programming for tcp connections : Basics of socket programming for TCP connections in Python: how to create a socket, bind it to a specific address and port - basics of HTTP header format

Define the gossip paper the gossip gazette : You receive a message the next morning from a peer at work that there is a big investigation being conducted at work due to a HIPAA violation

Needs your help to design database : A small surgery center needs your help to design database. The office manager has identified the following types of data (entities): Patients, Doctors

Write a paper that analyzes a products advertising campaign : Write a 12-15 pages paper that analyzes a product's advertising campaign. The analysis of the product's advertising campaign.

Odbc and jdbc database interfaces : Why is it important to have effective and powerful interfaces like these for databases?

What kind of design ropers are using : Roper. Through their Roper Reports Worldwide, GfK Roper conducts a global consumer survey to help multinational companies understand different consumer.

Fundamentals for the cultivation of life : Describe the advantages and disadvantages (for the individual, for the family, and for the state) of ONE of the following positions.

User Account

All Pages

Needs your help to design database

Reference no: EM131646872

Reference no: EM131646872

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT