Description
i have attached the homework paper. we have to draw dagram and answer 3 question for both section one and two.
please look at it and let me know if you have any questions
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
HelloPFA
TITLE ISBN_10 ISBN_13 AUTHORID AUTHOR_NAME
PUBLISHER_NAME
PUBLISHER_ADD
TOTAL_COPIES_ORDERED
COPIES_IN_STOCK
COPIES_SOLD PUBLICATION DATE
CATEGORY
TYPES_AVAIL
SELLING_PRICE
COST PROFIT_PERCENT
STUNAME STUID HOMEADD HOMEPHONE DORMROOM#
DORMNAME DORMCODE ROOMMATE_NAME
DORMADD STATUS MEALPLAN ROOMCHARGE
MEALCHARGE ROOM_TYPE MEALS_EATEN
MEALS_LEFT MAJOR
Database Programming and Design
Question A
The universal relation of the books in a bookstore is given as,
BOOKS (TITLE, ISBN_10, ISBN_13, AUTHORID, AUTHOR_NAME, PUBLISHER_NAME,
PUBLISHER_ADD, TOTAL_COPIES_ORDERED, COPIES_IN_STOCK, COPIES_SOLD,
PUBLICATION DATE, CATEGORY, TYPES_AVAIL, SELLING_PRICE, COST,
PROFIT_PERCENT)
1. Additional assumptions are,
• AUTHORID is unique for each author.
Based on the assumptions and the following additional assumptions, the FD or Functional Dependencies
are,
ISBN_10 Title, ISBN_13, PUBLICATION DATE, PUBLISHER_NAME
ISBN_13 Title, ISBN_10, PUBLICATION DATE, PUBLISHER_NAME
AUTHORID AUTHOR_NAME
PUBLISHER_NAME PUBLISHER_ADD
PUBLISHER_ADD PUBLISHER_NAME
ISBN_10, TYPES_AVAIL, PUBLISHER_NAME PROFIT_PERCENT
ISBN_13, TYPES_AVAIL, PUBLISHER_NAME PROFIT_PERCENT
ISBN_10 > Category
ISBN_10 > TYPES_AVAIL
(ISBN_10, TYPES_AVAIL) SELLING_PRICE, COST
ISBN_13 > Category
ISBN_13> TYPES_AVAIL
(ISBN_13, TYPES_AVAIL) SEL...