Question: QUESTION 1 1 . 1 Change the TABLE 1 to 1 N F TABLE 1 table [ [ Patron ID , Borrowed books ]

QUESTION 1
1.1 Change the TABLE 1 to 1NF
TABLE 1
\table[[Patron ID,Borrowed books],[C45,B33, B44, B55],[C12,B56]]
1.2 Change Table 2 to 1NF
TABLE 2
\table[[Flight,Weekdays],[UA59,Mo We Fr],[UA73,Mo Tu We Th Fr]]
QUESTION 2
Given TABLE 3 below, answer the following questions
2.1 On which attribute(s) is the Author attribute functionally dependent?
2.2 On which attribute(s) is the Author attribute fully functionally dependent?
TABLE 3
\table[[BookNo,Title,Author,Year],[B1,Moby Dick,H. Melville,1851],[B2,Lincoln,G. Vidal,1984]]
 QUESTION 1 1.1 Change the TABLE 1 to 1NF TABLE 1

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!