Fall14_Unit4_HW - WBIT 3110 Fall 2014 Unit 4 HW...

This preview shows page 1 - 3 out of 8 pages.

WBIT 3110, Fall 2014, Unit 4 HWAdministrative InformationDate AssignedTuesday, November 11, 2014Date DueFriday, November 21, 2014, @ 11:59 pm. Remember that now there is only be ONE dropbox. ItWILLallow late submissions. Submissions made past the due date will automatically be marked as late and will be graded in accordance with the standards set in the syllabus.Material coveredUnit 4, Chapters 9, 10, and 11Value of the Assignment6% of the course grade, or 60 points out of 1000Value of Each QuestionSee each question, scored on a 0-100% basisMethod of SubmissionDownload this assignment, enter your answers into the document, save it, and then upload the document to the D2L dropbox. There is no need to rename the document you’re your name in the filename – D2L automatically places your name in the file name.No other method will be accepted.From Chapter 91.Corresponding to Problem and Exercise 5 on page 350.This question is worth 30% of the assignment, each part being worth 10%.Consider the 3NF relations about a sorority or fraternity:MEMBER (Member_ID,Name, Address, Dues_Owed)OFFICE (Office_Name,Officer_ID,Term_Start_Date,Budget)EXPENSE(Ledger_Number,Office_Name,Expense_Date,Amt_Owed)PAYMENT(Check_Nbr,Expense_Ledger_Number,Amt_Paid)RECEIPT(Member_ID,Receipt_Date,Dues_Received)COMMITTEE((Committee_ID,Officer_in_Charge)WORKERS((Committee_ID,Member_ID)aForeign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions.OFFICER_ID is a foreign key in OFFICE in reference MEMBER_ID from the MEMBER relation. OFFICE_NAME is a foreign key in EXPENSE referencing OFFICE_NAME in the OFFICE relation.1
WBIT 3110, Fall 2014, Unit 4 HW

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture