Database Design Assignment

9 Pages448 Words356 Views

Added on 2020-04-01

Database Design Assignment

Added on 2020-04-01

BookmarkRelated Documents

Running head: DATABASE DEIGNDatabase DesignName of the Student:Name of the University:Author Note

1DATABASE DEIGN Table of ContentsUser Views.......................................................................................................................................2Relationships....................................................................................................................................2Functional Dependencies.................................................................................................................2Normalization..................................................................................................................................3ER Diagram.....................................................................................................................................4Relationship Diagram......................................................................................................................4Tables Designs.................................................................................................................................4Datasheet view of the tables............................................................................................................6Bibliography....................................................................................................................................8

2DATABASE DEIGN User 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 DependenciesAttributes DependenciesPatientIDPatientName, address, ageDoctorIDDoctorName, speciality, ExperienceDrugIDTradeName, FormulaPharmacyIDPharmacyName, Address, PhoneNumberDrugID, PharmacyIDPrice

End of preview

Want to access all the pages? Upload your documents or become a member.

DATABASE TECHNOLOGIES.

|10

|496

Database Design and Implementation in MS Access

|12

|1110

|215

MN405 Data Model Development and Implementation Assignment

|439

|68

System Analysis and Design for Middle East College and Sydney Dentist Centre

|891

|316

Database Development and Design Tasks 2022

|12

|2605

|25

Designing a Relational Database System for Vet Solution

|26

|3976

|95

Database Design Assignment