Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 103 APPLY YOUR KNOWLEDGE D. Decomposable normal form E. Boyce-Codd normal form 7. You are working for an automobile dealership that tracks inventory in a SQL Server database. The database contains information on the autos in stock. A partial listing of attributes is as follows: VehicleIDNo(20 char), InvoiceNo (bigint), Make(20 char), Model(15 char), Year(smalldatetime), Colorcode(int), PurchasePrice(smallmoney), StickerPrices (smallmoney). Which of the columns would you choose as a Primary Key? A. Use a compound key with Make, Model, and Year. B. Create a surrogate identity key. C. Use the VehicleIDNo as the key. D. Use the InvoiceNo as the key. E. Use a compound key with InvoiceNo and VehicleIDNo. 8. You are working in a database that has a nchar(5) attribute used to store solely numeric data. You want to minimize the amount of disk space used for storage and need to select an alternative data type. Which of the following data types would you select? A. char(5) B. real C. smallint D. int E. bigint 9. You are creating a historical database that stores information about important dates in history. You need to be able to store dates from the beginning of the 14th century. You want to minimize the storage space used by the data. Which data type would you use? A. datetime B. smalldatetime C. bigint D. int E. char(8) 10. You are preparing a database structure for a large construction company. At any one time the company is working on five or more job sites, and each site has between 25 and 200 homes. In charge of each site is a site supervisor who organizes the subcontractors at each phase of the building process (landscaping, framing, drywalling, electrical, plumbing, and so on). Any subcontractor who is planning on working on a given site must be found in a database of approved vendors. The company would like a structure that would allow for storage of the subcontractors personal information and information about each site that includes the subcontractors assigned to the site. How would you set up this structure? A. A Site entity and a Contractor entity B. A Site entity, a Contractor entity, and a Site/Contractor entity C. A Site entity, a Process entity, and a Contractor entity D. A Site entity, a Contractor entity, and a Site/Process entity
For high quality java hosting services please check tomcat web hosting website.