If possible let me see it in MS Visio format

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 State Zip Phone Email MaritalStat Employer WorkAddress WorkCity Workstate WorkZip SpouseName InsurancelD GroupNum 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 Functional dependencies Patient # (FirstName. LastName, SSN. Gender, BirthDate. . HomeAddress, City, State, Zip.Phone, Email, MaritalStat, Employer, WorkAddress, WorkPhone, WorkCity, WorkState, WorkZip, Spouse Name, InsurancelD) Based on the given example above you create other entities' functional dependencies to complete this Requirement: Based on the entities and functional represent the five entities, including their attributes and relationships. Watch the video lectures related to data model and database design and the difference between the model and the design. Also watch the lecture that will assist you in using MS Visio to develop the model and design. You will submit a MS Word Document that has snap shots from MS Visio or any other software used in the development of the data model and database figures. create a data model and a database design that will 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. If you have additional enquiries about this assignment you can email me or come in person to my office during office hours. 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 State Zip Phone Email MaritalStat Employer WorkAddress WorkCity Workstate WorkZip SpouseName InsurancelD GroupNum 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 Functional dependencies Patient # (FirstName. LastName, SSN. Gender, BirthDate. . HomeAddress, City, State, Zip.Phone, Email, MaritalStat, Employer, WorkAddress, WorkPhone, WorkCity, WorkState, WorkZip, Spouse Name, InsurancelD) Based on the given example above you create other entities' functional dependencies to complete this Requirement: Based on the entities and functional represent the five entities, including their attributes and relationships. Watch the video lectures related to data model and database design and the difference between the model and the design. Also watch the lecture that will assist you in using MS Visio to develop the model and design. You will submit a MS Word Document that has snap shots from MS Visio or any other software used in the development of the data model and database figures. create a data model and a database design that will 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. If you have additional enquiries about this assignment you can email me or come in person to my office during office hours