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.
Zoom
Medical Records
RecordID
AppointmentID
Diagnosis
Treatment
Notes
Record Date
AppointmentTests Appointment TestID
AppointmentID
bo
TestID
Status
Result
Departments
Doctors
DepartmentID
od
DoctorID
FirstName
Appointments
AppointmentID
PatientID
Name
Location
PhoneNumber
LastName
DoctorID
PhoneNumber
AppointmentDate
Email
Reason
00
+ 100%
DepartmentID
Status
Tests
TestID
Name
Description
Cost
Patients
PatientID
FirstName
LastName
DateOfBirth
PhoneNumber
Email
Address
Close
