Question: Create a sample database in Microsoft Access with the tables and relationships required to support your team's design. Each table of the Access database must

Create a sample database in Microsoft Access with the tables and relationships required to support your team's design.
Each table of the Access database must contain at least all of the attributes that were submitted in the most recent project deliverable.
Populate the tables in your database with at least 30 rows of TEST data (no actual student, employer, or other security-sensitive data. ). Make sure that the data is of the proper data type and is appropriate to the subject matter (e.g. legal client data for a law firm's operational database, etc.). While the data is "dummy data," make sure it is appropriate for the SQL Queries assignment. For example, a field like FIRST_NAME should have entries with fictional people's first names, not colors, shapes, or something else. Please use appropriate names e.g. FIRST_NAME: Sheila LAST_NAME: Winters NOT FIRST_NAME: Red LAST_NAME: Blue.
In the related SQL assignment, the team will create SQL queries to retrieve and/or modify specific sets of records in the database.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!