Question: Here are 5 entities and their attributes please show me how to put the Functional dependencies I did the first two already the way the

Here are 5 entities and their attributes please show me how to put the Functional dependencies

I did the first two already the way the teacher wants to see it below but not sure on the remainding three

PatientInfo:

PatientNum

FirstName

LastName

SSN

Gender

DOB

HomeAddress

City

State

Zip

Phone

MaritalStat

Employer

WorkAddress

WorkCity

Workstate

WorkZip

SpouseName

InsuranceInfo:

InsuranceID

GroupNum

NameOfInsured

RealtionshipToPat

DOB

SSN

PatientNum

InsurerEmployer

IsurerAddress

ICity

IState

IZip

InsurnaceCompanyAddress

ICCITY

ICState

ICZip

PatientHistory:

PatientNum

DOB

ReferringPhysician

PhysicianNum

PharmacyName

PharmacyNum

VisitReason

PriorSurgeries

CurrentIllness

PriorIllness

MedicationHistory

AllergyHistory

SmokingHistory

FamilyHistory

LabResults:

FirstName

LastName

DOB

Gender

ConsultDoctor

SSN

Address

Phone

TestRequest

ChemistryPanels

DrugLevel

ImagingResults:

PatientName

DOB

Phone

ICD9

Authorization

ReferringPhysician

PhysicianNum

MRI

Mammogram

Ultrasound

Nuclear Medicine

PET/CT

GeneralRadiology

Others

Functional dependencies:

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

InsuranceID --> (GroupNum, NameOfInsured, RealtionshipToPat, BirthDate, SSN, PatientNum, InsurerEmployer, InsurerAddress, ICity, IState, IZip, InsurnaceCompanyAddress, ICCITY, ICState, ICZip)

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 Databases Questions!

Suppose XYZ Software Company has a new application development project, with projected revenues of $1,200,000. Using the following table, calculate the ARO and ALE for each threat category that XYZ...

Programming Assignment #2: Smart Arrays COP 3502, Fall 2017 Due: Sunday, September 24, before 11:59 PM Table of Contents...

Table of Contents Abstract........................................................................................................2 1....

Programming Assignment #2: Smart Arrays COP 3502, Fall 2017 Due: Sunday, September 24, before 11:59 PM Table of Contents...

Please refer to information provided for The Fashion Channel on pg. 6 of the case. 1.) Please show how the relative contribution in percentage of TFCs two revenue streams to total revenue will change...

Question: Yoland Research Institute Programming Data Provided: Cash Flows ($) _______ Economic Life (years) _________ Net Investment Amount ($) Purchase Price _________ Disposal/Sell of old equip....

Please create an entity relationship diagram. Use the entity relationship diagram to identify the entities, relationships and attributes based on the information above in the pictures. Children's...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Providing Quality School-Based Learning and Support Services 239 Chapter 6 Language and literacy support Your core task The core task of almost all TAs is to support students language and literacy...

Introduction to Ridgeline Mountain Outfitters (RMO) Ridgeline Mountain Outfitters (RMO) is a large retail company that specializes in clothing and related accessories for all types of outdoor and...

Read Chapters 1,2,4,7 and Write a 800 - 1000 word Reflection Paper Grading : ?Thoughtfulness?Reactions,personal experiences,criticisms, etc. ?Application to your futureprofessional(and personal)life...

Prove that if H is a subgroup of G and Q is a Sylow p-subgroup of H, then gQg- is a Sylow p-subgroup of gHg for all g G.

Quarterly demand for smartphones at a retailer is as shown. Year Quarter Demand 1 I 1513 II 1932 III 1,409 IV 1,502 2 I 1793 II 1,263 III 1,955 IV 2,509 3 I 1846 II 1,739 III 1,271 IV 2,031 4 I 3,071...

Prepare journal entries required at EACH date. December is the end of a reporting period for which a Balance Sheet and income Statement must be prepared and presented. On December 1 , Year 1 , El...

Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the margin of error? Interpret what each confidence...

Understand key international issues concerning: learning, training and talent development; high-performance working systems; worklife balance and diversity and equality.

1. What do employees who have family with special needs have to consider when accepting an international assignment?

understand the key issues concerning international assignments