CIS 336 DeVry Entire Course

admin   June 29, 2017   Comments Off on CIS 336 DeVry Entire Course

CIS 336 DeVry Entire Course

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-entire-course/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry Entire Course

CIS336

CIS 336 DeVry Week 1 Discussion 1

Normal Forms and Entity Relationship Diagrams (graded)

We hear the term database all the time. Give some examples of databases that you interact with on a regular basis. What makes a database relational? What is a file storage system? How does a relational database differ from a file storage system?

 

CIS 336 DeVry Week 1 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 2 Discussion 1

Developing a Good Data Model (graded)

The database data model is the communication link between the designer, applications programmer, and user. Contribute your views on what constitutes a good data model and why.

 

CIS 336 DeVry Week 2 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 3 Discussion 1

Building the Physical Model (graded)

What is the importance of constraints in a physical model? What role do different constraints play in maintaining referential integrity and data integrity?

 

CIS 336 DeVry Week 3 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 4 Discussion 1

Understanding the SELECT statement (graded)

Reports are generated using queries to a database. The SELECT statement is used to retrieve data from one or many tables in a database. Just as in other programming languages, understanding the syntax of a select statement is key. Let’s first discuss the key clauses in a SELECT statement and the purpose of each.

 

CIS 336 DeVry Week 4 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 5 Discussion 1

Getting Data From Multiple Tables (graded)

It is not uncommon to have to retrieve data that resides in several tables, especially when formulating a report. Discuss some of the performance issues when querying three or four tables at a time.

 

CIS 336 DeVry Week 5 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 6 Discussion 1

How Group Functions Differ From Single-Row Functions (graded)

What are some examples of group functions, and how do they differ from single-row functions?

 

CIS 336 DeVry Week 6 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 7 Discussion 1

Database Views (graded)

What are the advantages of selecting data from a view over selecting data from a base table?

 

CIS 336 DeVry Week 7 Discussion 2

Lab Forum (graded)

This area is used to discuss the lab assignments and techniques. Please post any questions you have about the labs or tips that you have discovered during your learning process. At a minimum, post at least three notes that highlight your experience or problems with this week’s lab.

 

CIS 336 DeVry Week 1 iLab Latest

.equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336_W1_iLab.html”>iLab> Required Software

Lab 1 of 7: Normal Forms and Entity Relationship Diagrams

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using Read Speaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Download the iLab instructions and the Answer Sheet for the necessary steps to be completed for this lab. They can be found below. You will notice that the readings, including lectures, the examples we worked on during the lecture, and other audio and visual aids provided, will help you tackle this week’s lab. Remember to always follow the instructions to get maximum credit, and use the weekly discussion related to the iLab and the Q & A Forum for additional help. Be specific and state the problem you are having clearly, including what you have done to resolve it, in the discussion.

Microsoft Visio Tutorial—Important Information

Important: Before starting, be sure to review the Logical Modeling Part 1video under Video Library to familiarize you with how to use MS Visio to draw Entity Relationship Diagrams.

Deliverables

NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab is a single MS Word document named lab1_solutions_yourname.docx with the answers included for Steps 1–4.

Required Software

Microsoft Office: Word and Visio 2010

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu.

Lab Steps

STEP 1: Download the Week 1 Lab Instructions

Follow the instructions to complete the lab by downloading the following files: · .equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336Lab1_Instructions.docx”>CIS336Lab1_Instructions.docx ·

.equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336Lab1_StudentAnswerSheet.docx”>CIS336Lab1_StudentAnswerSheet.docx

STEP 2: Submit Your Answers on the Lab 1 Student Answer Sheet

Use Visio or Word to draw the dependency diagrams for Steps 1–3. Use Visio to draw the ERD for Step 4. This is the end of iLab #1

 

CIS 336 DeVry Week 2 iLab Latest

.equella.ecollege.com/file/ace06cf1-3107-42f4-9c63-b71dc0625d56/15/CIS336_W2_iLab.html”>iLab> Lab Steps

Lab 2 of 7: The Expanded Entity Relationship Diagram

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Download the iLab instructions and the Answer Sheet for the necessary steps to be completed for this lab. They can be found below. You will notice that the readings, including lectures, the examples we worked on during the lecture, and other audio and visual aids provided, will help you tackle this week’s lab. Remember to always follow the instructions to get maximum credit, and use the weekly discussion related to the iLab and the Q & A Forum for additional help. Be specific and state the problem you are having clearly, including what you have done to resolve it, in the discussion.

Deliverables

NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will be your completed ERD as a single MS Word document using copy/paste from the MS Visio application and namedlab2_solutions_yourname.docx

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

Lab Steps

STEP 1: Download the Week 2 Lab Instructions.

Follow the instructions to complete the lab by downloading the following files: ·.equella.ecollege.com/file/ace06cf1-3107-42f4-9c63-b71dc0625d56/15/CIS336Lab2_Instructions.docx”>CIS336Lab2_Instructions.docx

STEP 2: Submit Your Answers

Use Visio to create your ERD. Copy and paste to a Word document as indicated in the lab instructions. This is the end of lab #2

 

CIS 336 DeVry Week 3 iLab Latest

.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336_W3_iLab.html”>iLab> Lab Steps

Lab 3 of 7: Building the Physical Model

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in the MySQL EDUPE Environment. By now you have received your logon ID and password and should have at least made sure you can connect. If for any reason you have not done so, please do so now before continuing any further. If for any reason you cannot connect, then you need to let the instructor know ASAP so that any problems can be resolved.

In this lab you will transform a logical database design (data model) into a physical model (tables, constraints, and relationships). Your job will be to take the relationship diagram along with the meta data defined in the data dictionary and define the table structures and constraints to create the physical tables. Once this has been done, you will populate the tables with data. Lastly, you will write SELECT statements to query the tables and verify the data was populated.

Deliverables

NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

  1. Your script file. Create this file in Notepad, not Word. Make sure your name is in a comment area at the top of the script file. Use a double dash to create a one-line comment.

—Jacob Smith

—Lab 3

Required Software

MySQL

Access the software at.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

STEP 1: Download the Week 3 Lab Instructions

Complete the lab by downloading the following files this week: ·

.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336Lab3_Instructions.docx”>CIS336Lab3_Instructions.docx

.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336Lab3_Files.zip”>CIS336Lab3_Files.zip

STEP 2: Submit Your SQL Command File

Use Notepad to write the SQL statements and submit according the lab instructions.

This is the end of Lab #3

 

 

CIS 336 DeVry Week 4 iLab Latest

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336_W4_iLab.html”>iLab> STEP 2: Download the Week 4 Lab Instructions and Answer Sheet

Lab 4 of 7: Building the Physical Model

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Lab 4 will introduce the various aspects of the SQL SELECT statement and the methods of retrieving data from the database tables. The lab will utilize a database with a set of tables that you will create and populate using the instructions and script file found below. These tables will be used for the remaining labs in this class.

Deliverables

NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these

.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will include the following.

The Student Answer Sheet file below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 4.

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

MySQL Access the software at

.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

STEP 1: Create the Database and Tables

Create the database and tables (that will be used in labs 4–7) by downloading the following files.

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CreateOMTables.docx”>CreateOMTables.docx(Instructions)

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql”>create_OM_db.sql(Database Script)

STEP 2: Download the Week 4 Lab Instructions and Answer Sheet

Follow the instructions to complete the lab by downloading the following files.

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336Lab4_Instructions.docx”>CIS336Lab4_Instructions.docx

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336Lab4_StudentAnswerSheet.docx”>CIS336Lab4_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docxwhen creating your queries.

STEP 3: Submit Your Answer sheet

Complete the Answer Sheet to show your queries and results and submit according to the lab instructions.

This is the end of Lab#4.

 

 

CIS 336 DeVry Week 5 iLab Latest

.equella.ecollege.com/file/67acd265-3032-4b50-850b-b98f6d50c25b/24/CIS336_W5_iLab.html”>iLab> STEP 1: Download the Week 5 Lab Instructions and Answer Sheet

Lab 5 of 7: Retrieving Data From Multiple Tables (39 points)

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Lab 5 deals with writing queries using multiple tables as covered in the reading and lecture material this week. In some cases, you will be given the option to choose the JOIN syntax to use, in other cases, you will be asked to take a specific approach. Using the incorrect process when the process is specified will result in points being taken off for that problem.

Deliverables

NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will include:

The Student Answer Sheet file that you will download below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 5.

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

MySQL

Access the software at.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

PRELIMINARY STEP: If You Have Not Created the Database Yet, Please Complete.

This lab will utilize the tables that were created in Lab 4. If you have not yet created these tables,you can create the database and tables (used in labs 4–7) by downloading the following files.

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/CIS336_CreateOMTables.docx”>CreateOMTables.docx(Instructions)

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql”>create_OM_db.sql(Database Script)

STEP 1: Download the Week 5 Lab Instructions and Answer Sheet

Follow the instructions to complete the lab by downloading the following files.

