CIS 111 Education on your terms-tutorialrank.com

1
CIS 111 Education on your terms/tutorialrank.com
2
CIS 111Education on your terms/tutorialrank.com
CIS 111 Midterm Exam (6 Set) For more course
tutorials visit www.tutorialrank.com 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.
Question 5 ____ relates to the activities that
make the database perform more efficiently in
terms of storage and access speed.
3
CIS 111Education on your terms/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 111Education on your terms/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 111Education on your terms/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 111Education on your terms/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 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
7
CIS 111Education on your terms/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 111Education on your terms/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. Add at least five (5) records into each
table (Note You must determine the field
values). Create a query with all fields from the
student table, where the student's last name is
"Smith.
9
CIS 111Education on your terms/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
10
CIS 111Education on your terms/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
____. Question 3 To list all the contents of
the PRODUCT table, you would use ____.
Question 4 To delete a row from the PRODUCT
table, use the ____ command. Question 5 The
SQL character data format(s) is(are) ____.
Question 6 A table can be deleted from the
database by using the ____ command.
11
CIS 111Education on your terms/tutorialrank.com