Figure A.1: ER diagram Client-Borrows-Book Database Borrows Book library BI Bisne N FN Client Name Id LN Phone employee regular M 1 helps date Use the ER diagram of Figure 4.1 to answer the next few questions 1. Which statement best describes the cardinality constraint of the relationship "Borrows shown in Figure A.1 above? a. Each client can borrow only one book, and each book can be borrowed by many clients. b. Each client can borrow many books, and each book can be borrowed by many clients. c. Each client can borrow many books, and each book can be borrowed by only one client. d. All of the above. e. None of the above. 2. Which statement best describes the participation constraint of the relationship helps? shown in Figure A.1 above? 1. Each dient employee must help every regular client through 'helps recursive relationship b. Only some client employee can help a regular client through helps recursive relationship c Every client employee must help some regular client through helps' recursive relationship d. All of the above. e None of the above 3. What is the text schema for the Relationship Borrows' in Figure A.1 above? a. Borrows (library). b. Borrows (Id, Bid, library). Borrows d. All of the above. e. None of the above. 4. Which of the following can be an example of a multi-valued attribute in ER modeling of a database? a. phone b. email c. address d. All of the above e. None of the above 5. One limitation of traditional file system, which runs programs with data, that is solved by using a database management system is: a. Provision of data independence b. Separation of data from program using the three data level architecture c. Replication of data and programs d. Use of the internet e. None of the above 6. In a database, integrity constraints must not be violated after any database update. Given a database table with schema Customer (Id. Ename. Lname, phone), which has a state having the two tuples and 22, Pat', 'Moore', '519-333-6161>, what integrity constraint is violated by inserting the following new tuple into Customer
? a. Entity Integrity constraint b. Foreign key referential integrity constraint c. Primary key integrity constraint d. All of the above e. None of the above Figure A2: A B R 7. Which statement best describes the relationship shown in Figure A.2 above? a. Each A record can relate to only one record of B through R. b. Each A record can relate to multiple records of B through R c. Each B record can relate to multiple records of A through R d. There can be multiple records of A and B related through R e. None of the above 8. An Example of a database management systems (ohms) where data model is table is: a. NOSQL dbms b. Relational du c. Object oriented dbus d. All of the above e. None of the above 9. Using the client borrows book" database described in Fig Al an example state (instance) of the Book schema with valid book types as (fiction', 'drama', 'poetry") and each record in brackets and ended with a semicolon, is: a. (l', 'poetry", "folktale"); (+2", "drama, fiction); b. (d1', poetry'); (d2', 'drama); c ('1', "fiction"); (NULL, 'fiction"); d. All of the above e. None of the above 10. Using the client borrows book" database described in Fig. 4.1, an example English language query that can be asked on that database is: a. Get all employee clients and the regular clients they helped. b. Get the Id, FN, LN, phone of every client c. Get the book Bld borrowed by each client, and the library borrowed from. d. All of the above e. None of the above