.equella.ecollege.com/file/67acd265-3032-4b50-850b-b98f6d50c25b/24/CIS336Lab5_Instructions.docx”>CIS336Lab5_Instructions.docx

.equella.ecollege.com/file/67acd265-3032-4b50-850b-b98f6d50c25b/24/CIS336Lab5_StudentAnswerSheet.docx”>CIS336Lab5_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docxwhen creating your queries.

STEP 2: Submit Your Answer sheet

Complete the Answer Sheet to show your queries and results and submit according to the lab instructions.

This is the end of Lab #5.

 

 

 

CIS 336 DeVry Week 6 iLab Latest

.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336_W6_iLab.html”>iLab> STEP 1: Download the Week 6 Lab Instructions and Answer Sheet

Lab 6 of 7: Group Functions and Sub queries

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Lab 6 will introduce group or aggregate functions and sub queries. Make sure to follow the instructions provided by each step.

Deliverables

NOTE Submit your assignment to the Dropbox, located at the top of this page. For instructions on how to use the Dropbox, read these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will include the following.

The Student Answer Sheet file that you will download below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 5.

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

MySQL

Access the software at.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

PRELIMINARY STEP: If You Have Not Created the Database Yet, Please Complete.

This lab will utilize the tables that were created in Lab 4. If you have not yet created these tables, you can create the database and tables (used in labs 4–7) by downloading the following files. ·

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/CIS336_CreateOMTables.docx”>CreateOMTables.docx (Instructions) ·

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql”>create_OM_db.sql (Database Script)

STEP 1: Download the Week 6 Lab Instructions and Answer Sheet

Follow the instructions to complete the lab by downloading the following files. ·

.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336Lab6_Instructions.docx”>CIS336Lab6_Instructions.docx ·

.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336Lab6_StudentAnswerSheet.docx”>CIS336Lab6_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docx when creating your queries.

STEP 2: Submit Your Answer Sheet

Complete the answer sheet to show your queries and results, and submit according to the lab instructions.

This is the end of Lab #6

 

 

CIS 336 DeVry Week 2 Quiz Latest

Question 1. Question : (TCO 2) Which statement is FALSE regarding a primary key?

  • Only parent tables must have a primary key.
  • The values must be unique.
  • It can be made up of multiple attributes.
  • The value cannot be NULL.

Question 2. Question : (TCO 2) _____ integrity insures that the value of a foreign key must match a primary key value in the table to which it is related, or be null.

  • Referential
  • Entity
  • Data
  • Logical

Question 3. Question : (TCO 2) A verb associating two nouns in a business rule usually translates to a(n) ____ in the data model.

  • entity
  • attribute
  • relationship
  • constraint

Question 4. Question : (TCO 4) A(n) _____ provides a graphical description of a data model.

  • entity relationship diagram
  • data dictionary
  • business rule
  • pseudocode

Question 5. Question : (TCO 2) A _____ primary key is made up of more than one attribute.

  • composite
  • foreign
  • bridge
  • linking

Question 6. Question : (TCO 4) In the figure below, the OrderLineItems entity is there to implement what type of relationship between Orders and Products?

  • One to one
  • One to many
  • Many to many
  • No relationship

Question 7. Question : (TCO 2) When designing a database, you should _____.

  • make sure entities are in normal form before table structures are created
  • create table structures then normalize the database
  • only normalize the database when performance problems occur
  • consider more important issues, such as performance, before normalizing

Question 8. Question : (TCO 2) A table that is in 1NF and includes no partial dependencies only is said to be in _____.

  • 1NF
  • 2NF
  • 3NF
  • BCNF

Question 9. Question : (TCO 2) A table is not in 1NF if _____.

  • it has a primary key defined
  • all of the key attributes are defined
  • there are repeating groups in the table
  • all attributes are dependent on the primary key

Question 10. Question : (TCO 2) Entity attributes and primary keys are not present in the _____ data model.

  • logical
  • physical
  • conceptual
  • network

 

 

CIS 336 DeVry Week 3 Quiz Latest

  1. Question : (TCO 3)The _____ column attribute will automatically generate unique numbers in sequence.
  • DEFAULT
  • AUTO_INCREMENT
  • AUTO_SEQUENCE
  • NOT NULL

Question 2. Question : (TCO 5) The _____ keyword is used in an ALTER statement to remove a column from an existing table.

  • MODIFY COLUMN
  • ADD COLUMN
  • DELETE COLUMN
  • DROP COLUMN

