Consider the relation R (AA, Bb, Cb, YY, Ee, Ff, GG, HH, Jj, KK) for Naim Furniture Company with the following functional dependencies (FDI to FD4) that exist between these attributes as shown in figure below. AA Bb Cc YY Ee Ff Gg Hh KK FD1: 1 + 1 1 1 1 FD2: 1 FD3: 4 FD4: Based on the figure above, choose the CORRECT statements on the types of functional dependencies for FDI, FD2, FD3, FD4. O A. FD3: Partial dependency O B. FD4: Partial dependency O C. FD2: Full functional dependency O D. FDI: Transitive dependency This case study describes a company called StayHome, which rents out CD games to its members. The first branch of StayHome was established in 2002 in Johor Bahru but the company has now grown and has many branches throughout Malaysia. The company's success is due to the first-class service it provides to its members and the wide and varied stock of games available for rent. As StayHome has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of StayHome has urgently requested that a database application be built to help solve the increasing problems of data management One of the data requirements that you have identified is as follows: A customer of StayHome must first register as a member of a local branch of StayHome. The details held on a member are member number, name, address, and the date that the member registered at a branch. For each CD game, the details held on each CD are the CD number, title, number of the CD available in each store, and daily rental rate. The rental number is unique throughout the company. Each member is allowed to rent more than one CD games, where a rental number, date rented and return date to return is CD will be created every time a member came to rent a CD. The CD game is also available to be rented by many members as StayHome have a number of games with the same title. Based on the case study, which of the following BEST describe the Logical ERD for the above statement? MEMBER CD GAME ren member num member name member_address CD number game_title num of game rental_rate reg_date . MEMBER CD GAME de hp RENTAL rental_num rent date return_date 1..1 member num member name member address reg. date 1..1 CD number 1. game title num of game rental_rate . MEMBER CD GAME ren 1. 1... member num member_name member address reg date CD number Eame_title num of game rental rate rentalnum rent date return_date OD MEMBER her member num member_name member_address RENTAL rental num rent_date 1. return_date member_num CD_number CD_GAME CD_number game_title num_of_game rental_rate 1.1 reg_date When mapping a complex relationship type, the following statements are true, EXCEPT? Student StudentID (PK) Register UnivStaff 1.1 StaffID (PK) 1_1 02 Institution InstitutionID (PK) O A. Transform many-to-many relationship by creating a new entity and binary relationships between original entities with this new entity. O B. Create relations for Student, Institution and Univstaff entities following appropriate rules for binary relationship. O C. Copy foreign key attribute(s) of Univstaff to act as primary key for Student entity. O D. Create Registration relation to represent relationship and include StudentID, StaffiD and InstitutionID that are part of the relationship The following table is employee statistics for IT Excellence company. EmployeeID 10 105 152 215 244 EmployeeName Sulaiman Ali Khairul Anuar Tan Ah Meng Sivakumar Sufian Ahmad Alina Ali Junainah Johan Stephanie Chua Muthusamy Salary (RM) 75000 65000 60000 60000 50000 45000 Position Manager Manager Manager Manager Staff Staff Staff Entry-Level Entry-Level 300 335 40000 400 32000 28000 441 Based on given table, display the Managers id, and first name whose salary over RM 40,000; O A. SELECT employee_id, first_name FROM employees WHERE Position = 'Manager' Like Salary(RM) = >40000; O B. SELECT employee_id, first_name FROM employees WHERE Position = 'Manager' AND Salary(RM) = >40000; O C. SELECT employee_id, first_name FROM employees WHERE Position = 'Manager, Salary(RM) = >40000; O D. SELECT employee_id, first_name FROM employees WHERE Position = 'Manager' AND Salary(RM) = >40000