Question
This assignment should be done in SQL Based on the relational schema (3NF) from the diagram on the picture, analyze the tables, their relationships, and
This assignment should be done in SQL
Based on the relational schema (3NF) from the diagram on the picture, analyze the tables, their relationships, and the sample data below:
a. CREATE THE TABLES, using the best data types based on analysis. Follow each table name with an underscore and your first, middle, and last initials (if you do not have a middle initial, use X). For example, if your name is Alice B Chandler, table name would be named the Patient table PATIENT_abc. Also, keep in mind that foreign key relationships require the same data types on both sides (e.g., if declared PatientID as INTEGER in the Patient table, it must be declared as INTEGER in the Rental table, too).
b. Execute a DESCRIBE statement for each table to show its general structure.
PATIENT REASON ApptReasonCode ApptReasonDesc PatientID PatientFName PatientLName PatientPhone APPTDETAIL APPOINTMENT ApptiD ApptReasonCode BlockCode ApptDate ApptTime PatientID DoctoriD BillingType InsColD ApptStatusCode 0O DOCTOR DoctorlD DoctorFName DoctorLName BLOCK BlockCode BlockDesc BlockTime BILLINGTYPE BillingType BillingTypeDesc INSCO InsColD InsCoName STATUS ApptStatusCode ApptStatusDescStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started