How would i go about verifying is a relation in a schema is in BCNF? Member Memb

Question

How would i go about verifying is a relation in a schema is in BCNF?

Member Member ID LastName FirstName Date OfB Phone Number Email (U) Date OfMembership DateOfExpiration MemberID (FK) Item Reservation Check outDate Due Date tumed Wait Formal Quantity MemberID temID Movie ID HoldByStaffID StafflD FK temID (FK) BookID dFK) Other Items emID Genre Publishe Volume Publish Date Language Price Modified By StaffID Item Type Title Author Address StreetAddress ApartmentNumber City State ZipCode StafID (U) StaffD Staff StafflD FirstName LastName DateOfBirth PhoneNumber Ema Books Book ID New Attribute ISBN (U) SS Forma uthor Genre Publisher Eiditon DateOfPublication Language Quantity Price Modified StaffID Bill Summary Dateof Change ReasonForCharge Amo Due un Total Paid MemberID Modified By Staff ID emberID (FK) StaffD (FKU.

Explanation / Answer

By converting given schema into BCNF

MemberID( MemberID(PrimaryKey), LastName, FirstName, DateOfBirth, PhoneNumber, Email, DateOfMembership, DateOfExpiration)

Address(MemberID(ForeignKey), StreetAddress, ApertmentNumber, City, State, ZipCode,StaffID(PrimaryKey))

ItemReservation(CheckoutDate, DueDate, ItemReturned,WaitList, Title, Format, Quantity, ItemID(PK), MovieID, HoldByStaffID, StaffID(FK), BookID(FK), MemberID(FK))

Staff(StaffID(PK), FirstName, LastName, DateOfBirth, PhoneNumber, Email, JobPosition, BookID(FK))

Books(BookID(PK), ISBN, ISSN, Format, Title,Author, Genre, Publisher, Edition, Date of Publication, Language, Quantity, Price, ModifiedByStaffID)

Other_Items(ItemID(PK), Publisher, Volume, PublishDate, Language, Price, ModifiedByStaffID, ItemType, Title, Author, ISSN, StaffID(FK))

BillSummery(DateOfChange, ReasonForChange, AmountDue, TotalPaid, MemberID(FK), ModifiedByStaffID, StaffID(FK))

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.