CIS 111 course Marvelous Learning/tutorilarank.com

1
CIS 111 course Marvelous Learning/
tutorialrank.com
The Best way to predict the Future is to create
it.....To Best way....
www.tutorialrank.com
2
CIS 111course Marvelous Learning /
tutorialrank.com
CIS 111 Midterm Exam (6 Set) For more course
tutorials visit www.tutorialrank.com Set 1
Question 1____ provide(s) a description of the
data characteristics and the set of relationships
that link the data found within the database.
Question 2 A desktop database is a ____
database. Question 3 End-user data is ____.
Question 4 A ____ database supports data
distributed across several different sites.
3
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 2 Assignment 1 Business Rules and
Data Models (2 Papers) For more course tutorials
visit www.tutorialrank.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. Use the internet to
research the types of information that a college
would want to track in a database. Focus your
attention on information that could represent
entities within a database as well as attributes
of such entities.
4
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 3 Lab 1 Creating a Database Design
in Visio (2 Set) For more course tutorials
visit www.tutorialrank.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.)
5
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 4 Lab 2 Modifying a Database Design
in Visio (2 Set) For more course tutorials
visit www.tutorialrank.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.
6
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup For
more course tutorials visit www.tutorialrank.com
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
7
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 6 Assignment 2 Normalization (2
Papers) For more course tutorials
visit www.tutorialrank.com Assignment 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 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.
8
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 7 Lab 4 Structured Query Language
(SQL) (2 Papers) For more course tutorials
visit www.tutorialrank.com 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.
9
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 9 Assignment 3 Business Intelligence
and Data Warehouses (2 Papers) For more course
tutorials visit www.tutorialrank.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.
10
CIS 111 course Marvelous Learning /
tutorialrank.com
CIS 111 Week 11 Final Exam (4 Set) For more
course tutorials visit www.tutorialrank.com CIS
111 Week 11 Final Exam Question 1 Which
query will output the table contents when the
value of P_PRICE is less than or equal to 10?
Question 2 The SQL command that lets you select
attributes from rows in one or more tables is
____.
11
CIS 111 course Marvelous Learning /
tutorialrank.com
The Best way to predict the Future is to create
it.....To Best way....
www.tutorialrank.com