Chapter 2

   

---

1:	When is the best time to use an RDBMS program's design tools?
A1:	The best time to use an RDBMS program's design tools is after you design the logical structure of the database.
2:	True or False: Design is crucial to the consistency, integrity, and accuracy of data.
A2:	True. Design is crucial to the consistency, integrity, and accuracy of data.
3:	What is the most detrimental result of improper database design?
A3:	The most detrimental result of improper database design is inaccurate information.
4:	What fact makes the relational database structurally sound and able to guarantee accurate information?
A4:	The fact that the relational database model is based on set theory and first-order predicate logic makes the relational database structurally sound and able to guarantee accurate information.
5:	State two advantages of learning a design methodology.
A5:	These are the advantages to learning a design methodology: It gives you the skills you need to design a sound database structure. It provides you with an organized set of techniques that will guide you step-by-step through the design process. It helps you keep your missteps and design reiterations to a minimum. It makes the design process easier and reduces the amount of time you spend designing the database. It will help you understand and use your RDBMS software more fully and effectively.
6:	True or False: You will use your RDBMS program more effectively if you understand database design.
A6:	True. Understanding database design will help you use your RDBMS program more effectively.
7:	State two objectives of good design.
A7:	These are the objectives of good design: The database supports required and ad hoc information retrieval. The tables are constructed properly and efficiently . Data integrity is imposed at the field, table, and relationship levels. The database supports business rules relevant to the organization. The database lends itself to future growth.
8:	What helps to guarantee that data structures and their values are valid and accurate at all times?
A8:	Data integrity helps to guarantee that data structures and their values are valid and accurate at all times.
9:	State two benefits of applying good design techniques.
A9:	These are the benefits of applying good design techniques: The database structure is easy to modify and maintain. The data is easy to modify. Information is easy to retrieve. End- user applications are easy to develop and build.
10:	True or False: You can take shortcuts through some of the design processes and still arrive at a good, sound design.
A10:	False. You cannot take shortcuts through some of the design processes and still arrive at a good, sound design.

---

Top