CIS 111 Your Dreams Our Mission/uophelp.com

1
CIS 111 Your Dreams Our Mission/uophelp.com

• For more course tutorials visit
• www.uophelp.com

2
CIS 111 Your Dreams Our Mission/uophelp.com

• CIS 111 Midterm Exam (6 Set)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 6 Set of Midterm Exam
  (Approximately 240 MCQ)
• 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.
• Question 5 ____ relates to the activities that
  make the database perform more efficiently in
  terms of storage and access speed.

3
CIS 111 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 2 Assignment 1 Business Rules and
  Data Models (2 Papers)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 2 Papers
•  
•  
• 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.

4
CIS 111 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 3 Lab 1 Creating a Database Design
  in Visio (2 Set)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 2 Set of Solution/Paper
  for this lab
•  
•  
• 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.

5
CIS 111 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 4 Lab 2 Modifying a Database Design
  in Visio (2 Set)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 2 Set of Solution/Paper
  for this lab
•  
• 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 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup
• For more course tutorials visit
• www.uophelp.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 111 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 6 Assignment 2 Normalization (2
  Papers)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 2 Papers
•  
• 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 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 7 Lab 4 Structured Query Language
  (SQL) (2 Papers)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 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 MySQL
• Create the tables and relationships from the
  database design discussed in Lab 2.

9
CIS 111 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 9 Assignment 3 Business Intelligence
  and Data Warehouses (2 Papers)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 2 Papers
•  
• 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 Your Dreams Our Mission/uophelp.com

• CIS 111 Week 11 Final Exam (4 Set)
• For more course tutorials visit
• www.uophelp.com
• This Tutorial contains 4 Set of Final Exam
  (Approximately 200 MCQ)
• 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) ____.

11
CIS 111 Your Dreams Our Mission/uophelp.com

• For more course tutorials visit
• www.uophelp.com