15 Given the following relation: Supplier( Supplier D, name, city, partNumber, partDescription) Where Supplier D is the primary key, and partNumber-> partDescription Which of the following statement(s) is correct: (2 Points) The relation is in 2NF The relation is in BNF The relation is in BCNF 16 Consider the following figure, which FDs can be seen as an example of transitive dependency? * (2 points) Candidate Key LOTS Property id# Lot# Area Price County_name Tax rate FD1 FD2 FD3 FD4 OFD1 OFD2 O FD3 FD4 Based on your understanding of the main reasons for the normalization process, select the main informal guidelines for good relational design. LLE =*-- Select all that apply 03 ---- ] 2 Points) The BCNF must be satisfied in the database Tuples will have as few NULL values as possible. No spurious tuples should be generated Composite keys are always better than single attribute keys because they are clear and easy to understand 18 Given the following relation R and functional dependencies. R(P_code, P_sequence, P_year, P_model, P_category, P_color) FDs: P_code, P_sequence --> All attributes of R P_category, P_sequence --> All attributes of R P_category --> P_code Assume that there is no problem with 1NF, which of the following is correct? (2 Points) The above relation, R is already in 3NF but not in BCNF. The above relation, R, satisfies the BCNF. The above relation, R is already in 2NF but not in 3NF. The above relation, R is unnormalized 19 Tech ( cust_ID, problem_code, tech_no). FDs: cust_ID, problem_code --> tech_no tech_no --> problem_code The above relation "Tech" is in 3NF but not in BCNF. (2 Points) True False After mapping the following ER diagram to relational schema, attribute D.Location: (2 Points) SID (s Name HAVE Grade DID DINAS COLOR IN STUDENTS DEPARINIENTS belong T9 N CITD IN Name taking Grade INI NI COURSES NI ered couns prerequisite courses perequites Will be added to a new relation together with D_ID Will be added to Department relation Will be added to offers relationship 21 Publication d)) Book Technical report Joumal For the generalization hierarchy shown in the figure which mapping option (Step 8) would you use? (2 points) O ANY option in step 8 (A, B, C, or D) would work KO Step 8 options, A and B, are the ONLY solutions in this case ONLY Option (80) : Single relation with one type attribute ONLY option (8D): Single relation with multiple type attributes Vehicle) Price (LicesePlaceNo VEHICLE) MaxSpeed) CAR TRUCK Tonnage NoOfPassengers (NoOfAxles For the generalization hierarchy shown in the figure, which mapping option does NOT work in this case? * (2 Points) Step 8 Option A Step 8 Option B Step 8 Option C Step 8 Option D 23 ID dcode USER (30) 011 U3 U2 Consider the following specialization. Notice that sub-class U1 has only two attributes, while U2 and U3 have 23 attributes and 30 attributes, respectively. Assume that this database has 10 million users where 40% of them belong to U1 sub-class, 20% to U2 sub-class, and 40 % to U3 sub-class. Which one of the following is correct regarding the mapping process? (2 Points) Option 8A is recommended in this case Either Option 8A or Option 8C is recommended. Either Option 8D or Option 8C is recommended. O Option SA is NOT recommended in this case 24 B D W Consider the following Union where each entity has a different format of the primary key. Assume that entity A has 8 attributes, B has 10 attributes, d has 5 attributes, and D has 15 attributes. After mapping the EER, how many attributes the relation w would have? (2 points) It would have one attribute. At least 5 attributes 38 attributes CID 4 attributes 25 namna an Person address address . Patent Doctor Pharmace OWJOBUL De YearsE. Qualcafors The minimum number of relations to map the following EER diagram to a relational schema is: (Note: it is Total, overlapping) (2 Points) 2 5