Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

Database Design Assignment

Added on - 01 Apr 2020

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 3 of 9 pages
Running head: DATABASE DEIGNDatabase DesignName of the Student:Name of the University:Author Note
1DATABASE DEIGNTable of ContentsUser Views.......................................................................................................................................2Relationships....................................................................................................................................2Functional Dependencies.................................................................................................................2Normalization..................................................................................................................................3ER Diagram.....................................................................................................................................4Relationship Diagram......................................................................................................................4Tables Designs.................................................................................................................................4Datasheet view of the tables............................................................................................................6Bibliography....................................................................................................................................8
2DATABASE DEIGNUser ViewsPatients (PatientID (pk), PatientName, address, age)Doctors (DoctorID (pk), DoctorName, speciality, Experience)PrimaryDoctor (PatientID, DoctorID)Prescription (DoctorID, DrugID)Drugs (DrugID (pk), TradeName, Formula)Pharmacy (PaharmcyID (pk), PharmacyName, Address, PhoneNumber, DrugID, Price)RelationshipsEvery patient has a primary physician/doctor. Every doctor has at least one patient.Hence One to one relationship exists between Doctor and PatientsA doctor could prescribe one or more drugs for several patients, and a patient could obtainprescriptions from several doctors.Hence Many to Many relationship exists in between the Doctors and the Drugs.Each pharmacy sells several drugs and has a price for each. A drug could be sold at severalpharmacies, and the price could vary from one pharmacy to another.Hence Many to Many relationship exists in between the Drugs and Pharmacy.Functional DependenciesAttributesDependenciesPatientIDPatientName, address, ageDoctorIDDoctorName, speciality, ExperienceDrugIDTradeName, FormulaPharmacyIDPharmacyName, Address, PhoneNumberDrugID, PharmacyIDPrice
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document