1. For a given database, the number of tables in its relational schema is always same as the number of entities in its Entity-Relationship diagram.

a) True b) False c) Need more information to decide

2. Which one of the followings is correct about the primary key and the foreign key?

a) A table can have more than one primary key. b) The name of the foreign key can be different than its corresponding primary key. c) A primary key cannot include more than one attribute. d) Foreign key cannot include more than one attribute.

3. Which of the followings are true about table characteristics of relational databases?

Choose all that apply. a) Row order is important b) Each column of a table has a unique name c) Each row is unique in a table d) It is ok if we see several values in a single cell.

4. Which of the followings are example of absolute cell reference? Choose all that apply.

a) B2 b) $B2 c) B$2 d) $B$2

5. Information Technology consists of exactly the following components:

a) Hardware, procedures, software, and people. b) Hardware, software, and data. c) People, data, procedures, and software. d) Software, hardware, people, procedures, and data. e) Software, hardware, people, procedures, data, and networks.

6. A normalized flat file database

a) Hardware, procedures, software, and people. b) Hardware, software, and data. c) People, data, procedures, and software. d) Software, hardware, people, procedures, and data. e) Software, hardware, people, procedures, data, and networks.

7. Consider the following database outline:

CUSTOMER(CustomerID, FName, LName, fk)

fk foreign key to HEALTHPLAN

HEALTHPLAN(PlanID, Provider, Premium)

a) The field fk has to have the same name as the primary key in HEALTHPLAN.

b) The field fk has to have the same datatype as the primary key in HEALTHPLAN.

c) There should also be a foreign key in HEALTHPLAN.

d) a and b are correct.

e) a and c are correct.

8. Information Technology consists of exactly the following components:

f) Hardware, procedures, software, and people.

g) Hardware, software, and data.

h) People, data, procedures, and software.

i) Software, hardware, people, procedures, and data.

j) Software, hardware, people, procedures, data, and networks.