Summer15_Unit4_HW - WBIT 3110 Summer 2015 Unit 4 HW...

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

WBIT 3110, Summer 2015, Unit 4 HW Administrative Information Date Assigned June 29, 2015 Date Due July 11(Saturday) @ 11:59 pm. Remember that now there is only be ONE dropbox. It WILL allow 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 covered Unit 4, Chapters 9, 10, and 11 Value of the Assignment 6% of the course grade, or 60 points out of 1000 Value of Each Question See each question, scored on a 0-100% basis Method of Submission Download 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 9 1. 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) a Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions. The foreign keys in the above mentioned relations are as follows: 1. Officer_ID is the foreign key in the relation OFFICE referencing Member_ID in the MEMBER relation. 2. Officer_Name is the foreign key in the relation EXPENSE referencing Office_Name in OFFICE relation. 3. Officer_in_Charge is the foreign key in the relation COMMITTEE referencing Office_Name or Officer_ID in OFFICE relation. 4. Ledger_Number is the foreign key in the relation EXPENSE referencing Expense_Ledger_Number in PAYMENT relation 5. Member_ID is the foreign key in the relation WORKERS referencing Member_ID in MEMBER relation.
WBIT 3110, Summer 2015, Unit 4 HW

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture