20. Consider the table below. actor ie Ondore di 1d2 Which functional dependencies (fd) shows partial dependencies? A. dl (filmNo, actorNo, role timeOnScreen) and fd4 (dirNo director) B. fdl (filmNo, actorNo, role timeOnScreen), fd2 (filmNo - fTitle, dirNo, director) and fd3 (actor NoaName) C. fd2 (filmNofTitle, dieNo, director) and fd3 (actorNo Name) D. fd3 (actorNo Name) and fd4 (dirNo - director) 21. Which of the following is TRUE about a subclass discriminator? A. An attribute of the superclass whose values determine the subclass B. An attribute of the subclass whose values determine the superclass C. An attribute of the superclass whose values determine the superclass D. An attribute of the subclass whose values determine the subclass 22. Which of the following features is TRUE about a superclass/subclass hierarchy? A. Subclasses at the lower lever in the hierarchy inherit attributes only from their immediate superclass B. Attributes are assigned at the highest logical level. C. Subclasses at the higher lever in the hierarchy inherit attributes only from their immediate subclass D. Attributes are assigned at the lowest logical level. 18. The subclass which has more than one superclass is called? A. Partial subclass B. Shared subclass C. Shared superclass D. Joint superclass 19. Analyze the following entity relationship diagram (ERD). Determine all possible business rules from the diagram in figure below. Lecturer Lecturer No Lecturer Name 1.1 LecturerEmail teaches Subject SubjectCode 0.3 Subject Name Section 15 enroll Student Student No Student Name 5.30 StudentEmail 1. II. III. A lecturer can teach from 0 up to 3 subjects. Each class must be taught by more than one lecturer. A class must have a minimum of 5 students and a maximum of 30 students. A student can enroll to a minimum of 1 class and a maximum of 5 classes. IV. A. I, II and III B. I, II and IV C. I, III and IV D. II, III and IV 16. Applications for potential employees received by ABC Company are categorized as IT based companies or non-IT based companies. Application A IT-based Company Non IT-based Company Based on the description given, determine the participation and disjoint constraints of a superclass/subclass relationship in the given figure. A. {Mandatory, OR B. {Mandatory, AND C. Optional, OR) D. Optional, AND 17. Consider the following ER diagram M P N RI MI PI NI N2 M2 P2 MU The minimum number of tables needed to represent M, N, P, RI, R2 is A. 2 B. 3 D. 5 12. Select a suitable language that allows users to specify the data types and structures and constraints on the data to be stored in database. A. Structured query language B. Data definition language C. Data manipulation language D. Data control language 13. Which of the following is a single valued attribute? A. Register_number B. Address C. Subject_taken D. Reference 14. Which of the following is an example of a structural business rule? A. All overdue payments will have an added 10 % late fee. B. Buildings to be purchased by the business must be current with earthquake building code. C. All products will have a selling price no less than 30 % greater than wholesale. D. All employees must belong to at least one department. 15. Which of the following would NOT likely be an attribute of an entity called "Student"? A. Age B. Student identification number C. Classroom number D. Gender 8. Which of the following statements is NOT part of the main reasons of changing File-based approach to Database approach? A. Data redundancy B. Separation and isolation of data C. Duplication of data D. Reduce data storage 9. Which of the following is NOT a critical guideline to the success of database design? A. Integrate structural and integrity constraints into the data models B. Combine conceptualization, normalization, and transaction validation techniques into the data modeling methodology C. Work with database only D. Construct a data dictionary to supplement the data model diagrams 10. A grandfather and grandson with the same first name and same last name live together, and they have the same contact number. Therefore, adding the address would not help to distinguish them too. Which of the following is NOT suitable to use as the primary key to distinguish this grandfather and grandson? A. bom of the year B. identity card number C. first name and last name D. middle name 11. E-R modeling technique is a: A. Top-down approach B. Bottom-up approach C. Left-right approach D. None of the above