Running head: CASE STUDY 1
Case Study
Jonathan Lau
BIS245
This study source was downloaded by 100000836386117 from CourseHero.com on 12-14-2021 12:14:32 GMT -06:00
https://www.coursehero.com/file/48516640/Case-Study-BIS245-Jonathan-Laudocx/
, CASE STUDY 2
Case Study
Attributes, Primary Keys and data type of Each Entry
Patients’ Table
The primary key is the patient ID, which populates the numbers as the patients visit the
surgery center. The patients’ table has eight attributes: Patient ID, surname, first name, age, date
of the first visit to the surgery center, symptoms, residence, and the name of the doctor. Every
attribute has a particular data type. The surname is a short text, the first name is a short text, age
is a number, and date of the first visit is a date and time data type. The symptoms are a short text,
the residence is a short text, and doctor’s name is a short text data type.
Doctors’ Table
The doctor’s table has seven attributes: The staff number, surname, first name, terms of
employment (whether on contract or permanent), the salary scale, terms of service (whether full
—time or part-time), and the age. The staff number is the primary key. Every attribute has a
specific data type. Staff number is a number, surname is a short text, first name is a short text,
terms of employment is a short text, salary scale is a number, form of service is a short text, and
age is a number.
Procedures’ Table
The procedures’ table has the patient ID as its primary key. There are six attributes in the
table: The patient ID, date of first visit, diagnosis, symptoms, doctor’s staff number and
recommended treatment. Every attribute as a unique data type. Patient ID is a number, date of
first visit is a time & date format, diagnosis is a long text, symptoms is a short text, doctor’s staff
number is a number, and recommended treatment is a short text.
Appointments’ Table
This study source was downloaded by 100000836386117 from CourseHero.com on 12-14-2021 12:14:32 GMT -06:00
https://www.coursehero.com/file/48516640/Case-Study-BIS245-Jonathan-Laudocx/
Case Study
Jonathan Lau
BIS245
This study source was downloaded by 100000836386117 from CourseHero.com on 12-14-2021 12:14:32 GMT -06:00
https://www.coursehero.com/file/48516640/Case-Study-BIS245-Jonathan-Laudocx/
, CASE STUDY 2
Case Study
Attributes, Primary Keys and data type of Each Entry
Patients’ Table
The primary key is the patient ID, which populates the numbers as the patients visit the
surgery center. The patients’ table has eight attributes: Patient ID, surname, first name, age, date
of the first visit to the surgery center, symptoms, residence, and the name of the doctor. Every
attribute has a particular data type. The surname is a short text, the first name is a short text, age
is a number, and date of the first visit is a date and time data type. The symptoms are a short text,
the residence is a short text, and doctor’s name is a short text data type.
Doctors’ Table
The doctor’s table has seven attributes: The staff number, surname, first name, terms of
employment (whether on contract or permanent), the salary scale, terms of service (whether full
—time or part-time), and the age. The staff number is the primary key. Every attribute has a
specific data type. Staff number is a number, surname is a short text, first name is a short text,
terms of employment is a short text, salary scale is a number, form of service is a short text, and
age is a number.
Procedures’ Table
The procedures’ table has the patient ID as its primary key. There are six attributes in the
table: The patient ID, date of first visit, diagnosis, symptoms, doctor’s staff number and
recommended treatment. Every attribute as a unique data type. Patient ID is a number, date of
first visit is a time & date format, diagnosis is a long text, symptoms is a short text, doctor’s staff
number is a number, and recommended treatment is a short text.
Appointments’ Table
This study source was downloaded by 100000836386117 from CourseHero.com on 12-14-2021 12:14:32 GMT -06:00
https://www.coursehero.com/file/48516640/Case-Study-BIS245-Jonathan-Laudocx/
