Running head: CASE STUDY: DATABASE DESIGN 1
Case Study: Database Design
Devry University
BIS 245
2021
, CASE STUDY: DATABASE DESIGN 2
a.
Entities and attributes
1. PATIENTS
Attributes and data types
i. Patient ID – Primary Key (Number)
ii. Patient first Name (Short Text)
iii. Patient last Name (Short Text)
iv. Kin (Short Text)
v. Date of Birth (Date/Time)
vi. Gender (Short Text)
vii. Phone Number (Number)
2. DOCTORS
Attributes and data types
i. Doctor ID – Primary key (Number)
ii. Doctor Name (Short Text)
iii. Specialty (Long Text)
iv. Work ID (Number)
Case Study: Database Design
Devry University
BIS 245
2021
, CASE STUDY: DATABASE DESIGN 2
a.
Entities and attributes
1. PATIENTS
Attributes and data types
i. Patient ID – Primary Key (Number)
ii. Patient first Name (Short Text)
iii. Patient last Name (Short Text)
iv. Kin (Short Text)
v. Date of Birth (Date/Time)
vi. Gender (Short Text)
vii. Phone Number (Number)
2. DOCTORS
Attributes and data types
i. Doctor ID – Primary key (Number)
ii. Doctor Name (Short Text)
iii. Specialty (Long Text)
iv. Work ID (Number)
