Can someone help me with this question for ismg class I will appreciate Nate, pl

Question

Can someone help me with this question for ismg class I will appreciate Nate, please turn the spellch each table. off so you can see the underlined key for Problem I (10 Points). Table SalclInfo records monthly revenue information Given the functional dependencies identified below, identify the primary key Do not assume any further functional dependencies. Show the steps you went through to obtain the primary key for a store and store a. Phone) ear, Revenue All FDs: StoreName Location Location Chief ManagetNamePhone ManagerName Revenue dosage, HospitalAdmin, Patients me, AllFDs MedAd min# Nurseld. MedDateTim Nurseld NurseName Rx# MedNarne. Dosage, Hospita!Admin# Hospit # Patient# Puen

Explanation / Answer

Solution:

a)

Let's find the candidate keys first, we know that one of the candidate keys is the primary key.

The candidate key is StoreName+ Month-Year,

there is no such candidate key possible which drives all the attributes of the table.

so there is only one candidate key then that is the primary key also

Primary key: StoreName+ Month-Year

b)

here also there is only one candidate key which is also a primary key and that is

MedAdmin#+Rx#, together they both drive all the attributes of the table:

Primary key:MedAdmin#+Rx#.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.