Part 1 using microsoft sql server express or microsoft


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

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Part 1 using microsoft sql server express or microsoft
Reference No:- TGS02674318

Now Priced at $20 (50% Discount)

Recommended (96%)

Rated (4.8/5)