For T/F do not repeat the questions. Only write the question number and the correct answer for example: 1) T, 2) F..

For Multiple choices only write the question number and the answer for example: 1) A 2) B

T/F (15 questions, 2 points each, total points 30)

1)Redundancy wastes space because you are storing different types of data in the same place.

2)A database will not only hold information about multiple types of entities, but also information about the relationships among these multiple entities.

3) A relational database handles entities, attributes, and relationships by storing each entity in its own table.

4)A query is a question represented in a way that the DBMS can recognize and process.

5)In an AND criterion, the overall criterion is true if either of the individual criteria is true.

6)The concept of grouping means that statistics will be calculated for individual records.

7)In many cases, you will need to create queries to select data from more than one table. To do so, it is necessary to join the tables based on matching fields in corresponding columns.

8)Matrix algebra is a theoretical way of manipulating a database.

9)The union of tables A and B is a table containing all rows that are in either table A or table B or in both table A and table B.

10)The intersection of two tables A and B is the set of all rows that are in table A but that are not in table B.

11)The product of two tables is the table created by combining every row in the first table with every row in the second table.

12)The join operation is the core operation of relational algebra because it is the command that allows you to extract data from more than one table.

13)The SELECT command will allow you to write a query in SQL.

14)Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as possible.

15) Relational Algebra is the foundation of relational Database.