☑Kizspy.me
Zoom
follows:
1. Create a Solution named MediCareHospital with Library Project (e.g: named
MediCareDomain or MediCareBusiness) (1.0 mark):
Build an application using Entity Framework Core. Create a database using either the Code First
or Database First approach with the following classes and their relationships:
•
•
•
Doctor.cs (contains: DoctorID, DoctorCode, FullName, Specialization, Password)
Patient.cs (contains: PatientID, PatientCode, FullName, Age, Phone)
Appointment.cs (contains: AppointmentID, PatientID, DoctorID, AppointmentDate,
Status)
Notes: Appointment statuses includes: "Scheduled", "Completed" and "Cancelled"
Relationships:
• One Doctor can have multiple Appointments (One-to-Many).
One Patient can have multiple Appointments (One-to-Many).
2. Create database DBMediCare and Build relational tables (0.5 mark)
+150%
Appointments
AppointmentID
PatientID
Patients
PatientID
PatientCode
Close
