Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started