CIS 336 education changes / sellfy.com

1
CIS 366 Experience Tradition/sellfy.com
2
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Final Exam 1
• https//sellfy.com/p/LEC2/
•  
•  
•  
•  
•  
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)elementallinkedhierarchicalrelational

3
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Final Exam 2
• https//sellfy.com/p/A5ar/
•  
•  
•  
•  
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)elementallinkedhierarchicalrelational

4
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Final Exam 3
• https//sellfy.com/p/NPJ7/
•  
•  
•  
•  
•  
•  
•  
• 1. (TCO 2) Explain what physical independence
  means. (Points 15)2. (TCO 8) Sally wants to
  query the EMP table and determine how many of the
  employees live in each of the cities the company
  has factories in. She writes the following query
  but it does not work. What is wrong with the way
  the query is constructed?

5
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Final Exam 4 Sets of Answers
• https//sellfy.com/p/SbeR/
•  
•  
•  
•  
•  
• CIS 336 Final Exam 4 Sets of Answers
•  

6
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Final Exam 4
• https//sellfy.com/p/oZqX/
•  
•  
•  
•  
•  
•  
• 1. (TCO 7) For every order, list the order
  number, order date, part number, part
  description, and item class for each part that
  makes up the order.2. (TCO 8) Write a query
  that will display the customer number, last name,
  and first name for every customer I whose first
  name begins with the letter "D".

7
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Final Exam (April,2019)
• https//sellfy.com/p/iTJr/
•  
•  
•  
•  
•  
•  
• CIS 336 Final Exam Question 1. 1. (TCO 1) A
  DBMS performs several important functions that
  guarantee the integrity and consistency of the
  data in the database. Which of the following is
  NOT one of those functions? 

8
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Group Project
• https//sellfy.com/p/Y2sD/
•  
•  
•  
•  
• This project is designed to touch all aspects of
  the fundamental concepts of database design and
  logical data modeling covered during the class.
  Each student will be responsible for designing,
  developing, and demonstrating the functionality
  of a database created based on a set of business
  specifications that you create. At the end of the
  session, each student will submit a report that
  includes the logical and physical design of the
  database and demonstrates the database's ability
  to deliver meaningful reports. All aspects of the
  project will be covered during the week or weeks
  prior to a deliverable, and each task deliverable
  in the project will be supported through the
  exercises and labs done in the course.

9
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab 1 Normal Forms and Entity
  Relationship Diagrams
• https//sellfy.com/p/d40g/
•  
•  
•  
• CIS336 Lab 1 Normal Forms and Entity
  Relationship DiagramsIntroductionIn this
  exercise, you will analyze a de-normalized data
  set presented in the form of a spreadsheet.

10
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab 2 The Expanded Entity Relationship
  Diagram
• https//sellfy.com/p/xSUC/
•  
•  
•  
•  
• CIS336 Lab 2 The Expanded Entity Relationship
  DiagramLAB OVERVIEWScenario and SummaryThis
  lab introduces the next step in creating a data
  model, the Entity Relationship Diagram (ERD). You
  will be given a business scenario for a
  University Medical Center, which is a small
  community hospital.

11
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab 3 Building the Physical
•  https//sellfy.com/p/L1y8/
•  
•  
• CIS-336 Lab 3 Building the PhysicalLAB
  OVERVIEWScenario and SummaryThe lab for this
  week addresses taking a logical database design
  (data model) and transforming it into aphysical
  model (tables, constraints, and relationships).

