1 / 21100%
CIS111
Preview: CIS111 : Introduction to Relational Database Management
Systems
Course Guide
Prerequisites
Course Description
Instructional Materials
CIS105 (Introduction to Information Systems)
OR CIS106 (Introduction to Information Technology)
OR CIS109 (Introduction to Management Information Systems)
This course provides students with an introduction to the theory and applied concepts of database
design, database management, and information management. Students will focus on identifying
organizational information requirements, expressing those requirements using conceptual data
modeling techniques, verifying the structural characteristics with normalization techniques, and
converting conceptual data models into physical database models.
Required Resources
MindTap Computing for Shellman/Vodnik’s New Perspectives Microsoft® Office 365 & Access
2016: Comprehensive
Students will receive a registration key for this course when they purchase new course
materials from the Strayer University Online Bookstore. Please click the “MindTap Info”
menu option in the course to learn how to activate your software.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
MindTap Live Virtual Machine Labs and Lab Simulations and are used throughout this course to
promote advanced learning opportunities.
MindTap Labs Online Access Code: Students who purchased their textbooks through
Strayer Bookstore will receive a bundled access code for MindTap Labs.
Microsoft Office (Word and Access) 2016, 365, or later version is required.
Note: MS Access is the focus of this class and is not available for Apple/MAC computers.
Students are responsible for securing access to a PC. Instructions for downloading the files
necessary to complete the work in this class are available in the course guide. Students who
wish to attempt to run Windows on MAC computers are welcome to do so; however, Strayer
University does not recommend this or support it and keyboards are not equivalent.
Information on how to obtain Microsoft Office through Strayer iCampus (at no additional
charge) in the Office 365 Installation Instructions [PDF]
Once you access iCampus, go to Campus & Library > Technical Support > Software
Discounts & Downloads > Open Office 365.
Reference. No date. What Is the Importance of a Database Management System?
https://www.reference.com/world-view/importance-database-management-system-
98d9d2dd0a5d9781
EDUCBA. No date. The Database Management Systems Advantages.
https://www.educba.com/types-of-database-management-systems/
Computer Education For All. January 9, 2017. What Is Database | Types of Database |
Advantages of Database | DBMS. https://www.youtube.com/watch?v=BHzAC6hMr4o
Muhammad Haadi. 2010. The Evolution of Database.
https://mhaadi.wordpress.com/2010/10/18/the-evolution-of-database/
Kyra Sheahan. No date. File Organization Techniques. https://smallbusiness.chron.com/file-
organization-techniques-545.html
Tutorialspoint. No date. DBMS Transaction.
https://www.tutorialspoint.com/dbms/dbms_transaction.htm
Tutorialspoint. No date. DBMS Concurrency Control.
https://www.tutorialspoint.com/dbms/dbms_concurrency_control.htm
Saplearningacademy. May 30, 2017. Fundamental Knowledge on OLTP and OLAP? What Is
OLTP and OLAP? Difference on OLTP and OLAP. https://www.youtube.com/watch?
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
v=fdeJjX2qygk
Techtud. August 29, 2014. Illustration on ER Model to Relational Tables - 1 | Database
Management System. https://www.youtube.com/watch?v=Dggxri0iYLI
Lucidchart. March 6, 2017. Entity Relationship Diagram (ERD) Tutorial - Part
1. https://www.youtube.com/watch?v=QpdhBUYk7Kk
Ashish Seth. February 12, 2016. ERD #2 Mapping ERD to Relations.
https://www.youtube.com/watch?v=xUhd-p5knmo
Techtud. September 28, 2014. Normalization | Database Management System.
https://www.youtube.com/watch?v=IwswNIZ_PSg
BBarters. August 14, 2017. How to Do Database Normalization. https://www.youtube.com/watch?
v=UDFRhj_K508
YourProgrammingNetwork. February 5, 2014. Access 2013 - Tutorial 5 - Database Normalization.
https://www.youtube.com/watch?v=NuzCeyQOSzg&feature=youtu.be
Lucidchart. July 14, 2017. Entity Relationship Diagram (ERD) Tutorial - Part 2.
https://www.youtube.com/watch?v=-CuY5ADwn24
Creately. 2019. Ultimate ER Diagram Tutorial (Entity Relationships Diagrams).
https://creately.com/blog/diagrams/er-diagrams-tutorial/
Dane Hartman. May 13, 2016. Computer Skills Course: File Management, Part 1.
https://www.youtube.com/watch?v=k-EID5_2D9U
Allison Ryder. 2017. Video: Best Practices in Data Security.
https://sloanreview.mit.edu/article/video-best-practices-in-data-security/
Microsoft. 2019. Innovative Systems Units Its Far-Flung Database in the
Cloud. https://customers.microsoft.com/en-us/story/innovative-systems-partner-professional-
services-azure-sql-database
Microsoft. 2018. Full Speed Ahead: Mining Company Moves Faster With SAP in the
Cloud. https://customers.microsoft.com/en-us/story/mmg-mining-oil-gas-azure
SQL Server Team. 2012. Thai Law Enforcement Optimizes Investigations With Microsoft Big Data
Solution. https://cloudblogs.microsoft.com/sqlserver/2012/08/09/thai-law-enforcement-
optimizes-investigations-with-microsoft-big-data-solution/
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Creating a Database.
Rishabh Software. 2013. Importance of Certifications in the Technology
Industry. https://www.rishabhsoft.com/blog/importance-of-certifications-in-the-technology-
industry
Supplemental Resources
Adrienne Watt. 2014. Database Design. https://open.umn.edu/opentextbooks/textbooks/354
Ron McFadyen. 2016. Relational Databases and Microsoft Access.
https://open.umn.edu/opentextbooks/textbooks/relational-databases-and-microsoft-access
John Hales. 2005. SQL Guide. https://search-ebscohost-com.libdatab.strayer.edu/login.aspx?
direct=true&db=nlebk&AN=1534594&site=ehost-live&scope=site&ebv=EB&ppid=pp_1
Jeff Relkin. 2006. 10 Ethical Issues Confronting IT
Managers. https://www.techrepublic.com/article/10-ethical-issues-confronting-it-managers/
Summarize the capabilities of relational database management systems
informed by the setup and installation process.
1
Draw a database design diagram that depicts the attributes and
relationships of the entities.
2
Use a relational database tool to create tables and queries.
3
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 1 - To Do List
Prepare: Use the Internet to prepare for this week's discussion.
Discuss: Introduce yourself and participate in the discussion, Introduction to Databases.
MindTap: Complete Access Module 1 SAM Training.
Week 2 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Building a Database and Defining Table Relationships.
Prepare: Use the Internet to prepare for this week's discussion.
Discuss: Complete the discussion, The Evolution of Databases.
MindTap: Complete Access Module 2 SAM Training.
Week 3 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Maintaining and Querying a Database.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 3 - To Do List
Prepare: Use the Internet to prepare for this week's discussion.
Discuss: Complete the discussion, Basic File Organization Techniques.
MindTap: Complete Access Module 3 SAM Training.
Week 4 - To Do List
Learn: Read the MindTap module and complete the hands-on activities.
MindTap: Read Creating Forms and Reports.
Prepare: Use the Internet to prepare for this week's discussion.
Discuss: Complete the discussion, The Difference Between OLTP and OLAP.
MindTap: Complete Access Module 4 SAM Training.
Week 5 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Creating Advanced Queries and Enhancing Table Design.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 5 - To Do List
Discuss: Complete the discussion, Introduction to SQL.
MindTap: Complete Access Module 5 SAM Training.
Prepare: Review the instructions for the assignment due in Week 6.
Week 6 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Using Form Tools and Creating Custom Forms.
Prepare: Use the Internet to prepare for this week's discussion.
Discuss: Complete the discussion, Data modeling techniques to capture the information
requirements.
Assignment: Complete the assignment, Download MS Access.
MindTap: Complete Access Module 6 SAM Training.
Week 7 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 7 - To Do List
MindTap: Read Creating Custom Reports.
Prepare: Use the Internet to prepare for the discussion.
Discuss: Complete the discussion, The Purpose and Principles of Normalizing a Relational
Database Structure.
MindTap: Complete Access Module 7 SAM Training.
Prepare: Review the instructions for the assignment due in Week 8.
Week 8 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Sharing, Integrating, Analyzing Data.
Discuss: Complete in the discussion, The Role of Databases and DBMS in the Context of
Enterprise Systems.
Assignment: Complete the assignment, Create an ERD.
MindTap: Complete the Access Module 8 SAM Training.
Week 9 - To Do List
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 9 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Managing and Securing a Database.
Prepare: Use the Internet to prepare for the discussion.
Discuss: Complete the discussion, The Key Principles of Data Security and Data Security Risk.
MindTap: Complete Access Module 12 SAM Training.
Prepare: Review the instructions for the assignment due in Week 10.
Week 10 - To Do List
Learn: Read the MindTap module, supplemental readings, and complete the hands-on activities.
MindTap: Read Relational Databases and Database Design.
Prepare: Use the Internet to prepare for the discussion.
Discuss: Complete the discussion, Big Data and Why It Is Important.
Assignment: Complete the assignment, Create Tables and Queries in MS Access.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 11 - To Do ListWeek 11 - To Do List
Learn: Read The Importance of Certification.
Prepare: Use the Internet to prepare for the discussion.
Discuss: Complete the discussion, The Importance of Certification.
Grading Scale
Participation Total Points % of Grade
Discussion Participation 165 16.5%
Assignment Total Points % of Grade
Week 1 - MindTap - Access Module 1 SAM Training 55 5.5%
Week 2 - MindTap - Access Module 2 SAM Training 55 5.5%
Week 3 - MindTap - Access Module 3 SAM Training 55 5.5%
Week 4 - MindTap - Access Module 4 SAM Training. 55 5.5%
Week 5 - MindTap - Access Module 5 SAM Training 55 5.5%
Week 6 Assignment - Download MS Access 90 9%
Week 6 - MindTap - Access Module 6 SAM Training 55 5.5%
Week 7 - MindTap - Access Module 7 SAM Training 55 5.5%
Week 8 Assignment - Create an ERD 125 12.5%
Week 8 - MindTap - Access Module 8 SAM Training 55 5.5%
Week 9 - MindTap - Access Module 12 SAM Training 55 5.5%
Week 10 Assignment - Create Tables and Queries in MS Access 125 12.5%
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Participation Total Points % of Grade
Totals 1000 100%
Final Course Grade
Points Percentage Grade
900 - 1000 90% - 100% A
800 - 899 80% - 89% B
700 - 799 70% - 79% C
600 - 699 60% - 69% D
0 - 599 59% and below F
Unique Course Features
Grading Scale Notation
Please consult the University Catalog and your academic advisor to determine the final grade
needed in this class to satisfy your specific degree conferral requirements.
Teaching Assistants
Note: This course may use Teaching Assistants (TAs) in order to assist the instructor with the
student’s learning experience. When applicable, TAs play active roles in working with the instructor
to provide student support, grading and grading feedback, and posting content in the course (e.g.
discussion posts). This course may also utilize a live chat feature, email, and phone/texting, each
of which is the instructor and, if applicable, the TA support team, for supporting students or
addressing student questions or concerns.
Lab Participation and Attendance Policy
The MindTap lab is used to support your learning in this course. However, activities completed in
MindT ap do not count for attendance. You are only given credit for attendance when you complete
one of the following tasks in Blackboard before 11:59 p.m. EST on Sunday: submit a discussion
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Assignments
post, complete a quiz or exam, or submit an assignment. Be sure to complete one of these
activities each week in Blackboard to be counted present.
Week 6 Assignment - Download MS Access
Summary
Click the linked activity title to access this assignment.
Text
Preparation
Within this assignment, you must submit proof that MS Access is loaded on your PC.
You must include a screenshot of MS Access containing your name and email address, which
appears in the upper right after you load MS Access.
See the Access Screenshot Example [PNG].
Microsoft Access is part of Microsoft Office. Students are able to download Microsoft Office
through iCampus using the following method:
If you need help to download Microsoft Office 365, read Office 365 Installation Instructions
[PDF].
If the student is using a Strayer-issued laptop, Microsoft Office will already be available to
them. They will only need to log in using their Strayer email address and iCampus password
in order to activate it. If assistance is needed, please contact the IT helpdesk.
Instructions
Write one to two paragraphs in which you:
Describe your experiences related to your setup of MS Access.
Include any difficulties or issues that you encountered during the installation.
Based on your post-installation research, describe the main capabilities of MS Access.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
You must include a screenshot of the MS Access containing your name and email address
that appears after you load MS Access.
This course requires the use of Strayer Writing Standards. For assistance and information, please
refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your
professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Summarize the capabilities of relational database management systems informed by the
setup and installation process.
Scoring Guide
Describe your experiences related to your setup
of MS Access and include any difficulties or
issues that you had encountered during the
installation. 30 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
described your
experiences
related to your
setup of MS
Access. Did not
submit or
incompletely
included any
difficulties or
issues that you
had
encountered
during the
installation.
Needs
Improvement (60-
69%)
Insufficiently
described your
experiences
related to your
setup of MS
Access
Insufficiently
included any
difficulties or
issues that you
had
encountered
during the
installation.
Satisfactory (70-
79%)
Satisfactorily
described your
experiences
related to your
setup of MS
Access
Satisfactorily
included any
difficulties or
issues that you
had
encountered
during the
installation.
Competent (80-
89%)
Competently
described your
experiences
related to your
setup of MS
Access
Competently
included any
difficulties or
issues that you
had
encountered
during the
installation.
Exemplary (90-
100%)
Thoroughly
described your
experiences
related to your
setup of MS
Access
Thoroughly
included any
difficulties or
issues that you
had
encountered
during the
installation.
Describe the main capabilities of MS Access,
based on your post-installation research, and
cite your sources. 30 %
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Unacceptable
(Below 60%)
Did not submit or
incompletely
described the
main capabilities
of MS Access,
based on your
post-installation
research, and
cited your
sources.
Needs
Improvement (60-
69%)
Insufficiently
described the
main capabilities
of MS Access,
based on your
post-installation
research, and
cited your
sources.
Satisfactory (70-
79%)
Satisfactorily
described the
main capabilities
of MS Access,
based on your
post-installation
research, and
cited your
sources.
Competent (80-
89%)
Competently
described the
main capabilities
of MS Access,
based on your
post-installation
research, and
cited your
sources.
Exemplary (90-
100%)
Thoroughly
described the
main capabilities
of MS Access,
based on your
post-installation
research, and
cited your
sources.
Include a screenshot of the MS Access
containing your name and email address that
appears after you load MS Access. 30 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
included the
screenshot
which shows
that MS Access
is installed on
your computer
and a
screenshot of a
folder with a
table included
with your name.
Needs
Improvement (60-
69%)
Insufficiently
included the
screenshot
which shows
that MS Access
is installed on
your computer
and a
screenshot of a
folder with a
table included
with your name.
Satisfactory (70-
79%)
Satisfactorily
included the
screenshot
which shows
that MS Access
is installed on
your computer
and a
screenshot of a
folder with a
table included
with your name.
Competent (80-
89%)
Competently
included the
screenshot
which shows
that MS Access
is installed on
your computer
and a
screenshot of a
folder with a
table included
with your name
Exemplary (90-
100%)
Thoroughly
included the
screenshot
which shows
that MS Access
is installed on
your computer
and a
screenshot of a
folder with a
table included
with your name.
Clarity, writing mechanics, and formatting
requirements. 10 %
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Unacceptable
(Below 60%)
More than 8
errors present.
Needs
Improvement (60-
69%)
7–8 errors
present.
Satisfactory (70-
79%)
5–6 errors
present.
Competent (80-
89%)
3–4 errors
present.
Exemplary (90-
100%)
0–2 errors
present.
Week 8 Assignment - Create an ERD
Summary
Click the linked activity title to access this assignment.
Text
Preparation
In this assignment, you will be drawing an Entity Relationship Diagram (ERD) or Database Design
Diagram. The following videos and documents will assist you:
Entity Relationship Diagram (ERD) Tutorial - Part 1.
Entity Relationship Diagram (ERD) Tutorial - Part 2.
Ultimate ER Diagram Tutorial (Entity Relationships Diagrams).
Scenario
Suppose a local college has tasked you to develop a database that will keep track of students and
the courses that they have taken. In addition to tracking the students and courses, the client wants
the database to keep track of the instructors teaching each of the courses.
Instructions for the Database Design Diagram
Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or
another tool to create the Database Design Diagram. Otherwise, you may draw the diagram by
hand with a pen and paper. If you draw the diagram by hand, then take one or more pictures of the
diagram with your cell phone or laptop camera, place the images into a Word document, and
submit the document. Otherwise, if you use software to create the Database Design Diagram,
then take one or more screen captures of the diagram, place the screen captures into a Word
document, and submit the document. Submissions that are not in .doc or .docx format will not be
graded.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Include the following in the document:
Draw the entities of the database and the attributes of each entity, based on your research
and/or common knowledge of a college and the information tracked by a college.
Create the appropriate relationships between each entity within the diagram.
Describe any assumptions that you had to make about the business rules in order to create
the diagram and the associated relationships.
This course requires the use of Strayer Writing Standards. For assistance and information, please
refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your
professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Draw a database design diagram that depicts the attributes and relationships of the entities.
Scoring Guide
Draw the entities of the database and the
attributes of each entity, based on your research
and/or common knowledge of a college and the
information tracked by a college. 50 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
draw the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Needs
Improvement (60-
69%)
Insufficiently
drew the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Satisfactory (70-
79%)
Satisfactorily
drew the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Competent (80-
89%)
Competently
drew the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Exemplary (90-
100%)
Thoroughly drew
the entities of
the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Create the appropriate relationships between
each entity within the diagram. 30 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
created the
appropriate
relationships
between each
entity within the
diagram.
Needs
Improvement (60-
69%)
Insufficiently
created the
appropriate
relationships
between each
entity within the
diagram.
Satisfactory (70-
79%)
Satisfactorily
created the
appropriate
relationships
between each
entity within the
diagram
Competent (80-
89%)
Competently
created the
appropriate
relationships
between each
entity within the
diagram
Exemplary (90-
100%)
Thoroughly
created the
appropriate
relationships
between each
entity within the
diagram.
Describe any assumptions that you had to make
about the business rules in order to create the
diagram and the associated relationships. 10 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
described any
assumptions
that you had to
make about the
business rules in
order to create
the diagram and
the associated
relationships.
Needs
Improvement (60-
69%)
Insufficiently
described any
assumptions
that you had to
make about the
business rules in
order to create
the diagram and
the associated
relationships
Satisfactory (70-
79%)
Satisfactorily
described any
assumptions
that you had to
make about the
business rules in
order to create
the diagram and
the associated
relationships.
Competent (80-
89%)
Competently
described any
assumptions
that you had to
make about the
business rules in
order to create
the diagram and
the associated
relationships.
Exemplary (90-
100%)
Thoroughly
described any
assumptions
that you had to
make about the
business rules in
order to create
the diagram and
the associated
relationships.
Clarity, writing mechanics, and formatting
requirements. 10 %
Unacceptable
(Below 60%)
More than 8
errors present.
Needs
Improvement (60-
69%)
7–8 errors
present.
Satisfactory (70-
79%)
5–6 errors
present.
Competent (80-
89%)
3–4 errors
present.
Exemplary (90-
100%)
0–2 errors
present.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Week 10 Assignment - Create Tables and Queries in MS Access
Summary
Click the linked activity title to access this assignment.
Text
Overview
For this assignment, you will use MS Access to create tables and queries.
Instructions
Using an ERD to create tables in MS Access
Refer to the ERD that you created in the Week 8 assignment. Create an ERD, and perform
the following steps in MS Access:
Create the tables and relationships from the database design created in the Week 8
assignment.
Add at least five records into each table (Note: You must determine the field values).
Include the following screenshots in a Microsoft Word document to show the completion of the
steps above:
Screenshot depicting the tables created within MS Access.
Screenshots depicting the records added into each table. Include one student where the
student's last name is your name.
Query tables in MS Access
Perform the following steps in MS Access:
Create a query with all fields from the student table, where the student's last name is your
name.
Create a query that includes students’ first names, last names, and phone numbers.
Create a query that includes instructors' first names, last names, and courses they teach.
Include the following screenshots in a Microsoft Word document to show the completion of the
steps above:
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Screenshot depicting the tables created.
Screenshots depicting the records added into each table.
Screenshots depicting the query results from each of the queries created.
This course requires the use of Strayer Writing Standards. For assistance and information, please
refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your
professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Use MS Access to create tables and queries.
Scoring Guide
Create the tables and relationships from the
entities of the database and the attributes of
each entity, based on your research and/or
common knowledge of a college and the
information tracked by a college. 25 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
created the
tables and
relationships
from the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Needs
Improvement (60-
69%)
Insufficiently
created the
tables and
relationships
from the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Satisfactory (70-
79%)
Satisfactorily
created the
tables and
relationships
from the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Competent (80-
89%)
Competently
created the
tables and
relationships
from the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
Exemplary (90-
100%)
Thoroughly
created the
tables and
relationships
from the entities
of the database
and the
attributes of
each entity,
based on your
research and/or
common
knowledge of a
college and the
information
tracked by a
college.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Add at least five records into each table and
determine the field values. 25 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
added at least
five records into
each table and
determine the
field values.
Needs
Improvement (60-
69%)
Insufficiently
added at least
five records into
each table and
determine the
field values.
Satisfactory (70-
79%)
Satisfactorily
added at least
five records into
each table and
determine the
field values.
Competent (80-
89%)
Competently
added at least
five records into
each table and
determine the
field values.
Exemplary (90-
100%)
Thoroughly
added at least
five records into
each table and
determine the
field values.
Create a query with all fields from the student
table, where the student's last name is your
name. 15 %
Unacceptable
(Below 60%)
Did not submit or
incompletely
created a query
with all fields
from the student
table, where the
student's last
name is your
name.
Needs
Improvement (60-
69%)
Insufficiently
created a query
with all fields
from the student
table, where the
student's last
name is your
name.
Satisfactory (70-
79%)
Satisfactorily
created a query
with all fields
from the student
table, where the
student's last
name is your
name.
Competent (80-
89%)
Competently
created a query
with all fields
from the student
table, where the
student's last
name is your
name.
Exemplary (90-
100%)
Thoroughly
created a query
with all fields
from the student
table, where the
student's last
name is your
name.
Create a query that includes students’ first
names, last names, and phone numbers. 15 %
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
© 2021 Strategic Education, Inc.
Unacceptable
(Below 60%)
Did not submit or
incompletely
created a query
that includes
students’ first
names, last
names, and
phone numbers.
Needs
Improvement (60-
69%)
Insufficiently
created a query
that includes
students’ first
names, last
names, and
phone numbers.
Satisfactory (70-
79%)
Satisfactorily
created a query
that includes
students’ first
names, last
names, and
phone numbers.
Competent (80-
89%)
Competently
created a query
that includes
students’ first
names, last
names, and
phone numbers.
Exemplary (90-
100%)
Thoroughly
created a query
that includes
students’ first
names, last
names, and
phone numbers.
Create a query that includes instructors' first
names, last names, and courses they teach. 15
%
Unacceptable
(Below 60%)
Did not submit or
incompletely
created a query
that includes
instructors' first
names, last
names, and
courses they
teach.
Needs
Improvement (60-
69%)
Insufficiently
created a query
that includes
instructors' first
names, last
names, and
courses they
teach.
Satisfactory (70-
79%)
Satisfactorily
created a query
that includes
instructors' first
names, last
names, and
courses they
teach.
Competent (80-
89%)
Competently
created a query
that includes
instructors' first
names, last
names, and
courses they
teach.
Exemplary (90-
100%)
Thoroughly
created a query
that includes
instructors' first
names, last
names, and
courses they
teach.
Clarity, writing mechanics, and formatting
requirements. 5 %
Unacceptable
(Below 60%)
More than 8
errors present.
Needs
Improvement (60-
69%)
7–8 errors
present.
Satisfactory (70-
79%)
5–6 errors
present.
Competent (80-
89%)
3–4 errors
present.
Exemplary (90-
100%)
0–2 errors
present.
2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary
information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed
written permission of Strayer University.
Students also viewed