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

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer