Subject : Database applications

divide the following field name into three normalized forms in different tables and add primary key and also write data type for these fields. the fields are given below, Data Types on your assignment must be a specific type

(e.g. VARCHAR OR CHAR instead of String, INT or DECIMAL(X,Y) for Number, etc.)

Appointment #

Patient First Name

Patient Last Name

Health Card #

Patient DOB

Patient Gender

Patient Street

Patient City

Patient Province

Patient Postal Code

Patient Phone

Appointment Date

Reminder Required?

Reason For Visit

Visit Length

Medication Prescribe

visit notes

bill amount

bill date

you just need to divide column names into different 3 normalized forms I will add other data