Hi I need help with the following (see attached word document for full instructions):

Introduction: 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:

PatientNum

FirstName

LastName

SSN

Gender

BirthDate

HomeAddress

City

State

Zip

Phone

Email

MaritalStat

Employer

WorkAddress

WorkCity

Workstate

WorkZip

SpouseName

InsuranceID

GroupNum

NameOfInsured

RealtionshipToPat

BirthDate

SSN

PatientNum

InsurerEmployer

IsurerAddress

ICity

IState

IZip

InsurnaceCompanyAddress

ICCITY

ICState

ICZip

Functional dependencies:

• Patient # –> (FirstName, LastName, SSN, Gender, BirthDate, , HomeAddress, City, State, Zip,Phone, Email, MaritalStat, Employer, WorkAddress, WorkPhone, WorkCity, WorkState, WorkZip, Spouse Name, InsuranceID)

Based on the given example above you create other entities’ functional dependencies to complete this assignment

Based on the entities and functional dependencies create a data model and a database design that will represent the five entities, including their attributes and relationships. You will submit a MS Word Document that has snap shots from MS Visio of the data model and database figures.

In the design remember to include the data type, data size and the null/not null constraints. You should specify which attributes will be used as the primary key and which one will be a foreign key.