Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 box Business 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 (xxxxxx@herzing.edu) and cannot be blank Part 2 Build a Visual Basic user interface (front end) called IS171_Student_Info that allows for the following: Ability to insert a record into the database table Ability to delete a record from the database table Ability to update a record from the database table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part 2 Lnai 8725

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448505, 978-3662448502

More Books

Students also viewed these Databases questions

Question

Identify cultural barriers to communication.

Answered: 1 week ago