Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DATABASE Administrator Make A Difference

Authors: Mohciine Elmourabit

1st Edition

B0CGM7XG75, 978-1722657802

More Books

Students also viewed these Databases questions