Question: Following is the database schema where the first attribute in each relation is the Primary key and the foreign keys carry the same names as

Following is the database schema where the first attribute in each relation is the Primary key and the foreign keys carry the same names as the primary keys they reference.

Primary keys: RID in Receptionist, DID in Donor, BID in Blood, NID in Nurses and PatientID in Transfusions.

Receptionist(RID, Name, Address, Phone#) Donor (DID, Name, Address, Phone#, SSN, gender, DOB) Blood(BID, Blood_type, Cost, DID, NID) Nurses(NID, Name, Address, Phone#) Transfusions(PatientID, Date, Trans#, BID)

The refactoring requirement is: Since donors may donate every 60 days, a collection date needs to be added to the blood relation.

I would like to know what refactoring needs to be done for this particular requirement? Where should the Collection Date column be added and what are the other changes be done?

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!

i need answer please Data abstraction - External, Conceptual, Internal The Schema Big Data NO SQL rows (tuples) and columns (attributes) Primary and Foreign Keys Composite key -Composed of more than...

Feel free to edit the code below to answer questions 1-13 Please note for question 2-8 , this the error message am getting (20:52:54 INSERT INTO PROJECT VALUES('ProductA', 4, 'Bellaire', 2) Error...

Convert the following ERD into relational schema. It should include the relation names, attribute names, primary keys and foreign keys as shown in below example: Relation1 (Attribute1, Attribute2,...

Convert the following ERD into relational schema. It should include the relation names, attribute names, primary keys and foreign keys as shown in below example: Relation 1 ( Attribute 1 , Attribute...

Using the relations that you have defined for the library system, normalize your relations into first, second, and third normal form. Your output should be an Entity Relationship diagram that is in...

if you can please do this even on paper it would really help. the deadline is in a few days so before that i hope. thank you 1 of 3 4CCS1DBS Database Systems Coursework 1 February 2021 This...

Please follow the instructions on the attached document. This is for a graduate course level. Thanks. A614 Week 6 homework -- Preparing database tables The following are the tables that are needed to...

A614 Week 6 homework -- Preparing database tables The following are the tables that are needed to create your database. Table Name Primary Key Foreign Keys Other Attributes Customer Customer Number...

Consider the following data for a project to install a new server at the Northland Pines High School: Activity Activity Time (days) Immediate Predecessor(s) A 1 B 4 A C 5 A D 4 B E 1 B F 5 B, C G 3...

To simulate materials processing under the microgravity conditions of space, a niobium sphere of diameter 3 mm is levitated by an acoustical technique in a vacuum chamber. Initially the sphere is at...

You calculated that Maria needs to save $ 6 2 , 9 8 2 today to fund her daughter Sam's education in 6 years. She does not have that much money to set aside today. How much must she save each year in...

When passing a journal entry for this transaction what would be debited? "$700 advertising bill received but is yet unpaid"

KEY QUESTION Place an M beside the items in the following list that describe a moral hazard problem and an A beside those that describe an adverse selection problem: a. A person with a terminal...

KEY QUESTION How does the problem of limited and bundled choice in the public sector relate to economic efficiency? Why are public bureaucracies alleged to be less efficient than private enterprises?

KEY QUESTION Explain the paradox of voting through reference to the accompanying table, which shows the ranking of three public goods by voters Jay, Dave, and Conan: Public Good Jay Dave Conan...