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. Client helps Id Name FN LN date Borrows Book BId Btype Phone library 4 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?

a. Each client 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).

c. Borrows (Id, BId).

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

Figure A.1: ER diagram Client-Borrows-Book Database Borrows Book 1 library BId Btype N FN Client Name Id LN Phone employee regular M helps date Use the ER diagram of Figure A.1 to answer the next few questions