Medicalprocedureid Study guides, Class notes & Summaries

BIS245Team Case Study

BIS245 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...