Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. 1. The BOOK_CHECKOUT relation stores data about books checked out by students at a university. The functional dependencies are given below for this relation

image text in transcribed
a. 1. The BOOK_CHECKOUT relation stores data about books checked out by students at a university. The functional dependencies are given below for this relation Which normal form is this relation in and why? b. Using the normalization steps develop a set of 3NF relations for this view. Describe the relational schema for the 3NF relations that you developed. Be sure to list the referential integrity constraints BOOK_CHECKOUT (StudentID. StudentName, StudentPhoneNumer ISBN, BookTitle, CheckoutData, ReturnDate) StudentID -> StudentName, StudentPhoneNumer ISBN -> Book Title Studenti, ISBN->CheckOutDate, ReturnDate

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_2

Step: 3

blur-text-image_3

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

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

More Books

Students also viewed these Databases questions

Question

4-25. You neglected to sign the enclosed contract.

Answered: 1 week ago