Lab End of Module Submission – Database Activity 04
Subject Name: Accounting Information Systems
Subject Code: ACCP 5301
Due Date: End of Module 4 (Blackboard Dropbox)
Lab Component
Databases are integral ways organizations store large volumes of data. More importantly, databases
can be utilized to source vast amount of data and organize it in a manner that provides powerful
information. We will learn the basics of:
- Read a provided UML model and design a new database based on the UML specs
- Build relationships between tables
- Build more queries – utilizing both the query wizard and using SQL query language
The following outlines the files needed to complete the self-led tutorials and tools which will be utilized:
Activity
Chapter 6 Comprehensive [Link]
AIS_Ch06_Comprehensive_Exercise_Data.xlsx
Open MS Access and select a new DB file and
name ‘[Link] 6
Comp [Link]’
Utilize ‘Chapter 6 Comprehensive [Link]’ which contains the step-by-step instructions and is set up as
a self-led tutorial to aid you in learning and applying the utilization of the above noted learning
objectives.
By the end of the tutorial, you will be empowered to utilizing a UML model to build a database from
scratch, build the relationships between tables, and also build queries to help answer simple business
questions.
You can work collaboratively with classmates, but it is the expectation that each student is submitting
their own completed data file by the end of class time.
Now let’s get started by doing an example with the class.
This assignment is to be submitted through the Blackboard Assignment Dropbox.
