Business > CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago Attachments area 100% P (All)

BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago Attachments area 100% PASS

Document Content and Description Below

Team Case Study Team Case Study: Database Design BIS245 Team Case Study DATABASE DESIGN Primary Keys and Attributes The primary keys will include, Doctor’s ID, Patients ID, and proce... dures ID, and Appointment ID. Data types for each entity Patients entity – patients first and last names, name of kin, date of birth, postal address, social security number, sex, contact number. Doctor entity – Name of doctor, doctor work ID, area of speciality. Appointment entity – Appointment, name of doctor ID, patient ID, Date, Time. Medical Procedure entity – Medical procedure ID, Order Number, Patient ID, doctor ID, Treatment ID Treatment entity – Treatment ID, Fee, type of treatment Entity relationships explained The patient can have many doctors representing a many too many to one relationship. The doctor can order several tests representing a one to many relationships. One doctor performs a single procedure per patient making it a one to one relationship. Team Case Study ER diagram This study source was downloaded by 100000831157179 from CourseHero.com on 09-13-2021 04:34:26 GMT -05:00 Team Case Study Relationships between the entities Team Case Study Database tables Patients table Field Data Type Key Constraint Patient _treatment no (11) INT PK Not Null Name Varchar (100) Not Null contact Varchar (100) Not null Phone Varchar (100) Not null Insurance_ID Varchar (100) Not null Sex Varchar (20) Not Null DOB Varchar (100) Not Null Doctor’s table Field Data type KEY Constraint Doctor ID Int (11) Pk Not Null Doctor Name Varchar (50) Not Null Speciality Varchar (100) Not Null Patient appointment table Field Data Type Key Constraint Appointment_ID INT (11) PK Not Null Doctor_ID INT (11) Not Null Patient_ID INT (11) Not Null Date INT (11) Not Null Time INT (11) Not Null Medical Procedure Table Team Case Study Field Data Type Key Constraint Medical_procedure_I D INT (11) PK Not Null Order_Number INT (11) Not Null Pasinetti INT(11) Not Null Doc_ID INT (11) Not Null Treatment_ID INT(11) Not Null Treatment table Field Data Type Key Constraint Treatment_ID INT (11) PK Not Null Treatment_fee INT (11) Not Null Treatment_name INT Varchar (200) Not Null Note: Foreign keys include: Patient_ID, Doctor_ID, and Treatment_ID. References Cason, S. P., & Musa, M. A. (2000). U.S. Patent No. 6,035,300. Washington, DC: U.S. Patent and Trademark Office. Harrington, J. L. (2009). Relational database design and implementation: clearly explained. Morgan Kaufmann. Wilson, A., & Childs, S. (2002). The relationship between consultation length, process and outcomes in general practice: a systematic review. Br J Gen Pract [Show More]

Last updated: 1 year ago

Preview 1 out of 6 pages

Reviews( 0 )

Recommended For You

 Business Administration> CASE STUDY > BIS 245 Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A (All)

preview
BIS 245 Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A

BIS 245 Small Surgery Center Case Study Week 3-5 BIS 245 Small Surgery Center Case Study Week 3-5 Scenario A small surgery center needs your help to create a database. The office manager has identi...

By Expert1 , Uploaded: Oct 15, 2019

$10.5

 Mathematics> CASE STUDY > Strayer MAT 543 Week 9 Case Study 2: Quality Analysis_2019 latest Case Study Guide_Already Graded A (All)

preview
Strayer MAT 543 Week 9 Case Study 2: Quality Analysis_2019 latest Case Study Guide_Already Graded A

Thomas Jefferson University is experiencing a higher than usual number of complaints from students who utilize the campus’ walk-in urgent care clinic. This paper will discuss and analyze the wait time...

By Expert#1 , Uploaded: Sep 16, 2019

$4

 Business Administration> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago

DATABASE DESIGN Primary Keys and Attributes The primary keys will include, Doctor’s ID, Patients ID, and procedures ID, and Appointment ID. Data types for each entity Patients entity – patients...

By Professor Lynne , Uploaded: Sep 28, 2021

$10

 Medical Studies> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago Attachments area (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago Attachments area

Team Case Study Team Case Study: Database Design BIS245Team Case Study DATABASE DESIGN Primary Keys and Attributes The primary keys will include, Doctor’s ID, Patients ID, and procedures ID, and...

By Dr Medina Reed , Uploaded: Sep 25, 2021

$10

 Business> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago

BIS 245 Small Surgery Center Case Study Week 3-5 BIS 245 Small Surgery Center Case Study Week 3-5 Scenario A small surgery center needs your help to create a database. The office manager has identifie...

By Muchiri , Uploaded: Sep 13, 2021

$10

 *NURSING> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University,

BIS 245 Small Surgery Center Case Study Week 3-5 BIS 245 Small Surgery Center Case Study Week 3-5 Scenario A small surgery center needs your help to create a database. The office manager has identifie...

By LAVIE , Uploaded: Sep 02, 2021

$10

 Business Administration> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A LATEST FOR 2021/2022 (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A LATEST FOR 2021/2022

BIS 245 Small Surgery Center Case Study Week 3-5 BIS 245 Small Surgery Center Case Study Week 3-5 Scenario A small surgery center needs your help to create a database. The office manager has identi fi...

By Tutor Frankline , Uploaded: Aug 08, 2021

$15

 Business Administration> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A LATEST FOR 2021/2022 (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A LATEST FOR 2021/2022

BIS 245 Small Surgery Center Case Study Week 3-5 BIS 245 Small Surgery Center Case Study Week 3-5 Scenario A small surgery center needs your help to create a database. The office manager has identi fi...

By A+ Grades , Uploaded: Aug 09, 2021

$15

 Database Management> CASE STUDY > BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A ( 2021) (All)

preview
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A ( 2021)

BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago. Graded A BIS 245 Small Surgery Center Case Study Week 3-5 BIS 245 Small Surgery Center Case Study Week 3-5 Scenario A smal...

By QUIZ BIT , Uploaded: Jun 28, 2021

$9.5

 Business> CASE STUDY > Case Economic For Leader Documents MBA 5501 Unit 2 Case Study guidelines- (All)

preview
Case Economic For Leader Documents MBA 5501 Unit 2 Case Study guidelines-

Part 1. Evaluate the case and respond to each of the questions below using both theory and practical managerial thinking.Part 2. Complete a case analysis of Microsoft. This requires that you conduct r...

By ProfXams , Uploaded: Jun 19, 2021

$14.5

$8.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
87
0

Document information


Connected school, study & course



About the document


Uploaded On

Sep 21, 2021

Number of pages

6

Written in

Seller


seller-icon
Nutmegs

Member since 2 years

570 Documents Sold


Additional information

This document has been written for:

Uploaded

Sep 21, 2021

Downloads

 0

Views

 87

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

custom preview

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

custom preview

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·