Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 101 A PPLY YOUR K NO WLEDGE 4. To disallow changes on an attribute, use the NO CHANGES property. Because changes are not going to be made on the date an employee was hired, place this value beside the Hire_Date attribute. 5. The UNIQUE characteristic specifies that duplicate values not be permitted on any given column. In the Employee entity, the Phone, SSN, and Address attributes cannot have duplicate values; that is, no employee can have the same phone number as any other employee. 6. The final entity should look similar to the one in Figure 2.15. If you have not already copied out the entity, then copy it out. Review Questions 1. How does data processing occur in the client/server model? 2. What are entities, attributes, and relationships? 3. Why would you want to decompose an attribute? 4. How are Foreign Keys related to Primary Keys? 5. Name four constraints that can be placed on columns. Why would you want to place constraints? 6. When would you consider denormalizing a database? Exam Questions 1. You have prepared the logical design for a very large database system that will act as the back end for an Internet application, as well as being accessed from the corporate WAN. You need to support a large number of concurrent users who will be accessing the database at various bandwidth speeds. Which SQL Server technologies could assist in allowing the users access while providing good performance? Choose all that apply. A. Analysis services B. Replication C. Partitioned views D. English query E. Meta data services 2. You are designing a database that will be used for a small office. The client machines have minimal hard drive space and very little RAM. Other than the database server, there are no server-grade machines available. You have chosen a SQL Server in a client/server architecture as the best implementation for this system. Which application architecture is best suited for this system? A. Single-tier B. Two-tier thin client C. Two-tier thick client D. N-tier E. Internet
For high quality website hosting services please check tomcat web hosting website.