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 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
Get step-by-step solutions from verified subject matter experts
