Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 105 A PPLY YOUR K NO WLEDGE Component/Parts E. Suppliers, Equipment, Components, Parts, Component/Equipment Answers to Review Questions 1. The client/server model can be thought of as a connection between a client program or computer requesting a service or data from the server. When the client application needs certain data, it makes a call to the server. The server searches for only the specific data sought by the client and then fulfills the client s request by sending the requested data back to the client application. 2. An entity can be thought of as a table. Entities are usually represented as boxes. Attributes are the characteristics of the table. Attributes are usually represented as rows inside an entity. They can be thought of as the columns of a table. The Primary and Foreign Keys on those tables make up the relationships. They show the relationship of one table to another in a real- world situation. 3. Decomposing an attribute provides many benefits in contrast to using general-built attributes. Decomposing an attribute is done when data integrity is a key factor and also when data query performance needs to be improved. See Optimizing Attributes. 4. A Foreign Key is a column or multiple columns whose values match the Primary Key of another table. Foreign Keys help in the relational process between two entities by connecting to a Primary Key. When a Primary Key is created on a parent table, it is connected to another table by hooking onto the other table s Foreign Key. See the section Foreign Keys. 5. The four constraints that can be placed on columns are Default, Null, Duplicate, and Changes. When the data model approaches perfection, certain measures must be taken to provide the most for your needs and to keep data integrity at its peak. These restrictions or constraints maintain the correctness of the data being entered. 6. Denormalization is undertaken when the database lacks performance. A database that has been normalized requires more join queries to gather information from multiple tables. Therefore, CPU usage might overwhelmingly increase and cause applications to freeze. In situations like this, denormalization is appropriate. Answers To Exam Questions 1. B, C. Replication and partitioned views enable you to spread the load of a very large database system across several machines. The benefit of additional processing power and getting the data closer to the user could be recognized by both features, assuming they were properly partitioned and configured. For more information, see the section titled The Client/Server Model. 2. B. With few resources on the clients, you have to make the clients as small as possible. N-tier or Internet could be potential solutions, but with the lack of sufficient processing power in the form of a server-grade machine, these would not suit this scenario. For more details, see the section The Client/Server Model. 3. E. This is a good candidate for an Internet solu
If you looking for unlimited one inclusive web hosting plan please check web hosting plan website.