Name: 
 

Chapter Six Study Guide (A114 & I111 Fall 2003)



Completion
Complete each sentence or statement.
 

1. 

A(n) ____________________ view is the set of requirements that is necessary to support the operations of a particular database user.
 

 

2. 

For each table, you must identify the primary key, any alternate keys, secondary keys, and ____________________ keys.
 

 

3. 

It is through the foreign keys that you can create relationships among tables and enforce certain types of ____________________ constraints in a database.
 

 

4. 

To create a(n) ____________________ relationship, create a new table whose primary key is the combination of the primary keys of the original table.
 

 

5. 

After establishing the relationships among the entities, the step is to normalize each table with the target being the ____________________ normal form.
 

 

6. 

A(n) ____________________ key is a column or collection of columns that could have been chosen as a primary key, but was not.
 

 

7. 

A(n) ____________________-relationship diagram visually represents the structure of a database.
 

 

8. 

____________________ key restrictions determine the relationships between the tables.
 

 

9. 

When merging the result into the design, combine tables that have the same ____________________ key to form a new table.
 

 

10. 

An entity that does not require a relationship to another entity for identification is called a(n) ____________________ entity.
 

 

11. 

In an E-R diagram, the ____________________ entities have rounded corners.
 

 

12. 

A relationship that is not necessary is called a(n) ____________________ relationship.
 

 

13. 

When the DBMS cannot enforce restrictions, the task must be completed by the users or the ____________________.
 

 

14. 

In an E-R diagram, when the relationships are denoted by a "1" and an "n", this represents a(n) ____________________ relationship.
 

 

15. 

In an E-R diagram, a diamond shape within a rectangle represents a(n) _____________________ entity.
 

 

16. 

In an E-R diagram, an alternate way to represent a one-to-many relationship is to omit the "one" and put a(n) ____________________ at the "many" end of the relationship.
 

 

17. 

The number of items that must be included in a relationship within an E-R diagram represent ____________________.
 

 

18. 

An entity in a relationship with a minimum cardinality of ____________________ plays an optional role in the relationship.
 

 

19. 

An entity with a minimum of _____________________ plays a mandatory role in the relationship.
 

 

Short Answer
 

20. 

What is the name of the set of requirements that is necessary to support the operations of a particular database user?
 

21. 

After establishing the relationships between the entities during a design, the next task is to normalize each table.  In what normal form should these tables be targeted?
 

22. 

What is a column or collection of columns that could have been chosen as a primary key but was not?
 

23. 

What type of diagram visually represents the structure of a database?
 

24. 

What restrictions determine the relationships between the tables?
 

25. 

What shape generally represents an entity in an E-R diagram?
 

26. 

An entity that does not require a relationship to another entity for identification is known as what type of entity?
 

27. 

When the DBMS cannot enforce restrictions on a table, who should enforce these rules?
 

28. 

A diamond within a rectangle in an E-R diagram represents what type of entity?
 

29. 

When indicating a one-to-many relationship, an alternative to the "one" and "many" indicators is to delete the "one" and place what at the "many" end of the relationship?
 

Essay
 
 
chsix3_files/i0330000.jpg
 

30. 

Please refer to the above figure.  Break this table apart into two separate tables.
 
 
chsix3_files/i0350000.jpg
 

31. 

Please refer to the above figure. Define the primary key of the Sales table and explain your answer.
 



 
Check Your Work     Reset Help