Develop database model and database design that will assist in understanding the relational… 1 answer below »

Assignment Objective: The goal of this assignment is to develop database model and database design that will assist in understanding the relational database. Before we start the coding we need to create a model that represents the database then convert it into database design.
Introduction: Remember, from the first project assignment you were hired as a consultant to assist in converting the paperwork of a physician office to a health information database that will be more efficient, easy to query, and easy to interface and integrate with other health systems. As a consultant you were able to identify five major entities in the physician office system, PatientInfo, PatientHis, InsuranceInfo, ImagingResults, LabResults. You also identified each entities’ attributes and functional dependencies. For example:
PatientInfo: PatientNum
FirstName
LastName
SSN
Gender
BirthDate
HomeAddress
City
State
Zip
Phone
Email
MaritalStat
Employer
WorkAddress
WorkCity
Workstate
WorkZip
SpouseName InsuranceInfo InsuranceID
GroupNum
NameOfInsured
RealtionshipToPat
BirthDate
SSN
PatientNum
InsurerEmployer
IsurerAddress
ICity
IState
IZip
InsurnaceCompanyAddress
ICCITY
ICState
ICZip
You can do the same for Patient History entity, Imaging Results entity, and Lab Results entity

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today!