CIS 111 Teaching Effectively--tutorialrank.com

1
CIS 111 Teaching Effectively--tutorialrank.com
2
CIS 111 Teaching Effectively--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 Teaching Effectively--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 informat
4
CIS 111 Teaching Effectively--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 Teaching Effectively--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. 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.
6
CIS 111 Teaching Effectively--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.
7
CIS 111 Teaching Effectively--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. Provide one (1)
example that is relevant to a college environment
that illustrates reasons for converting database
tables to the First, Second, and Third Normal
Forms.
8
CIS 111 Teaching Effectively--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).
9
CIS 111 Teaching Effectively--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
10
CIS 111 Teaching Effectively--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 ____ comma
11
CIS 111 Teaching Effectively--tutorialrank.com