Bis 245 team case study - Study guides, Class notes & Summaries

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