Question 3. Question : (TCO 3) Which uses the least amount of storage?

  • “Example” stored in a column of type CHAR(20)
  • “Exam” stored in a column of type CHAR(20)
  • “Ex” stored in a column of type CHAR(20)
  • They all use the same amount of storage.

Question 4. Question : (TCO 3) The TIME data type in MySQL can store _____.

  • dates only
  • times only
  • dates and times
  • None of the above

Question 5. Question : (TCO 3) Which statement is false regarding the creation of a foreign key constraint at table level or with an ALTER statement?

  • The parent table must already exist.
  • The field must already be defined in the table.
  • The PK and FK fields must have the same name.
  • The PK and FK fields may have different names.

Question 6. Question : (TCO 3) A foreign key constraint can only reference a column in another table that has been assigned a(n) _____ constraint.

  • NOT NULL
  • UNIQUE
  • PRIMARY KEY
  • DEFAULT

Question 7. Question : (TCO 3) You are creating a table called Department, with fields for the primary key DeptID (Integer) and department name (VARCHAR). What (if anything) is wrong with the following code?

CREATE TABLE Department ( deptID Primary Key INTEGER , deptName NOT NULL VARCHAR(10) );

  • You must use curly braces, not parentheses.
  • The data type must immediately follow the field name.
  • The keywords cannot be in upper case.
  • Nothing is wrong.

Question 8. Question : (TCO 3) What datatype is best to store a person’s age?

  • INTEGER
  • VARCHAR
  • DECIMAL
  • FLOAT

Question 9. Question : (TCO 5) Which statement will remove the field STATUS from the CUSTOMERS table?

  • ALTER TABLE customers REMOVE status;
  • ALTER TABLE customers DROP status;
  • ALTER TABLE customers DROP COLUMN status;
  • ALTER TABLE customers DELETE status;

Question 10. Question : (TCO 8) When you write an INSERT statement with a column list, which columns can be omitted from the column list?

  • AUTO_INCREMENT only
  • DEFAULT only
  • NOT NULL only
  • AUTO_INCREMENT, DEFAULT, and fields that allow NULL

 

 

CIS 336 DeVry Week 4 Quiz Latest

Question 1. Question : (TCO 6) To retrieve all fields from a table, use

  • SELECT ALL.
  • SELECT ANY.
  • SELECT ().
  • SELECT *.

Question 2. Question : (TCO 6) Which operator would be most appropriate to determine books with a retail price in the range of $50 to $100?

  • LIKE
  • IN
  • BETWEEN
  • >

Question 3. Question : (TCO 6) Which code returns the date field HIREDATE in the format: Friday, April 5th, 2015?

  • DATE_FORMAT(HIREDATE, ‘%W, %m %d, %Y’)
  • DATE_FORMAT(HIREDATE, ‘%a, %M %D, %Y’)
  • DATE_FORMAT(HIREDATE, ‘%W, %M %D, %Y’)
  • DATE_FORMAT(HIREDATE, ‘%a, %m %d, %y’)

Question 4. Question : (TCO 6) Given a customer table with fields for firstname and lastname, which of the following will display the customer name as a single field in the format “Jones, Tom” with a heading?

  • SELECT CONCAT(lastname, firstname) as “Name” FROM customer;
  • SELECT CONCAT(firstname, lastname) as “Name” FROM customer;
  • SELECT CONCAT(lastname, ‘, ‘, firstname) as “Name” FROM customer;
  • SELECT CONCAT lastname ‘, ‘ firstname as “Name” FROM customer;

Question 5. Question : (TCO 8) The column to be updated by the UPDATE command is specified in the _____ clause.

  • WHERE
  • MODIFY
  • ALTER
  • SET

Question 6. Question : (TCO 6) Given a table orders with fields for orderid, orderdate, and shipdate, which query will display the ordered for only those orders that have not shipped?

  • SELECT orderid FROM orders WHERE shipdate = orderdate;
  • SELECT orderid FROM orders WHERE shipdate IS NOT NULL;
  • SELECT orderid FROM orders WHERE shipdate IS NULL;
  • SELECT orderid FROM orders;

Question 7. Question : (TCO 6) Which WHERE clause will return data on all employees with a last name beginning with ‘S’?

  • WHERE lastname = ‘S’
  • WHERE lastname = ‘S%’
  • WHERE lastname LIKE ‘S’
  • WHERE lastname LIKE ‘S%’

Question 8. Question : (TCO 6) Given a books table with fields of title, cost, and retail, what if anything is wrong with the following query (assuming all fields exist)?

