Introducing SQL Server

APPENDIX D

Exercises

Even though we’ve made a pretty solid database, there are a few enhancements we could make if we chose to do so. These potential enhancements are presented now for you, the reader, to undertake. Good luck!

1. Add a unique constraint to the PhoneNumberTypes table

   At the moment, this table allows the same phone number type to be added multiple times. I could have four “Home” phone number types, each with a different ID. Try to add a unique constraint to ensure the phone number type must be unique.

2. Bulk import using staging tables

   This is a harder exercise. Do you remember our BULK INSERT chapter? We created a set of text files to ...