Chapter 9 Data Design320
Chapter Exercises
Chapter Exercises
Questions
1. In the auto shop examples in Section 9.2.2, what are some problems that might
arise in Mario’s system? Why won’t Danica run into the same problems? Provide
specific examples in your answer.
2. What is a DBMS? Briefly describe the components of a DBMS.
3. Describe a primary key, candidate key, secondary key, foreign key, and a combi-
nation key. Use your imagination to provide an example of each key that is not
in the textbook.
4. What are entity-relationship diagrams and how are they used? What symbol is
used for a relationship? What is an associative entity? Provide an example.
5. What is cardinality, and what symbols do you use in the crow’s foot notation
method?
6. What are data warehousing and data mining? How do businesses use these
tools?
7. What is an unnormalized design, and how do you convert an unnormalized de-
sign to 1NF? In your answer, refer to specific pages and figures in this chapter.
8. How would you define second normal form? How do you convert a 1NF design
to 2NF? In your answer, refer to specific pages and figures in this chapter.
9. How would you define third normal form? How do you convert a 2NF design to
3NF? In your answer, refer to specific pages and figures in this chapter.
10. How would a specific date, such as April 27, 2015, be represented as an absolute
date?
Dica
Chapter 10 System Architecture
358
Chapter Exercises
Chapter Exercises
Questions
1. This chapter begins with an architecture checklist. If you had to rank the items, from most important
to least important, what would your list look like?
2. What is enterprise resource planning (ERP)? What is supply chain management (SCM)?
3. Suppose you had a client who never used a network. Explain, in everyday terms, the role of network
servers and clients.
4. Describe client/server architecture, including fat and thin clients, client/server tiers, and middleware.
5. Trace the history of system architecture, with particular emphasis on the impact of the personal com-
puter and the Internet. Be sure to include examples.
6. Is batch processing still relevant? Why or why not?
7. Explain the difference between a LAN and a WAN.
8. Define the term topology, and draw a sketch of each wired and wireless network topology.
9. Explain the main difference between the BSS and ESS wireless topologies. To what kind of wireless to-
pology do the 802.16 standards apply?
10. List the sections of a system design specification, and describe the contents.
Discussion Tonic