CIS 111 Course Great Wisdom / tutorialrank.com

1
CIS 111 Course Great Wisdom-tutorialrank.com
For More Tutorials
www.tutorialrank.com
2
CIS 111 Course Great Wisdom-tutorialrank.com

• CIS 111 Midterm Exam (6 Set)

• CIS 111 Week 2 Assignment 1 Business Rules and
  Data Models (2 Papers)

• Set
• 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

• 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 Course Great Wisdom-tutorialrank.com

• CIS 111 Week 3 Lab 1 Creating a Database Design
  in Visio (2 Set)

• CIS 111 Week 4 Lab 2 Modifying a Database Design
  in Visio (2 Set)

• 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.

• 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

4
CIS 111 Course Great Wisdom-tutorialrank.com

• CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup

• CIS 111 Week 6 Assignment 2 Normalization (2
  Papers)

• 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

• 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
  youDescribe the steps that you would use in
  order to convert

5
CIS 111 Course Great Wisdom-tutorialrank.com

• CIS 111 Week 7 Lab 4 Structured Query Language
  (SQL) (2 Papers)

• CIS 111 Week 9 Assignment 3 Business Intelligence
  and Data Warehouses (2 Papers)

• 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 MySQLCreate 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).

• 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.

6
CIS 111 Course Great Wisdom-tutorialrank.com

• CIS 111 Week 11 Final Exam (4 Set)

• CIS 111 Week 9 Assignment 3 Business Intelligence
  and Data Warehouses (2 Papers)

• 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
  ____.

• 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.

7
CIS 111 Course Great Wisdom-tutorialrank.com
For More Tutorials
www.tutorialrank.com