Question: please show screenshots of Database model and Database design!!! COP 4708 Project Assignment # 2 Assignment Objective: The goal of this assignment is to develop

 please show screenshots of Database model and Database design!!! COP 4708

Project Assignment \# 2 Assignment Objective: The goal of this assignment isplease show screenshots of Database model and Database design!!!

COP 4708 Project Assignment \# 2 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, Patientunfo Patienttis. InsurapceInfo, ImagingResults. LabResults. You also identified each entity's attributes and related functional dependencies. For example: - Patienthnfo: CatientLua FirstName LastLames SSN Gender BirthDate HomeAddress City State Zip Phone Email MaritalStat Employer WorkAddress WorkCity Workstate WorkZin SpouseName - Insuradcelnfa IosurapcelD GroupNum NameOftnsured RealtionshipToPatient BirthDate SSN BatientLum LosuretEmnloxer LsurerAddress. LosurerCitx IosurterState InsurerZipCode LosurnaceComonaoxAddress ICCITY ICState ICZip ICPhonelumber - You can do the same for Patient History entity, LmagingOrders, and LabOrders entities Functional dependencies: - Patient # (FirstName, LastDame, SSN, Gender, BirthDate, HomeAddress, City, State, ZipaPbone, Email, MaritalStat Employer, WorkAddress. WorkPbone, WorkCitd, WorkState, WorkZip, Spouse Name, InsuranceID) - SSN (FirstName, LastName, Email, Phone\#, Gender, MaritalStatus, Address, City, State, Zip-Code, Date-of-Birth, Patient \#) - Email (FirstName, LastCame, SSN, Phone\#, Gender, MaritalStatus, Address, City, State, ZipCode Date-of-Birth, Patient \#) - (InsurancePolicyNumber) (GroupNum, NameOfInsured, RelationshipToPat, BirthDate, SSN, InsurerEmployer InsurerAddress, ICity, IState, IZip, InsuranceCompanyAddress, ICCity, ICState, ICZip) - (HistoryRecordID) (PastSurgerv, CurrentConditions, PriorIllness, PriorInjuries) - (LabOrderNumber (CollectionDate CollectionTime, CollectingIndividual OrderingProvider, ConsultingDr, NarrativeResponse, Order, Test, ChemPanel, DrugLevel) - (ImagingOrderNum) (ExamReason, ReferringPhysician, PhysicianPhone, PhysicianEmail, PhysicianFax, PhysicianRequests, ExamType, ExamFocus)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!