✓ Kizspy. me - 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.
Doctors
Doctor D
FullName
Specialty
Email
Medical Records
RecordID
PatientID
DoctoriD
AppointmentID
Diagnosis
Treatment
Phone
ExperienceYears
Notes
Appointments
AppointmentID
RecordDate
PatientID
Doctor D
AppointmentDate
Billina
Status
BilliD
Notes
PatientID
CreatedAt
AppointmentID
TotalAmount
PaidAmount
PaymentStatus
BillDate:
Zoom
+ 100%
Prescriptions
PrescriptionID
Patients
PatientID
FirstName
LastName
DateOfBirth
Gender
Email
Phone
Address
BloodType
PatientID
DoctorID
RecordID
Medicine
Dosage
Instructions
PrescriptionDate
Close