12
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab 4 Introduction to Select, Insert,
  Update, and Delete Statements (only SQL Command,
  No o
• https//sellfy.com/p/wfHA/
•  
•  
• CIS336 Lab 4 Introduction to Select, Insert,
  Update, and Delete StatementsLAB OVERVIEWLab 4
  will introduce the various aspects of the SQL
  select statement and the methods of retrieving
  data from the database tables. This lab will also
  introduce the fundamentals of updating and
  deleting records.

13
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab 5 Joining Tables
• https//sellfy.com/p/dwAg/
•  
•  
• 336 Lab5 Joining TablesLAB OVERVIEWScenario
  and SummaryLab 5 will introduce the concept of
  multi-table JOINS in order to work with data in
  two or more related tables simultaneously. This
  lab may be completed using either DeVrysOmnymbus
  EDUPE-APP lab environment, or a local copy of the
  MySQL database running on your own computer using
  the OM database tables.

14
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab 6 Group Functions and Subqueries
• https//sellfy.com/p/KHiN/
•  
•  
•  
• CIS336 Lab 6 Group Functions and
  SubqueriesLAB OVERVIEWScenario and SummaryLab
  6 will introduce the concept of group functions
  and subqueries to meet more complex report
  requirements. This lab may be completed using
  either DeVrysOmnymbus EDUPE-APP lab environment,
  or a local copy of the MySQL database running on
  your own computer using the OM database tables.

15
CIS 366 Experience Tradition/sellfy.com

• CIS 336 iLab7 Working with Views
• https//sellfy.com/p/7vy7/
•  
•  
•  
• CIS-336 Lab7 Working with ViewsLAB
  OVERVIEWLab 7 will introduce the concept of
  database views. This lab may be completed using
  either DeVrysOmnymbus EDUPE-APP lab environment,
  or a local copy of the MySQL database running on
  your own computer using the OM database tables.

16
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Quiz 2
• https//sellfy.com/p/dHEb/
•  
•   
• (TCO 2) Explain what a composite attribute
  is(TCO 1) Data constitutes the building blocks
  of(TCO 1) Successful database design is first
  and foremost based on _____________
  requirements.(TCO 1) The lowest level in a
  database hierarchy is the ____________ or value
  as it is often referred(TCO 2) The term
  _____________ design is used to refer to the task
  of creating the conceptual data model represented
  by an Entity Relationship Diagram (ERD).

17
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Quiz 4
• https//sellfy.com/p/pI7J/
•  
•  
•  
• (TCO 8) If a Cartesian join is used to link table
  A which contains five rows to table B which
  contains eight rows, there will be _______ rows
  in the results.(TCO 8) Which of the following
  statements will produce the value 21.1?

18
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Quiz 5
• https//sellfy.com/p/FDTP/
•  
•   
• (TCO 6) Which of the following keywords is used
  to remove a row in a table?(TCO 6) When using
  the ALTER TABLE...DROP COLUMN command, which of
  the following is NOT correct?(TCO 6) Which of
  the following commands will add a new column
  named FIRSTORDERDATE to the CUSTOMERS table to
  store the date that the customer first placed an
  order with the company?

19
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Week 2 Quiz (New)
• https//sellfy.com/p/56up/
•   
•  
• CIS 336 Week 2 Quiz                        Ques
  tion 1.                  (TCO 1) Raw facts, such
  as a telephone number, a birth date, and a
  customer name, are also referred to as _____ 

20
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Week 3 Quiz (New)
• https//sellfy.com/p/82n0/
•  
•  
•  
• CIS 336 Week 3 Quiz Question 1.                 
  (TCO 3) When designing a database, you should
  _____ Question 2.                  (TCO 3) A
  table that is in 1NF and includes no partial
  dependencies only is said to be in _____

21
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Week 4 Quiz (New)
• https//sellfy.com/p/GOHE/
•  
•  
•  CIS 336 Week 4 Quiz Question
  1.                  (TCO 7) Which of the
  following types of columns will automatically
  right-align the data when it is
  displayed?Question 2.                  (TCO 7)
  Which of the following symbols can be used to
  denote that any and all characters following the
  sign are eligible when used with LIKE?

22
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Week 5 Quiz (New)
• https//sellfy.com/p/FsU1/
•  
•  
•  
• CIS 336 Week 5 Quiz Question
  1.                  (TCO 8) The ____ set operator
  in SQL combines rows from two queries and returns
  only the values that are common between the two
  sets. Question 2.                  (TCO 8)
  Which SQL function converts a value to a
  particular string format?  

23
CIS 366 Experience Tradition/sellfy.com

• CIS 336 Week 6 Quiz (New)
• https//sellfy.com/p/opuD/
•  
•   
•  
• CIS 336 Week 6 QuizQuestion 1.                 
  (TCO 6) Which of the following keywords can be
  used to change the size, datatype, or default
  value of an existing column?Question
  2.                  (TCO 9) If the _____ clause
  of the UPDATE command is omitted, then all the
  rows in the specified table will be changed.

24
CIS 366 Experience Tradition/sellfy.com