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

Document Content and Description Below

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, an... d 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 [Show More]

Last updated: 1 year ago

Preview 1 out of 6 pages