Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Departments, identified by ID, operate a variety of printers, each located in a particular room in a particular building. Printers are supplied by a

 

Departments, identified by ID, operate a variety of printers, each located in a particular room in a particular building. Printers are supplied by a number of suppliers, identified by name, with each supplier charging a different price for a given printer, but also providing different delivery delays, measured in days. A given room can have any number of printers, including none. The relation and FDs are given below. Printing Service (DID, Printer #, Room#, Building#, Supplier Name, FDs: Supplier Address, Delay, Cost) Printer #DID, Room#, Buildign#, Supplier Name (Room#, Building#) DID (SupplierName, Printer#) Delay, Cost - Suplier Name Suplier Address a) Find all the candidate keys for the relation. b) Indicate which FD(s) violates BCNF. c) Find a BCNF decomposition for the given relation. d) Is your decomposition lossless? e) Does your decomposition preserve all functional dependencies?

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Algorithms questions