Thursday, December 5, 2019

Relational Data Model E-R Diagram

Question: Discuss about theRelational Data Model E-R Diagram. Answer: ER Diagram (Studytonight.com 2016) Business Rules The business rules that are defined in the CQ Specialist Medical Centre (CQMC) are as follows- The patient detail along with other information like medical history, allergy etc. will be stored into the database. The General Practitioners detail is also stored into the database like Name. Address etc. All test and procedures will also be stored into the database. The patients total charges and all tests charges will be saved into the database independently. Special patients will get discount from the CQMC. Assumptions The assumptions that are defined in the CQ Specialist Medical Centre (CQMC) are as follows- Booking and date of appointment will be stored into the database. The prescription date will also be stored into the database. The General Practitioners detail will also be stored into the database. There are two types of patients- regular and special patients like senior citizen etc. Logical Design TPatient (FPatientID, FFullName,FAddress, FPhone, FGender) TRegular (FPatientID) TSpecial (FPatientID, FType) TPatientMedicalHistory (FPatientID, FSurgery,FDetail, FMedicine, FDosage, FAllergy) foreignkey(FPatientID)references TPatient (FPatientID) TGP (FMPNumber, FFullName,FAddress, FPhone, FGender) TReference (FPatientID,FReferralID,FDateOfReference, FLetter) foreignkey(FPatientID)references TPatient (FPatientID) foreignkey(FReferralID)referencesTGeneralPractitioner (FMPNumber) TSpecialist (FSpecialistID, FFullName,FAddress, FPhone, FGender, FExperience) TSpecialistQualification (FSpecialistID,FQualification) foreignkey(FSpecialistID)references TSpecialist (FSpecialistID) TAppointment(FAppointmentID, FSpecialistID, FPatientID, FAppointmentDateTime, FBookingDateTime) foreignkey(FSpecialistID)referencesSpecialist (FSpecialistID) foreignkey(FPatientID)references TPatient (FPatientID) TPrescription (FPrescriptionID, FAppointmentID, FDateOfPrescription, FTest, FProcedures) foreignkey(FAppointmentID)references TAppointment (FAppointmentID) TCurrentMedication (FPrescriptionID, FProblem, FMedicine, FDosage) foreignkey(FPrescriptionID)references TPrescription (FPrescriptionID) TCQMCFee (Type, Fee) TCharges (FAppointmentID, FFeeType , FDiscount, FTotalCharge) foreignkey(FAppointmentID)references TAppointment (FAppointmentID) foreignkey(FFeeType)references TCQMCFee (Type)(Tutorialspoint 2016) References Tutorialspoint 2016, Relational Data Model, [Online]. Available: https://www.tutorialspoint.com/dbms/relational_data_model.htm/ [Accessed: 5-April-2017] Studytonight.com 2016, E-R Diagram, [Online]. Available: https://www.studytonight.com/dbms/er-diagram.php [Accessed: 5-April-2017]

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.