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)
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
Question 2) For each of the tables below: A) Determine the highest normal form 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 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 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 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?
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:...
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...
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....
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))
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 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...