Review

3 4

The following questions are intended to reinforce key information presented in this chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. You can find answers to the questions in Appendix A, "Questions and Answers."

1. What does a SQL Server database consist of?
2. What is normalization?
3. What are the four basic rules that you should follow when normalizing a database design?
4. What are the three basic types of relationships that can exist between tables in the SQL Server database, and what are the basic differences between these types?
5. What are the three types of operating system files that SQL Server uses?
6. What two stages of security does a user pass through when working in SQL Server, and how do these stages differ?
7. What are the four primary tasks that you should perform when identifying the system requirements for a database design?
8. When determining the volume of data that the system will manage, you should identify what two types of information?
9. When determining how data will be used in a new system, you should identify what three types of information?
10. When you are gathering system requirements for a database design, one of the steps that you should take is to define the specific categories of data. What type of object within a database maps to these categories of information?
11. What task do you perform after determining that a relationship exists between two tables, and how do you perform that task?
12. What information within the system requirements should you base data constraints upon?