CIS 111 Slingshot Academy / snaptutorial.com

1
CIS 111 Slingshot Academy / snaptutorial.com
Fore more Courses
www.snaptutorial.com
2
CIS 111 Slingshot Academy / snaptutorial.com
CIS 111 Week 2 Assignment 1 Business Rules and
Data Models (2 Papers)
CIS 111 Midterm Exam (6 Set)

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

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

3
CIS 111 Slingshot Academy / snaptutorial.com
CIS 111 Week 4 Lab 2 Modifying a Database Design
in Visio
CIS 111 Week 3 Lab 1 Creating a Database Design
in Visio (2 Set)

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

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

4
CIS 111 Slingshot Academy / snaptutorial.com
CIS 111 Week 6 Assignment 2 Normalization (2
Papers)
CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup
Lab 3 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.)

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

5
CIS 111 Slingshot Academy / snaptutorial.com
CIS 111 Week 9 Assignment 3 Business Intelligence
and Data Warehouses (2 Papers)
CIS 111 Week 7 Lab 4 Structured Query Language
(SQL) (2 Papers)

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

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

6
CIS 111 Slingshot Academy / snaptutorial.com
CIS 111 Week 11 Final Exam (4 Set)

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

7
CIS 111 Slingshot Academy / snaptutorial.com
Fore more Courses
www.snaptutorial.com