SELECT * FROM books WHERE cost > 20 ORDER BY retail;

  • You must sort and filter on the same field.
  • You cannot use ORDER BY and WHERE in the same query.
  • The WHERE clause must always be last.
  • Nothing is wrong.

Question 9. Question : (TCO 8) You can delete one or more rows in a table by using the _____ command.

  • UPDATE
  • DROP
  • DELETE
  • ALTER

Question 10. Question : (TCO 6) Given a books table with fields: title, category (such as ‘SPORTS’), cost, retail; what condition will return ‘COMPUTER’ books with a retail price between $50 and $100 ?

  • WHERE retail > 50 AND < 100 AND category = ‘COMPUTER’
  • WHERE category = ‘COMPUTER’ AND (retail BETWEEN 100 and 50)
  • WHERE category = ‘COMPUTER’ AND retail < 50 AND retail > 100
  • WHERE category = ‘COMPUTER’ AND ( retail BETWEEN 50 AND 100)

 

 

CIS 336 DeVry Week 5 Quiz Latest

  1. Question : (TCO 7)The implicit inner join syntax is defined as _____.
  • NATURAL JOIN
  • JOIN ON
  • JOIN USING
  • WHERE clause

Question 2. Question : (TCO 7) To join four tables would require _____ join conditions.

  • 4
  • 3
  • 2
  • Cannot tell without an ERD.

Question 3. Question : (TCO 7) Given the two tables described below, which of the following JOIN queries (if any) is not correct?

customer: with the fields customerid(PK), lastname, firstname

order: with the fields orderid(PK), orderdate, customerid(FK)

  • SELECT lastname, orderdate from customer JOIN order ON customer.customerid = order.customerid;
  • SELECT lastname, orderdate from customer JOIN order USING (customerid);
  • SELECT lastname, orderdate from customer, orders;
  • All of the above

Question 4. Question : (TCO 7) In a join, column names need to be qualified only

  • in inner joins.
  • in outer joins.
  • when the code is confusing.
  • when the same column names exist in both tables.

Question 5. Question : (TCO 7) A left join returns

  • rows in the left table that don’t satisfy the join condition.
  • unmatched rows from both the left and right tables.
  • rows in the right table that don’t satisfy the join condition.
  • the Cartesian product of the two tables.

Question 6. Question : (TCO 7) When you use the USING keyword for a join

  • the join cannot be an outer join.
  • the join cannot be based on more than one column.
  • the join must be based on a column or columns that have the same name in both tables.
  • the join must be an inner join.

Question 7. Question : (TCO 7) Consider the ERD below. How many tables would be required to create a query to display the customer first and last name along with orderdate of each order they placed?

  • One
  • Two
  • Three
  • Four

Question 8. Question : (TCO 7) Consider the ERD below. What tables will be needed to create a report showing the firstname and lastname of customers who have placed an order for any product with keyboard in the description?

  • customer, product only
  • customer, order, product only
  • customer, orderline only
  • customer, order, orderline, product

Question 9. Question : (TCO 7) Consider the ERD below. What tables will be needed to create a report showing customer first and last name along with order date? The report should show all customers even if they have never placed an order.

  • SELECT firstname, lastname, orderdate from customer LEFT JOIN order;
  • SELECT firstname, lastname, orderdate FROM customer RIGHT JOIN order ON customer.customerid = order.customerid;
  • SELECT firstname, lastname, orderdate FROM customer JOIN order USING (customerID);
  • SELECT firstname, lastname, orderdate FROM customer LEFT JOIN order ON customer.customerid = order.customerid;

Question 10. Question : (TCO 7) Consider the ERD below. Note that there are some products produced in-house that do not require a vendor, thus their vendorID is NULL. Also note that not all vendors currently supply products. Which query would be used to generate a report showing vendorname and productname, and will include ALL vendors even if they do not currently supply any products?

  • SELECT vendorname, productname FROM vendor LEFT JOIN product;
  • SELECT vendorname, productname FROM vendor RIGHT JOIN product;
  • SELECT vendorname, productname FROM vendor LEFT JOIN product ON vendor.vendorID = product.vendorID;
  • SELECT vendorname, productname FROM vendor RIGHT JOIN product ON vendor.vendorID = product.vendorID;

 

 

CIS 336 DeVry Week 6 Quiz Latest

  1. Question : (TCO 7)Which is NOT an aggregate function?
  • SUM
  • COUNT
  • ROUND
  • MAX

Question 2. Question : (TCO 7) Which of the following statements is correct?

  • WHERE operates on groups formed by aggregate functions and HAVING operates on individual rows.
  • WHERE can only be used along with HAVING.
  • HAVING can only be used along with WHERE.
  • WHERE operates on individual rows and HAVING operates on groups formed by aggregate functions.

Question 3. Question : (TCO 7) Given the books table described below, which of the following will display the date of the book with the earliest publication date?

books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

  • SELECT MIN(pubdate) FROM books;
  • SELECT title FROM books WHERE pubdate = MIN(pubdate);
  • SELECT title FROM books WHERE pubdate < MIN(pubdate);
  • SELECT pubdate from books WHERE MIN(pubdate) IS NOT NULL;

Question 4. Question : (TCO 7) Given the books table described below, which of the following will display the title and retail price of books that are priced higher than the average retail price of all books?

books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

  • SELECT title, retail FROm books WHERE retail IN (SELECT AVG(retail) FROM books);
  • SELECT title, retail FROM books WHERE retail > (SELECT AVG(retail) FROM books);
  • SELECT title, retail FROM books WHERE retail > AVG(retail);
  • SELECT title, AVG(retail) FROM books;

Question 5. Question : (TCO 7) Which of the values listed below can be returned by a subquery referenced as follows?

WHERE vendorid = (subquery)

  • A single value
  • A column of one or more rows
  • A table
  • A subquery can’t be used in this way.

Question 6. Question : (TCO 7) What type of subquery is executed once for each row processed by the main query?

  • Correlated
  • Uncorrelated
  • Inner
  • Outer

Question 7. Question : (TCO 7) Given the two tables described below, which of the following queries will display the names of the customers with orders shipped after December 1, 2014?

customer: with the fields customerid(PK), lastname, firstname

order: with the fields orderid(PK), orderdate, shipdate, customerid(FK)

  • SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate > ‘2014-01-12’);
  • SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate < ‘2014-01-12’);
  • SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate > ‘2014-12-01’);
  • SELECT lastname, firstname FROM customer WHERE customerid = (SELECT customerID FROM order WHERE shipdate < ‘2014-12-01’);

Question 8. Question : (TCO 7) Given the two tables described below, which of the following queries will display each customerid along with the number of orders placed by that customer?

customer: with the fields customerid(PK), lastname, firstname

order: with the fields orderid(PK), orderdate, shipdate, customerid(FK)

  • SELECT customerid, COUNT(customerid) FROM order;
  • SELECT customerid, COUNT(ordered) FROM order;
  • SELECT customerid, COUNT(orderid) FROM order GROUP BY customerid;
  • SELECT customerid, COUNT(orderid) FROM order GROUP BY orderid;

Question 9. Question : (TCO 7) Given the books table described below, which of the following will display each category along with the average retail price of books in that category?

books: bookid(PK), ISBN, title, pubdate, cost, retail, category, pubid(FK)

  • SELECT AVG(retail) FROM books;
  • SELECT category, AVG(retail) FROM books GROUP BY category:
  • SELECT category, AVG(retail) FROM books HAVING category;
  • SELECT category, SUM(retail) FROM books GROUP BY category;

Question 10. Question : (TCO 7) The expression below will be TRUE for what values of x?

x > ALL(5, 9)

  • 5 and below
  • 5 to 9
  • 5 and above
  • 9 and above

 

 

 

CIS 336 DeVry All Week Course Project Latest

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.

Guidelines

You will create a proposal for a commerce business of your choosing. This can be an actual or fictional business that sells products and/or services. You will determine the business rules and report requirements. Entities that must be included in your model are the following.

Customer

Product (or Service)

Order

Project Deliverables

This task is broken down into four deliverables.

  1. Task 0 (due at the end of Week 1)
  2. Task 1 (due at the end of Week 3)
  3. Task 2 (due at the end of Week 5)
  4. Task 3 (due at the end of Week 7)

Remember that this is a work in progress and in all likelihood, you will have to make numerous changes to your tables and schema as you go along. These changes are to be expected and are a normal part of the database design and implementation process.

Please refer to the sections below for details regarding deliverables for each task.

Task 0 (due at the end of Week 1)

The first task is to create your business narrative. Some of the questions that you should address include (but are not limited to) the following.

  • What is the name of your business?
  • Who will be the users of the system (managers, employees, customers)?
  • What product(s) and or service(s) does it sell? Be specific.
  • Who are the customers? What is the customer base?
  • What sales and distribution channels are used?
  • How are payments made?
  • Are products delivered or shipped to customers in some way?
  • Are sales reps involved? Are they paid on commission?
  • What type of reports are needed by the business?

Please include as much detail as possible in order to provide a foundation for Task 1. Submit your proposal as a Word document. Note that this proposal may be revised in the coming weeks as your understanding of the database modeling process grows.

Task 1 (due at the end of Week 3)

Develop a detailed logical model of your database based on your business scenario submitted for Task 0. Your data model will include an entity-relationship diagram (ERD) developed with Microsoft Visio or MySQL and a data dictionary (DD) developed with Microsoft Excel.

Note that your deliverables each week include any revisions to the previous task.

Submit your Task 1 deliverable as a zip file including the following.

  • Task 0 proposal (with any revisions or updates)
  • Your ERD copied to a Word document that fits on a single 8 x 10 page
  • Your DD (Excel file)

Task 2 (due at the end of Week 5)

First, make sure to make any necessary revisions to your logical model based on Task 1 feedback. Using MySQL, write the statements to develop a physical model of your database by creating the tables and constraints based on your Task 1 logical model. Be sure to use your ERD and data dictionary and create all constraints appropriately.

Once your tables are created, you will populate them with data using MySQL statements to insert records into the database. You should insert a minimum of five records into each table and more where necessary to ensure that the data in the database is sufficient to allow for each of your reports to be tested.

The result will be a script file that includes statements to

  • DROP all tables;
  • CREATE all tables with constraints;
  • INSERT data into all tables; and
  • SELECT data from all tables to show the data in each table.

Name this file yourname_task2.txt.

Also create a Word document that shows the structure of each table and the data in each of your tables (copy and paste from MySQL). Name this file yourname_tables.docx.

Note that your deliverables each week include any revisions to a previous task.

Submit your Task 2 deliverable as a zip file including the following.

  • Task 0 proposal (with any revisions)
  • Your Task 1 ERD (with any revisions)
  • Your Task 1 DD (with any revisions)
  • Your Task 2 script file to create and populate tables (yourname_task2.txt)
  • A Word document showing all tables and data (yourname_tables.docx)

Task 3 (due at the end of Week 7)

Your final task is to use your tables for an update and for reports. There are two requirements.

  1. You will demonstrate an update that includes two tables and uses a subquery. Make sure to prove that your update executed correctly by showing data in the tables before and after the update.
  2. You will also develop at least four meaningful reports. One must include a join, one must use a subquery, and one must use an aggregate function. You need to describe the business requirement of the update and each report. Note that numeric PK values are not often meaningful to a person looking at the report.

You will create a script file that has each of the queries called yourname_task3.txt. You will also document the results of this task in a Word document called yourname_reports.docx to show the result of each query. For the update and each report,

  • describe the update and report requirement;
  • show the query; and
  • show the result of the query.

Include a final section for Conclusions and Lessons Learned regarding the project.

Note that your deliverables each week include any revisions to a previous task.

Submit your Task 3 deliverable as a zip file including the following.

  • Task 0 proposal (with any revisions)
  • Your Task 1 ERD (with any revisions)
  • Your Task 1 DD (with any revisions)
  • Your Task 2 script file to create and populate tables (with any revisions)
  • A Word document showing all tables and data (with any revisions)
  • Your Task 3 script file with update and reports (yourname_task3.txt)
  • A Word file with results of Task 3 and lessons learned (yourname_reports.docx)

 

 

CIS 336 DeVry Final Exam

 

  1. (TCO 1)Most DBMS are referred to as _____________database management systems. (Points : 4)
  • elemental
  • linked
  • hierarchical
  • relational

 

  1. (TCO 1)Data constitutes the building blocks of _____________. (Points : 4)
  • information
  • processing
  • applications
  • programming

 

  1. (TCO 2)If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4)
  • referential
  • restrictive
  • secondary
  • redundant

 

  1. (TCO 2) In a “one-to-many” relationship, which constraint is usually added to the “many” table? (Points : 4)
  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • NOT NULL

 

  1. (TCO 3)A ____ occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world. (Points : 4)
  • surrogate primary keys
  • time-variant data
  • design trap
  • fan trap

 

  1. (TCO 3)All of the following are true about a prime attribute except_____________. (Points : 4)
  • it is a key attribute
  • it is at least part of a key
  • it is not a key attribute
  • it may be part of a composite key

 

  1. (TCO 3)The conflicts between design efficiency, information requirements, and processing speed are often resolved through_____________. (Points : 4)
  • conversion from 1NF to 2NF
  • conversion from 2NF to 3NF
  • compromises that include denormalization
  • conversion from 3NF to 4NF

 

  1. (TCO 4)When a constraint is created at the ______ level with the CREATE TABLE command, the constraint definition is simply included as part of the column definition.(Points : 4)
  • table
  • column
  • database
  • row

 

Page 2 – Multiple Choice

 

  1. (TCO 4)In Oracle, the CONSTRAINT clause is used to ___________________. (Points : 4)
  • create only referential constraints
  • define and name any constraint
  • create a short cut so the constraint does not have to be named
  • create only entity entegrity constraints

 

  1. (TCO 4)The SQL command that lets you list the table contents is (Points : 4)

 

  1. (TCO 5)The Crow’s Foot model is more ___________-oriented than the Chen model. (Points : 4)
  • object
  • user
  • implementation
  • processor

 

  1. (TCO 5)The ___________ model is both software and hardware dependent. (Points : 4)
  • conceptual
  • logical
  • condensed
  • physical

 

  1. (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? (Points : 4)
  • CREATE COLUMN firstorderdate, DATE TO customers;
  • ALTER TABLE customers ADD COLUMN firstorderdate DATE;
  • ALTER TABLE customers ADD firstorderdate DATE;
  • ALTER TABLE customers ADD (firstorderdate DATE);

 

  1. (TCO 6)When modifying the data characteristics of a column in Oracle, which of the following is correct? (Points : 4)
  • The column size can be increased.
  • The size of the column can be decreased.
  • Changing the default value of a column will change the values of data already in a table.
  • If a NUMBER column is empty, its precision and scale cannot be changed.

 

  1. (TCO 6)Which of the followig SQL commands would alter the table DEVRY and add a foreign key that references the CITY table? (Points : 4)
  • ALTER table DEVRY ADD CONSTRAINT devry_studentcity_fk references city;
  • ALTER table DEVRY ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY references city;
  • ALTER table DEVRY ADD CONSTRAINT devry_studentcity_fk FOREIGN KEY (student_city) references city;
  • ALTER table DEVRY ADD CONSTRAINT FOREIGN KEY (student_city) references city;

 

  1. (TCO 7)Given a table named EMPLOYEE, the SQL command to sort records in a specific order would be: (Points : 4)

 

  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

 

Page 3 – Multiple Choice

 

  1. (TCO 7)Which of the following subqueries returns more than one row of results to the outer query? (Points : 4)
  • multiple-column subquery
  • single-row subquery
  • multiple-row subquery
  • correlated subquery

 

  1. (TCO 7)Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column? (Points : 4)
  • NATURAL JOIN
  • ..ON
  • ..USING
  • ..WHERE

 

  1. (TCO 8)Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of categories contained in the table? (Points : 4)
  • SELECT COUNT(DISTINCT category) FROM books;
  • SELECT DISTINCT COUNT(category) FROM books;
  • SELECT DISTINCT (COUNT(category)) FROM books;
  • SELECT DISTINCT COUNT(category) FROM books;

 

  1. (TCO 8)The _____________ function can be used to display upper-case characters in lower-case. (Points : 4)
  • CONVERT
  • MIN
  • LESS
  • LOWER

 

  1. (TCO 8)Which of the following statements will produce the value 21.1? (Points : 4)
  • SELECT ROUND(21.12, 1) FROM dual;
  • SELECT ROUND(21.12, -1) FROM dual;
  • SELECT ROUND(21.12, 0) FROM dual;
  • SELECT ROUND(21.12, 0+) FROM dual;

 

  1. (TCO 9)The column to be updated by the UPDATE command is specified in the ______ clause. (Points : 4)
  • UPDATE
  • SET
  • WHERE
  • COL

 

  1. (TCO 9) If the INSERT INTO command is used to insert data values that violate an existing constraint in a table, which of the following will happen. (Points : 4)
  • Oracle will raise an error and you will have to go update the incorrect data.
  • Oracle will raise an error and the entire row will be rejected.
  • Oracle will raise an error and the invalid piece of data will be rejected.
  • Oracle will raise and error and all current transactions will be rolled back.

 

  1. (TCO 10)Which of the following commands is used to establish a user account? (Points : 4)
  • CREATE NEW USER username
  • IDENTIFIED BY password;
  • CREATE USERNAME username
  • IDENTITY password;
  • CREATE USER username PASSWORD password;
  • CREATE USER username IDENTIFIED BY password;

 

  1. (TCO 10)Which command will grant a system privilege to a user? (Points : 4)
  • GRANT systemprivilege USERNAME username
  • GRANT PRIVILEGE systemprivilege TO username
  • GRANT systemprivilege TO username
  • GRANT systemprivilege ON username