WBIT 3110, Summer 2015, Unit 4 HW
June 29, 2015
July 11(Saturday) @ 11:59 pm.
Remember that now there is
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
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.
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
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
MEMBER (Member_ID,Name, Address, Dues_Owed)
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:
Officer_ID is the foreign key in the relation OFFICE referencing Member_ID in
the MEMBER relation.
Officer_Name is the foreign key in the relation EXPENSE referencing
Office_Name in OFFICE relation.
Officer_in_Charge is the foreign key in the relation COMMITTEE referencing
Office_Name or Officer_ID in OFFICE relation.
Ledger_Number is the foreign key in the relation EXPENSE referencing
Expense_Ledger_Number in PAYMENT relation
Member_ID is the foreign key in the relation WORKERS referencing
Member_ID in MEMBER relation.