BIS 245 Team Case Study (BIS 245 Team Case Study)
Devry University-Chicago
Aquí están los mejores recursos para pasar BIS 245 Team Case Study (BIS 245 Team Case Study). Encuentra BIS 245 Team Case Study (BIS 245 Team Case Study) guías de estudio, notas, tareas, y mucho más.
2 resultados
Caso
DeVry University, Chicago - BIS 245: Case Study Guide - Small Surgery Center A+ GUIDE
DeVry University, Chicago - BIS 245: Case Study Guide - Small Surgery Center A+ GUIDE 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 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 – Appoin...
Caso
Bis 245 Team Case Study Database Design
PopularBIS245 
Team Case Study 
 
DATABASE DESIGN 
Primary Keys and Attributes 
The primary keys will include, DoctorID, AppointmentID, MedicalProcedureID, and PatientID. 
Attributes for each entity 
Patient entity –Names, Contact, DOB, InsuranceID Sex, and Phone. 
Doctor entity – DoctorID, DoctorName, and Speciality. 
Appointment entity – AppointmentID, DoctorID, Patient ID, Date, and Time. 
Medical Procedure entity – MedicalProcedureID, OrderNumber, PatientID, DoctorID, and TreatmentID 
Trea...