.

Create tables and query in MS Access

Assignment 3 : Solution

Create tables and query in MS Access

Create tables and query in MS Access

ER DIAGRAM

Create tables and query in MS Access

CREATING DATABASE

After analysing the ER diagram, the database is created. It consists of 4 tables.

1. Student enrolled

2. Professors

3. Courses

4. Grades

DESIGN OF TABLES

1. Student enrolled

ms access create queries

2. Professors table

ms access create queries

3. Courses table

4. Grades table

ms access create queries image 1

RELATIONSHIPS BETWEEN TABLES

As the database contains 4 tables, these 4 tables are joined together for running queries.

Screenshot of the relationship between table is given below:

ms access create queries

RECORDS IN THE TABLE SCREENSHOTS

1. In student enrolled table.

ms access create queries image 1

2. In Professors table.

ms access create queries image 1

3. In courses table.

4. In grades table

QUERIES

1. Selecting all the information of student whose last name is “Webb”.

SQL VIEW

RESULT

2. Selecting all the student first name, last name and phone numbers.

SQL VIEW

RESULTS

3. Selecting instructor first name, last name and course offered.

SQL VIEW

RESULTS

ms access create queries

.