13 points Question 12-13. Here are 5 functional dependencies for a TransactionLine relation where TID is transaction ID, PID is product ID, and CID is customer ID TransactionLine (TID, PID, CID, Cname, date, price, quantity, shippingFee, returned) TID-PID, CID, Cname, date, price, quantity, shippingFee, returned CIDCname PID-price CID, PID-date, quantity, returned price, quantity shippingFee In 1NF relations, there is no repeating group. In 2NF relations, there is no partial dependency. In 3NF relations, there is no transitive dependency. 13. Do you think the relation TransactionLine has the partial dependency and transitive dependency? (2 point) It has both partial dependency and transitive dependency. It has none of partial dependency and transitive dependency. It has no partial dependency but has a transitive dependency. It has a partial dependency but does not have a transitive dependency. 14 1 point Choose two most inappropriate descriptions about the relational algebra operations. (1 point) Selection is an operation to select tuples (rows) of a relation, and Projection is an operation to select attributes (columns) of a relation Set operations work on two relations and have Union, Set difference, Intersection, and Cartesian product. Union operation can work when two relations have different attributes. Join operation is a derivative of cartesian product. Projection is an operation to select tuples (rows) of a relation, and Section is an operation to select attributes (columns) of a relation. OOOO 15 points Question 15-17 There are two relations: Branch (branchNo, street, city, zip, staffNo) Primary key branchNo Foreign Key staffNo references Staff(staffNo) Staff (staffNo, fName, IName, position, sex, DOB, supervisor StaffNo) Primary key staffNo Foreign Key supervisor StaffNo references Staff(staffNo) and one relationship such that: Staff is working at a branch office." 15. Choose one relational algebra operation that does not work. That is, choose one operation that is not appropriate. O IIstaffNo (Branch) U II staffNo (Staff) OfName" Jone" (Staff) Mcity (Branch) IIzip(Branch). salary> 20000 (Staff) O COUNT staffNo Osex="F" (Staff))