10 2 points There is an ER diagram, based on which a relational model will be made. Which relational model is most inappropriate? Choose one (2 point). (Figure) O Property For Rent (propertyNo, street, city, postcode, type, rooms, rent, clientNo) Primary key propertyNo Foreign Key clientNo references Client(clientNo) Client (clientNo, fName, IName, telNo, StaffNo) Primary key clientNo Foreign Key StaffNo Staff (staffNo,fName, IName, position, sex, DOB) Primary key staffNo 11 1 point Choose one most inappropriate description about the data redundancy. (1 point) If there is an unnecessary data redundancy in a logical design, the three types of anomalies always occur at the same time. Unnecessary data redundancy causes waste of DB storage space. Unnecessary data redundancy causes anomalies, which have insertion, deletion, and modification anomalies. Modification anomaly may not be the problem in a small-sized relation (e.g., 10 rows) that cannot be expanded anymore. To avoid unnecessary data redundancy and validate a logical design, a DB designer has to do the normalization process. 12 2 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. 12. Choose the primary key (only one primary key). (2 point) O PID O CID O TID O price, quantity O CID, PID