SmartExpert

(118)

$30/per page/Negotiable

About SmartExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,English,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 57 Weeks Ago
Questions Answered: 7570
Tutorials Posted: 7352

Education

  • BS,MBA, PHD
    Adelphi University/Devry
    Apr-2000 - Mar-2005

Experience

  • HOD ,Professor
    Adelphi University
    Sep-2007 - Apr-2017

Category > Business & Finance Posted 27 Jan 2019 My Price 6.00

A small surgery center needs your help to cre ate a database

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

  1. Please identify the attributes and primary keys needed for each of the entities.
  2. Identify the Data Types you would use for each of the Attributes.
  3. 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
  4. Create an ER diagram using Visio based on your analysis.
  5. Identify all foreign keys needed in the database design.
  6. Create the database in Access and populate the tables.
  7. To use the database as the main office application, what other entities and attributes might be needed?

Answers

SmartExpert
(118)
Status NEW Posted 27 Jan 2019 08:01 PM My Price 6.00

Dat-----------aba-----------se -----------Des-----------ign-----------

Attachments

file 1548623263-Database Design.docx preview (325 words )
D-----------ata-----------bas-----------e D-----------esi-----------gn ----------- Na-----------me ----------- Co-----------urs-----------e T-----------itl-----------e a-----------nd -----------Num-----------ber----------- P-----------rof-----------ess-----------orâ-----------€™s----------- Na-----------me ----------- Da-----------te ----------- -----------DAT-----------ABA-----------SE -----------DES-----------IGN----------- P-----------rim-----------ary----------- Ke-----------ys -----------and----------- At-----------tri-----------but-----------es ----------- Th-----------e p-----------rim-----------ary----------- ke-----------ys -----------wil-----------l i-----------ncl-----------ude-----------, D-----------oct-----------orâ-----------€™s----------- ID-----------, P-----------ati-----------ent-----------s I-----------D, -----------and----------- pr-----------oce-----------dur-----------es -----------ID,----------- an-----------d A-----------ppo-----------int-----------men-----------t I-----------D. ----------- Da-----------ta -----------typ-----------es -----------for----------- ea-----------ch -----------ent-----------ity----------- P-----------ati-----------ent-----------s e-----------nti-----------ty -----------–----------- pa-----------tie-----------nts----------- fi-----------rst----------- an-----------d l-----------ast----------- na-----------mes-----------, n-----------ame----------- of----------- ki-----------n, -----------dat-----------e o-----------f b-----------irt-----------h, -----------pos-----------tal----------- ad-----------dre-----------ss,----------- so-----------cia-----------l s-----------ecu-----------rit-----------y n-----------umb-----------er,----------- se-----------x, -----------con-----------tac-----------t n-----------umb-----------er.----------- D-----------oct-----------or -----------ent-----------ity----------- â€-----------“ N-----------ame----------- of----------- do-----------cto-----------r, -----------doc-----------tor-----------
Not Rated(0)