BIS 245: Case Study Guide - Small Surgery Center - DeVry University, Chicago
BIS 245: Case Study Guide - Small Surgery Center - DeVry University, ChicagoACCESS DATABASE DESIGN 2 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, and the Doctor’s area of expertise. 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 Entity Relationships: 1. Many procedures can be assigned to one doctor (many to one). 2. Doctors can perform many procedures to one patient (many to one). 3. Patients can have many appointments (one to many), see many doctors (one to many) and undergo multiple procedures (one to many). 4. There are no many to many relationships in this database. 5. Many appointments can be assigned to one doctor (many to one). This study source was downloaded by from CourseH on :46:14 GMT -06:00 ACCESS DATABASE DESIGN 3 e procedure per patient making it a one-to-one relationship. ER diagram
Document information
- Uploaded on
- December 5, 2022
- Number of pages
- 6
- Written in
- 2022/2023
- Type
- Case
- Professor(s)
- Unknown
- Grade
- A+
