Loading
Home › General Help › 5. Consider the following 3NF relations about a sorority ...
Status: Completed
 View Work

5. Consider the following 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_Number,Expense_Ledger_Number, Amt_Paid) RECEIPT(Member_ID,Receipt_Date,Dues_Received) COMMITIEE(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. b. Draw an E-R diagram for these relations, using your answer to Problem and Exercise 5a. c. Explain the assumptions you made about cardinalities in your answer to Problem and Exercise 5b. Explain why it is said that the E-R data model is more expressive or more semantically rich than the relational data model.

Date Posted: 10/07/2015
Category: General
Due Date: 10/07/2015
Instruction
5. Consider the following 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_Number,Expense_Ledger_Number, Amt_Paid) RECEIPT(Member_ID,Receipt_Date,Dues_Received) COMMITIEE(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. b. Draw an E-R diagram for these relations, using your answer to Problem and Exercise 5a. c. Explain the assumptions you made about cardinalities in your answer to Problem and Exercise 5b. Explain why it is said that the E-R data model is more expressive or more semantically rich than the relational data model.
Attached
Download File 1 (pdf)
Tutor Uploads
Download File 1 (doc)
Bidders
meshack 10 years, 11 months ago
Rated 6.8 earned 135.00 around 12 assignments.
hello
$10.00
  • kindly assign me this order. I promise to commit myself to the work and ultimately deliver an excellent plagiarism free paper that will earn you a good grade on time. I will be online for most of the time, feel free to contact me. Thank you
    User_5902 | Oct 07, 2015, 17:41 PM
  • I deliver an A+ paper and in good time, efficient communication, able to finish your paper within the deadline, in fact, let us talk more as we chat, trust me you have the best writer for your paper,
    User_5902 | Oct 07, 2015, 17:42 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
tutorpro 10 years, 11 months ago
Rated 8.13 earned 4271.00 around 145 assignments.
Assign me you work and I will deliver correct and timely answers
$10.00
  • I have carefully read all the instructions. I guarantee you 100% work in 2 hours. Assign me this work and I will start ASAP.
    User_3251 | Oct 07, 2015, 17:48 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
annewriter 10 years, 11 months ago
Rated 9.56 earned 24237.52 around 846 assignments.
Dear Customer, I am well informed about Normalization including the 1NF, 2NF, 3NF and BCNF. With enough expertise working with databases, I can handle your assignment more comfortably providing exemplary results for you. Thanks
$30.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
contentwriter 10 years, 11 months ago
Rated 8.47 earned 29230.90 around 940 assignments.
I am a post grad with immense skills and knowledge in the area and will provide the much needed insights and positions in the subject
$10.00
  • Will do this within the shortest time possible and have it delivered
    contentwriter | Oct 07, 2015, 17:50 PM
  • I have handled similar tasks severally and will have no difficulties handling this whatsoever
    contentwriter | Oct 07, 2015, 17:50 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
thewriter 10 years, 11 months ago
Rated 8.38 earned 1646.00 around 55 assignments.
I can do this for you and deliver A within the shortest time possible
$10.00
  • I don't plagiarize but strictly follow instructions to provide authentic and original work written to meet the expectations of the question
    User_6746 | Oct 07, 2015, 17:55 PM
  • Your work was completed and uploaded. You can now release funds.
    User_6746 | Nov 07, 2015, 02:18 AM
  • I received a 65% on that assignment. She commented on notes and has allowed me to resubmit. Please make the necessary corrections and upload corrected today.
    User_7083 | Jul 14, 2015, 15:50 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}