CIS 111 Innovative Education--snaptutorial.com

1
CIS 111 Innovative Education--snaptutorial.com
2
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 2 Assignment 1 Business Rules and
Data Models For more classes visit www.snaptutor
ial.com   Assignment 1 Business Rules and Data
Models  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.
3
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 3 Lab 1 Creating a Database Design
in Visio For more classes visit www.snaptutorial
.com   Lab 1 Creating a Database Design in
Visio This assignment contains two (2) Sections
Visio Diagram and Design Summary. You must submit
both sections as separate files in order to
complete this assignment. Use Appendix A
Designing Databases with Visio Professional A
Tutorial, located in the online course shell to
help you complete Section 1 Visio Database
Design. (Note This tutorial focuses on the use
of Microsoft Visio. Open source applications are
not covered in Appendix A however, the use of
open source applications within labs is
permitted.)
4
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 4 Lab 2 Modifying a Database Design
in Visio For more classes visit www.snaptutorial.
com   Lab 2 Modifying a Database Design in
Visio  This assignment contains two (2) Sections
Modified Visio Diagram and Design Summary. You
must submit both sections as separate files in
order to complete this assignment.  Use Appendix
A Designing Databases with Visio Professional A
Tutorial, located in the online course shell to
help you complete Section 1 Modified Visio
Database Design. (Note This tutorial focuses on
the use of Microsoft Visio. Open source
applications are not covered in Appendix A.
However, the use of open source applications
within labs is permitted.)  
5
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup
For more classes visit www.snaptutorial.com   Lab
3 Lab 3 EasyPHP and MySQL Setup   Install
EasyPHP and MySQL and take a screen shot that
shows the MySQL prompt on your screen. (Note You
must include the screen shot which shows that
MySQL is installed on your computer as part of
your assignment. An installation guide to aid the
installation of EasyPHP and MySQL is located in
the online course shell.) Research the
capabilities of MySQL. Write a one to two (1-2)
page paper in which you
6
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 6 Assignment 2 Normalization For
more classes visit www.snaptutorial.com   Assignme
nt 2 Normalization Suppose that you are the
database developer for a local college. The Chief
Information Officer (CIO) has asked you to
provide a summary of normalizing database tables
that the IT staff will use in the upcoming
training session. Write a two to three (2-3)
page paper in which you 1. Describe the steps
that you would use in order to convert database
tables to the First Normal Form, the Second
Normal Form, and the Third Normal Form.
7
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 7 Lab 4 Structured Query Language
(SQL) For more classes visit www.snaptutorial.co
m   Lab 4 Structured Query Language (SQL) Refer
to the database design crested in Lab 2
Modifying a Database Design in Visio to complete
this Lab. Perform the following steps in
MySQL Create the tables and relationships from
the database design discussed in Lab 2. Add at
least five (5) records into each table (Note You
must determine the field values).
8
CIS 111 Innovative Education--snaptutorial.com
CIS 111 Week 9 Assignment 3 Business Intelligence
and Data Warehouses For more classes
visit www.snaptutorial.com   Assignment 3
Business Intelligence and Data Warehouses
Businesses today are extremely reliant on large
amounts of data for making intelligent business
decisions. Likewise, the data warehouses are
often structured in a manner that optimizes
processing large amounts of data. Write a two to
three (2-3) page paper in which you 1. Outline
the main differences between the structure of a
relational database optimized for online
transactions versus a data warehouse optimized
for processing and summarizing large amounts of
data.
9
CIS 111 Innovative Education--snaptutorial.com