Question 2) For each of the tables below: A) Determine the highest normal form the table...

Question

Question

Question 2) For each of the tables below:

A) Determine the highest normal form the table is in

B) Explain your answer (why that is the highest normal form for the table)

Tables:

OFFICER_INITIATIVE_DETAILS (initiativeID, cause, officerID)

SOLICITATIONS (solicitID, solicitType, solicitChannelAndDate, collegeID, collegeName, donorID)

engineering Computer-Science

Answer 1

Answer #1

1) OFFICER_INITIATIVE_DETAILS is in 3NF since there are no multivalued attributes and there is neither any partial or transitive dependency.

2) SOLICITATIONS is in 1NF since there is partial dependencies among:

solicitID -> solicitType, solicitChannelAndDate

collegeID -> collegeName

solicitID, collegeID -> donorID

Answer 2

Similar Homework Help Questions

Using tables and charts below, explain the criteria for 3rd Normal Form and normalize the table...

Using tables and charts below, explain the criteria for 3rd Normal Form and normalize the table you obtained for the previous question to meet them. Also , is the table you obtained for the previous question in BCNF? School_ID Course_ID Grade Student_Name Department Tuition Fee Instructor COP01, COPO2, COPO3 A, A, B John Smith BU01, BU02 B, B Roger Hicks CISE 4114123 3124234 250 James, Andrew, Peter Alan, Alan Business 300
4. (40 points) Identify the following relations that are in Third normal form (3NF)? If it is in ...

4. (40 points) Identify the following relations that are in Third normal form (3NF)? If it is in 3NF, is it in BCNF? You must explain your answer to receive points. Also, for each question, pick one FD not in BCNF and decompose R into tables if it is not in BCNF. (2) R(ABCD) FD's: AB-»C; ABD->C; ABC-> D; AC-ID (4) R(ABCD) FD's: C- B;A->B; CD -»A; BCD (5) R(ABCD) FD's: AD C;D-A;A-C;ABC A D, 4. (40 points) Identify the...
1. Which of the below tables is likely a Demand Schedule (Table 1 or Table 2...

1. Which of the below tables is likely a Demand Schedule (Table 1 or Table 2 or both Tables)? Why? 2. Can you identify an equilibrium price and quantity might be from the Tables above? If so, what is would it be? Table 1 Price $0.00 $1.00 $2.00 $3.00 $4.00 $5.00 Quantity 50 40 30 20 10 O Table 2 Price $0.00 $1.00 $2.00 $3.00 $4.00 $5.00 Quantity 0 10 20 30 40 50

QUESTION 6 Only! 4) Draw the normal-form matrix for each of the following extensive-form games 2...

QUESTION 6 Only! 4) Draw the normal-form matrix for each of the following extensive-form games 2 E 2,2 2 F3,4 2 4, 0 0 -L-I 3,2 6) Use your normal-form matrix for (4b) above. Assume that ơ,-( ). , a. Find ui(IU, ơ2) and ui(ID, ơz). b. Assume 0 (IU)-2/3 and 01(ID)-1/3 Find player l's expected payout. Then find player 2's expected payout. Which is higher?
A. For a relationship to be defined, we need at least two relations (tables). [2] a....

A. For a relationship to be defined, we need at least two relations (tables). [2] a. TRUE b. FALSE B. Aggregate functions can be used in a SELECT clause without GROUP BY on a column of a table [2] a. TRUE b. FALSE C. A table which satisfies 3NF (Third Normal Form) can violate 2NF (Second Normal Form) a. TRUE [2] b. FALSE D. In a table the foreign key attribute can have null value. a. TRUE [2] b. FALSE...
4. (40 points) Identify the following relations that are in Third normal form (3NF)? If it is in ...

4. (40 points) Identify the following relations that are in Third normal form (3NF)? If it is in 3NF, is it in BCNF? You must explain your answer to receive points. Also, for each question, pick one FD not in BCNF and decompose R into tables if it is not in BCNF (1) R(ABCD) FD's: ACD B;AC D D C;ACB (2) R(ABCD) FD's: AB C; ABD C;ABC D;ACD (3) R(ABCD) FD's: AB; B A;A D D B (4) R(ABCD) FD's:...

Determine the functional dependencies that exist in the following table and then convert the following table...

Determine the functional dependencies that exist in the following table and then convert the following table to an equivalent collection of tables that are in third normal form. Please show each step from first to third normal form. ITEM (TIEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOURSE, PRICE, (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM, CUSTOMER_NAME, NUM_ORDERED, QUOTED_PRICE))
s Use the following one-shot, normal-form game to answer the questions below Player 2 Strategy Player...

s Use the following one-shot, normal-form game to answer the questions below Player 2 Strategy Player 1 A 100, 100 150,200 200 200, 75 300, 200 125, 150 100, 225 200, 300 225, 195 150, 250 c Find each player's dominant strategy, if it exists.(4 points) d. Find each player's secure (maximin) strategy. (4 points) Find the Nash equilibrium, if there is one, and explain why it is the Nash equilibrium. If there is not a Nash equilibrium, explain why....
question #4 Rewrite (pAr) Vq in disjunctive normal form. For each of the following, rewrite the...

question #4 Rewrite (pAr) Vq in disjunctive normal form. For each of the following, rewrite the statement in disjunctive normal form, without first producing a truth table. 5

Use these present value tables to answer the question that follow. Below is a table for...

Use these present value tables to answer the question that follow. Below is a table for the present value of $1 at compound interest. Year 6% 10% 12% 1 0.943 0.909 0.893 2 0.890 0.826 0.797 3 0.840 0.751 0.712 4 0.792 0.683 0.636 5 0.747 0.621 0.567 Below is a table for the present value of an annuity of $1 at compound interest. Year 6% 10% 12% 1 0.943 0.909 0.893 2 1.833 1.736 1.690 3 2.673 2.487 2.402...