CIS 115: Databases Chapter Two
Applied Assignment

1


This assignment is a learning activity. You can use your textbooks, notes, and completed exercises. Some
students find it helpful to refer back to the Lessons/Tutorials from this course, or to use an Internet
search of skills to help complete these exercises. Students may also seek help from classmates or tutors
on this assignment, but each student is expected to complete their own work. Sharing of files is NOT
allowed and is considered a violation of the Academic Honesty Policy.
Anytime these instructions refer to your name, replace that with your actual name.
The questions and answers included in this assignment are to help you understand important concepts
from this chapter. They do not need to be answered as part of the assignment.
Prepare:
Make sure you are working with a PC with Microsoft Access installed. This means you will NOT be able
to use a Mac or Chromebook for this activity. Computers with the correct software are available in the
Achievement Center and Library on campus. Microsoft Access is available to students for FREE – refer to
the instructions for obtaining your FREE Microsoft 365 subscription and FREE downloads of Office 2019
– including Microsoft Access – in the first course Module.
Download the file named DBChapterTwoStartingFile.accdb to your computer. Before you open the file,
rename it to YourLastName_StudentsTeachers.accdb.
Scenario:
You are working with a database to track students and teachers at your elementary school.
Tasks:
Open a Microsoft Access Database.
1. Open Microsoft Access and the file named YourLastName_StudentsTeachers.accdb.
Rename and view existing tables
2. Rename the tables as follows:
Student → YourLastName_Student
Teacher → YourLastName_Teacher

Question: View the two tables in datasheet view and decide which field in the
YourLastName_Teacher table is related to which field in the YourLastName_Student table.

Answer: The “Class Number” field is located in both tables. When you enter a student’s
information into the YourLastName_Student table, you will enter a class number. Once you
enter that number, if a relationship is established correctly between the Class Number in the
two tables, the database will know the name, address, hourly rate, and year-to-date
earnings for the assigned teacher. Therefore, we need to establish a relationship between
the Class Number field in the YourLastName_Teacher table and the Class Number field in
the YourLastName_Student table.
St. Clair County Community College CIS 115: Databases Chapter Two
Applied Assignment

2

3. Close both tables. You will not be able to establish relationships between these tables if they
are open.
Create a relationship between the two tables.
4. Using Database Tools, Relationships, establish the relationship between the Class Number
field in the YourLastName_Teacher table and the Class Number field in the
YourLastName_Student table. Enforce Referential Integrity in your relationship.

Question: What does enforcing referential integrity accomplishes in this example?

Answer: Referential integrity ensures that “bad data” won’t be entered into the database. In
this case, enforcing referential integrity means that you won’t be able to assign a student to
a teacher that doesn’t already exist in the database.

Question: How did the database know this was a One-to-Many relationship, and what does
that mean for this database?

Answer: Whenever you make a relationship between a field that IS a primary key and
another field which is NOT a primary key, it is a one-to-many relationship. In this example, it
means that each teacher will be listed only one time in the Teacher table, but a teacher can
be assigned to many students in the Student table.

Finalize the Database

5. Close the relationships window, saving the layout when prompted.
6. Close the database, choosing yes to any prompts to save.

Submission Instructions:
Return to the Online Classroom assignment and upload the following file(s) for grading.
YourLastName_StudentsTeachers.accdb