Part 1: Using Microsoft Sql Server Express or Microsoft Access, design a database with one table to store the following information:
- Student_ID - 6 digit alphanumeric string that must begin with a lowercase letter
- Student_FirstName - must only contain valid alphabet characters and cannot be blank
- Student_LastName -- must only contain valid alphabet characters and cannot be blank
- Student_Major - must be a selection of the following from a dropdown combo boxBusiness Administration
- Computer Science
- Information Systems
- Justice Administration
- Psychology
- Student_PhoneNumber - must be of the format 555-555-5555 and cannot be blank
- Student_EmailAddress - must be of the proper email format