Do not use any commands having the database name such as create database, alter database, use [database name], etc.
Your response must contain only necessary commands for answering the question. Do not include any other command. For example, if you are required to create a trigger/procedure, then your response should contain only commands for creating the corresponding trigger/procedure; all commands for testing the created trigger/procedure are forbidden.
- Do not use GO command in your code
- On completion, import your work by browsing to the above folder.
- Note that:
+ You could use only SQL Server, SQL Server Management Studio, and paper or offline document in your computer.
+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the sql file which has the following database diagram. Please, run the provided script to create tables and insert data into your database.
Medical Records
AppointmentTests
RecordID
AppointmentID
Appointment TestID AppointmentID
TestID
Diagnosis
Treatment
Status
Result
Notes
Record Date
Departments
Doctors
DepartmentID Name
DoctorID
Appointments
AppointmentID
FirstName
PatientID
LastName
DoctorID
Location
PhoneNumber
PhoneNumber
AppointmentDate
Email
Reason
DepartmentID
Status
Zoom
+ 100%
Tests
TestID
Name
Description
Cost
Patients
PatientID
FirstName
LastName
DateOfBirth
Phone Number
Email
Address
Close
