Map the following ERD into a relational schema. PATIENT patio name(fname, Iname) (address(street, city, state, zip)}...

Transcribed Image Text:

Map the following ERD into a relational schema. PATIENT patio name(fname, Iname) (address(street, city, state, zip)} do.b [age] HOSPITAL hospitalD start date end date description contracts name contactNum admits RESIDENT roomNumber admitDate PHARMA_CO companyID name contactNum DRUG STORE releaseDate storelD PHYSICIAN name VISITING doclD makes visitDate name(fname, Iname) (address(street, city, state, zip)) contactNum speciality sells experience year (issues) (certificate) PRESCRIPTION date quantity DRUG tradeName formula supplies price Map the following ERD into a relational schema. PATIENT patio name(fname, Iname) (address(street, city, state, zip)} do.b [age] HOSPITAL hospitalD start date end date description contracts name contactNum admits RESIDENT roomNumber admitDate PHARMA_CO companyID name contactNum DRUG STORE releaseDate storelD PHYSICIAN name VISITING doclD makes visitDate name(fname, Iname) (address(street, city, state, zip)) contactNum speciality sells experience year (issues) (certificate) PRESCRIPTION date quantity DRUG tradeName formula supplies price