Decide which attributes are foreign keys and justify your decisions.

Question description

just i have 2 questions

1-Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities.
PATIENT(Patient_ID, Room_Number, Admit_Date, Address)
ROOM(Room_Number, Phone, Daily_Rate)
PATIENT(Patient_Number, Treatment_Description, Address)
TREATMENT(Treatment_ID, Description, Cost)
PHYSICIAN(Physician_ID, Name, Department)
PHYSICIAN(Physician_ID, Name, Supervisor_ID)
(a) Merge these relations into a consolidated set of 3NF relations. State whatever assumptions you consider necessary to resolve any potential problems you identify in the merging process.a

2-Consider the following 3NF relations about a sorority or fraternity:
MEMBER(Member_ID, Name, Address, Dues_Owed)
OFFICE(Office_Name, Officer_ID, Term_Start_Date, Budget)
EXPENSE(Ledger_Number, Office_Name, Expense_Date, Amt_Owed)
PAYMENT(Check_Number, Expense_Ledger_Number, Amt_Paid)
RECEIPT(Member_ID, Receipt_Date, Dues_Received)
COMMITTEE(Committee_ID, Officer_in_Charge)
WORKERS(Committee_ID, Member_ID)

(a) Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions.

find the cost of your paper
Order now to get your homework done

Clarify the role of each legally mandated attendee on the Individualized Education Program team

This discussion assesses your ability to clarify the role of each legally mandated attendee on the Individualized Education Program team. This assessment also supports your achievement of Course Learning Outcome….

Describe the performance of “Salt Peanuts” provided in your Module 3 Playlist

n 100 words or more, describe the performance of “Salt Peanuts” provided in your Module 3 Playlist. Being a live performance, there are certain characteristics that we don’t have in….

Analyze the fixed and variable costs of a firm, how those costs have changed over time, and how those changes have impacted the firm’s overall health and sustainability

The purpose of this milestone is for students to explore the various costs their firm faces and to describe their firm’s market. Using the concepts and tools developed in Modules….