Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
Chapter 7. Working with Constraints, Tri... > Lab Question
Lab Question
| Q1: | You are implementing a table that will have high demands for data integrity. There are three columns that are particularly sensitive according to the departmental manager of the department that will use the table data most. She says that the e-mail address column must have the structure of an e-mail address, but that it should also be validated by sending an e-mail to the address requesting a response to ensure that it really is the e-mail address of the individual. In addition, she wants to be sure that phone numbers have the country code of 1 included because an application that her employees use needs this to be there. She states that there will be no records with phone numbers from countries other than the United States. Finally, she indicates that she wants the last name of the entry to be validated against another database to verify that the last name is proper for the e-mail address of the same record.
Which SQL Server mechanisms covered in this chapter will allow you to meet the demands of this table? |
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint