Patient (patientNo, name, address, phone, dateOfBirth, sex, insuranceCo, policyNo, relationshipTolnsured) Appointment (patientNo, a

Myperfecttutors.com

Patient (patientNo, name, address, phone, dateOfBirth, sex, insuranceCo, policyNo, relationshipTolnsured) Appointment (patientNo, appidate, apptime. reason, staffNo, visitNo) Visit (visitNo, patientNo, visitdate, visittime, duration, reason, visitType, visitCost, staffNo, roomNo) Staff (staffNo, name, title, specialty, address, phone) Availability (staffNo. availDate, startTime, endTime) InsurancePolicy (company, policyNo, insuredName, policytype, medicalCoPay, labCoPay, pharmacyCoPay, startDate, ending Date) DiagnosisMenu (diagCode, diagName) ProcedureMenu (proe Code, procName, cost) Room (roomNo, roomType, condition) PrescriptionScript (seriptNo, visitNo, dateWritten, itemPrescribed, quanityPrescribed, directions, numberRefills) LabTest (testNo. prescription No, testType, testDate, testTime, cost, result) PrescriptionMedication (RXNumber, scriptNo, drugDispensed, dateDispensed, quantityDispensed, refillsRemaining, cost) ProcedurePerformed (visitNo. procCode, result) Diagnosis (visitNo diaeCode, dateOnset, symptoms, severity, prognosis) Referral (refNo, visitNo, refTo, reason) Bill (invoiceNo, billDate, totalAmount, ducDate, patientNo, amountPaid) Charge (invoiceNo, serviceType, serviceDate, amountCharged) Payment (invoiceNo. date, amountPaid, patientPayer, insuranceCoPayer, insurnacePolNoPayer) Using the relational schema, please list any functional dependencies then normalize the relations to BCNF

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *