devry cis336 Full courses ( Discussion + ilab +Quiz+ Courses Project) latest 2016 march Not Final exam

Devry CIS336A
Week 1 Discussion DQ 1 & DQ
2 Latest 2016 March

DQ 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?

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

Devry CIS336A Week 2
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 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.

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

Devry CIS336A Week 3
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 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?

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

Devry CIS336A Week 4
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 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.

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

Devry CIS336A Week 5
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 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.

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

Devry CIS336A Week 6
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 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?

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

Devry CIS336A Week 7
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1

Database
Views (graded)

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

DQ 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.devry cis336 week ALL ilab latest 2016 march.784px;”=””>devry cis336 week 1 ilab la.1em;”>est 2016 march.784px;”=””>.equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336_W1_iLab.html”>iLab> Required SoftwareLab 1 of 7: Normal Forms and Entity Relationship Diagrams (xx 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 OverviewScenario/SummaryDownload 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 InformationImportant: 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.DeliverablesNOTESubmit 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 SoftwareMicrosoft Office: Word and Visio 2010Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All StepsLab StepsSTEP 1: Download the Week 1 Lab InstructionsFollow 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.docxSTEP 2: Submit Your Answers on the Lab 1 Student Answer SheetUse 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 #1devry cis336 week 2 ilab latest 2016 march.equella.ecollege.com/file/ace06cf1-3107-42f4-9c63-b71dc0625d56/15/CIS336_W2_iLab.html”>iLab> Lab StepsLab 2 of 7: The Expanded Entity Relationship Diagram.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?iLab OverviewScenario/SummaryDownload 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.DeliverablesNOTESubmit 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.docxRequired SoftwareMicrosoft Office: WordUse a personal copy or access the software at.devry.edu/”>https://lab.devry.edu.All StepsMicrosoft Office: VisioUse a personal copy or access the software at.devry.edu/”>https://lab.devry.edu.All StepsLab StepsSTEP 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.docxSTEP 2: Submit Your AnswersUse Visio to create your ERD. Copy and paste to a Word document as indicated in the lab instructions.This is the end of lab #2devry cis336 week 3 ilab latest 2016 march.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336_W3_iLab.html”>iLab> Lab StepsLab 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 OverviewScenario/SummaryBeginning 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.DeliverablesNOTESubmit 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,notWord. 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 3Required SoftwareMySQLAccess the software at.devry.edu/”>https://devry.edupe.net:8300Lab StepsSTEP 1: Download the Week 3 Lab InstructionsComplete 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.zipSTEP 2: Submit Your SQL Command FileUse Notepad to write the SQL statements and submit according the lab instructions.This is the end of Lab #3devry cis336 week 4 ilab latest 2016 march.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 SheetLab 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 OverviewScenario/SummaryLab 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.DeliverablesNOTESubmit 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 SoftwareMicrosoft Office: WordUse a personal copy or access the software at.devry.edu/”>https://lab.devry.edu.All StepsMySQLAccess the software at.devry.edu/”>https://devry.edupe.net:8300Lab StepsSTEP 1: Create the Database and TablesCreate 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 SheetFollow 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.docxBe 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 sheetComplete the Answer Sheet to show your queries and results and submit according to the lab instructions.This is the end of Lab#4.devry cis336 week 5 ilab latest 2016 march.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 SheetLab 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 OverviewScenario/SummaryLab 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.DeliverablesNOTESubmit 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 SoftwareMicrosoft Office: WordUse a personal copy or access the software at.devry.edu/”>https://lab.devry.edu.All StepsMySQLAccess the software at.devry.edu/”>https://devry.edupe.net:8300Lab StepsPRELIMINARY 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 SheetFollow 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.docxBe 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 sheetComplete the Answer Sheet to show your queries and results and submit according to the lab instructions.This is the end of Lab #5.devry cis336 week 6 ilab latest 2016 march.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 SheetLab 6 of 7: Group Functions and Subqueries·.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 OverviewScenario/SummaryLab 6 will introduce group or aggregate functions and subqueries. Make sure to follow the instructions provided by each step.DeliverablesNOTESubmit 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 SoftwareMicrosoft Office: WordUse a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All StepsMySQLAccess the software at.devry.edu/”>https://devry.edupe.net:8300Lab StepsPRELIMINARY 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 SheetFollow 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.docxBe 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 SheetComplete the answer sheet to show your queries and results, and submit according to the lab instructions.This is the end of Lab #6All Week QuizDevry CIS336 Week 2
Quiz Latest 2016 MarchDevry CIS336 Week 2 Quiz Latest 2016 MarchQuestion 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.ReferentialEntityDataLogicalQuestion 3. Question : (TCO 2) A verb associating two nouns in a
business rule usually translates to a(n) ____ in the data model.entityattributerelationshipconstraintQuestion 4. Question : (TCO 4) A(n) _____ provides a graphical
description of a data model.entity relationship diagramdata dictionarybusiness rulepseudocodeQuestion 5. Question : (TCO 2) A _____ primary key is made up of
more than one attribute.compositeforeignbridgelinkingQuestion 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 oneOne to manyMany to manyNo relationshipQuestion 7. Question : (TCO 2) When designing a database, you
should _____.make sure entities are in normal form before table structures are
createdcreate table structures then normalize the databaseonly normalize the database when performance problems occurconsider more important issues, such as performance, before
normalizingQuestion 8. Question : (TCO 2) A table that is in 1NF and includes
no partial dependencies only is said to be in _____.1NF2NF3NFBCNFQuestion 9. Question : (TCO 2) A table is not in 1NF if _____.it has a primary key definedall of the key attributes are definedthere are repeating groups in the tableall attributes are dependent on the primary keyQuestion 10. Question : (TCO 2) Entity attributes and primary keys
are not present in the _____ data model.logicalphysicalconceptualnetworkDevry CIS336 Week 3
Quiz Latest 2016 MarchDevry CIS336 Week 3 Quiz Latest 2016 March1. Question : (TCO 3) The _____ column attribute will
automatically generate unique numbers in sequence.DEFAULTAUTO_INCREMENTAUTO_SEQUENCENOT NULLQuestion 2. Question : (TCO 5) The _____ keyword is used in an
ALTER statement to remove a column from an existing table.MODIFY COLUMNADD COLUMNDELETE COLUMNDROP COLUMNQuestion 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 onlytimes onlydates and timesNone of the aboveQuestion 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 NULLUNIQUEPRIMARY KEYDEFAULTQuestion 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?INTEGERVARCHARDECIMALFLOATQuestion 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 onlyDEFAULT onlyNOT NULL onlyAUTO_INCREMENT, DEFAULT, and fields that allow NULLDevry CIS336 Week 4
Quiz Latest 2016 MarchDevry CIS336 Week 4 Quiz Latest 2016 MarchQuestion 1. Question : (TCO 6) To retrieve all fields from a
table, useSELECT 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?LIKEINBETWEEN>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.WHEREMODIFYALTERSETQuestion 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.UPDATEDROPDELETEALTERQuestion 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 > 100WHERE category = ‘COMPUTER’ AND ( retail BETWEEN 50 AND 100)Devry CIS336 Week 5
Quiz Latest 2016 MarchDevry CIS336 Week 5 Quiz Latest 2016 March1. Question : (TCO 7) The implicit inner join syntax is defined as
_____.NATURAL JOINJOIN ONJOIN USINGWHERE clauseQuestion 2. Question : (TCO 7) To join four tables would require
_____ join conditions.432Cannot 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, firstnameorder: 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 aboveQuestion 4. Question : (TCO 7) In a join, column names need to be
qualified onlyin 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 returnsrows 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 jointhe 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?OneTwoThreeFourQuestion 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 onlycustomer, order, product onlycustomer, orderline onlycustomer, order, orderline, productQuestion 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;Devry CIS336 Week 6
Quiz Latest 2016 MarchDevry CIS336 Week 6 Quiz Latest 2016 March1. Question : (TCO 7) Which is NOT an aggregate function?SUMCOUNTROUNDMAXQuestion 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 valueA column of one or more rowsA tableA 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?CorrelatedUncorrelatedInnerOuterQuestion 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: wit

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with CheapNursingWriter
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Psychology
Thanks a lot the paper was excellent
Customer 452453, October 26th, 2022
English 101
Very good job. I actually got an A
Customer 452443, September 25th, 2022
Anthropology
Excellent services will definitely come back
Customer 452441, September 23rd, 2022
Nursing
The paper was EXCELLENT. Thank you
Customer 452449, September 23rd, 2022
Business Studies
Job well done. Finish paper faster than expected. Thank you!
Customer 452451, October 3rd, 2022
Anthropology
excellent loved the services
Customer 452443, September 23rd, 2022
Business Studies
Thank you!
Customer 452451, November 27th, 2022
Theology
Job well done and completed in a timely fashioned!
Customer 452451, November 18th, 2022
Architecture, Building and Planning
The assignment was well written and the paper was delivered on time. I really enjoyed your services.
Customer 452441, September 23rd, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat