Devry CIS336A
Week 1 Discussion DQ 1 & DQ
2 Latest 2016 March
DQ 1
Regular
Kinds and Entity Relationship Diagrams (graded)
We hear the time period database on a regular basis. Give some examples of
databases that you just work together with frequently. What makes a database
relational? What’s a file storage system? How does a relational database
differ from a file storage system?
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues with this week’s lab.
Devry CIS336A Week 2
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1
Creating
a Good Information Mannequin (graded)
The database information mannequin is the communication hyperlink between the
designer, functions programmer, and consumer. Contribute your views on what
constitutes a great information mannequin and why.
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues with this week’s lab.
Devry CIS336A Week three
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1
Constructing
the Bodily Mannequin (graded)
What’s the significance of constraints in a bodily mannequin? What
function do totally different constraints play in sustaining referential integrity and
information integrity?
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues with this week’s lab.
Devry CIS336A Week four
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1
Understanding
the SELECT assertion (graded)
Stories are generated utilizing queries to a database. The SELECT
assertion is used to retrieve information from one or many tables in a database. Simply
as in different programming languages, understanding the syntax of a choose
assertion is essential. Let’s first focus on the important thing clauses in a SELECT assertion and
the aim of every.
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues with this week’s lab.
Devry CIS336A Week 5
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1
Getting
Information From A number of Tables (graded)
It’s not unusual to need to retrieve information that resides in a number of
tables, particularly when formulating a report. Focus on a number of the efficiency
points when Question Assignmenting three or 4 tables at a time.
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues with this week’s lab.
Devry CIS336A Week 6
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1
How
Group Features Differ From Single-Row Features (graded)
What are some examples of group capabilities, and the way do they differ
from single-row capabilities?
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues with this week’s lab.
Devry CIS336A Week 7
Discussion DQ 1 & DQ 2 Latest
2016 March
DQ 1
Database
Views (graded)
What are some great benefits of deciding on information from a view over
deciding on information from a base desk?
DQ 2
Lab
Discussion board (graded)
This space is used to debate the lab assignments and methods.
Please put up any questions you may have concerning the labs or ideas that you’ve
found throughout your studying course of. At a minimal, put up not less than three
notes that spotlight your expertise or issues 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 seven: Regular Kinds and Entity Relationship Diagrams (xx factors)·.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Hearken to this web page utilizing ReadSpeaker”>Pay attention.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?iLab OverviewScenario/SummaryDownload the iLab directions and the Reply Sheet for the required steps to be accomplished for this lab. They are often discovered under. You’ll discover that the readings, together with lectures, the examples we labored on in the course of the lecture, and different audio and visible aids supplied, will show you how to deal with this week’s lab. Keep in mind to at all times comply with the directions to get most credit score, and use the weekly dialogue associated to the iLab and the Q & A Discussion board for extra Help. Be particular and state the issue you’re having clearly, together with what you may have carried out to resolve it, within the dialogue.Microsoft Visio TutorialâEssential InformationImportant: Earlier than beginning, you’ll want to overview the Logical Modeling Half 1video below Video Library to familiarize you with find out how to use MS Visio to attract Entity Relationship Diagrams.DeliverablesNOTESubmit your project to the Dropbox, situated on the high of this web page. For directions on find out how to use the Dropbox, learn these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.(See the Syllabus part “Due Dates for Assignments & Exams” for due dates.)The deliverable for this lab is a single MS Phrase doc named lab1_solutions_yourname.docx with the solutions included for Steps 1âfour.Required SoftwareMicrosoft Workplace: Phrase and Visio 2010Use a private copy or entry the software program at.devry.edu/”>https://lab.devry.edu. All StepsLab StepsSTEP 1: Obtain the Week 1 Lab InstructionsFollow the directions to finish the lab by downloading the next information:· .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 Solutions on the Lab 1 Pupil Reply SheetUse Visio or Phrase to attract the dependency diagrams for Steps 1âthree. Use Visio to attract the ERD for Step four.That is the tip 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 seven: 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 directions and the Reply Sheet for the required steps to be accomplished for this lab. They are often discovered under. You’ll discover that the readings, together with lectures, the examples we labored on in the course of the lecture, and different audio and visible aids supplied, will show you how to deal with this week’s lab. Keep in mind to at all times comply with the directions to get most credit score, and use the weekly dialogue associated to the iLab and the Q & A Discussion board for extra Help. Be particular and state the issue you’re having clearly, together with what you may have carried out to resolve it, within the dialogue.DeliverablesNOTESubmit your project to the Dropbox, situated on the high of this web page. For directions on find out how to use the Dropbox, learn these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.(See the Syllabus part “Due Dates for Assignments & Exams” for due dates.)The deliverable for this lab shall be your accomplished ERD as a single MS Phrase doc utilizing copy/paste from the MS Visio utility and namedlab2_solutions_yourname.docxRequired SoftwareMicrosoft Workplace: WordUse a private copy or entry the software program at.devry.edu/”>https://lab.devry.edu.All StepsMicrosoft Workplace: VisioUse a private copy or entry the software program at.devry.edu/”>https://lab.devry.edu.All StepsLab StepsSTEP 1: Obtain the Week 2 Lab Directions.Observe the directions to finish the lab by downloading the next information:·.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 Phrase doc as indicated within the lab directions.That is the tip of lab #2devry cis336 week three ilab latest 2016 march.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336_W3_iLab.html”>iLab> Lab StepsLab three of seven: Constructing the Bodily Model·.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Hearken to this web page utilizing ReadSpeaker”>Pay attention.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?iLab OverviewScenario/SummaryBeginning with this lab, and persevering with by way of the remaining weeks you may be doing your entire work within the MySQL EDUPE Setting. By now you may have acquired your logon ID and password and may have not less than made positive you’ll be able to join. If for any motive you haven’t carried out so, please achieve this now earlier than persevering with any additional. If for any motive you can’t join, then it’s essential let the teacher know ASAP in order that any issues might be resolved.On this lab you’ll rework a logical database design (information mannequin) right into a bodily mannequin (tables, constraints, and relationships). Your job shall be to take the connection diagram together with the meta information outlined within the information dictionary and outline the desk buildings and constraints to create the bodily tables. As soon as this has been carried out, you’ll populate the tables with information. Lastly, you’ll write SELECT statements to question the tables and confirm the information was populated.DeliverablesNOTESubmit your project to the Dropbox, situated on the high of this web page. For directions on find out how to use the Dropbox, learn these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.(See the Syllabus part “Due Dates for Assignments & Exams” for due dates.)1. Your script file. Create this file in Notepad,notWord. Be sure that your title is in a remark space on the high of the script file. Use a double sprint to create a one-line remark.âJacob SmithâLab 3Required SoftwareMySQLAccess the software program at.devry.edu/”>https://devry.edupe.web:8300Lab StepsSTEP 1: Obtain the Week three Lab InstructionsComplete the lab by downloading the next information 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 put in writing the SQL statements and submit in accordance the lab directions.That is the tip of Lab #3devry cis336 week four ilab latest 2016 march.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336_W4_iLab.html”>iLab> STEP 2: Obtain the Week four Lab Directions and Reply SheetLab four of seven: Constructing the Bodily Model··.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Hearken to this web page utilizing ReadSpeaker”>Pay attention.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?iLab OverviewScenario/SummaryLab four will introduce the varied elements of the SQL SELECT assertion and the strategies of retrieving information from the database tables. The lab will make the most of a database with a set of tables that you’ll create and populate utilizing the directions and script file discovered under. These tables shall be used for the remaining labs on this class.DeliverablesNOTESubmit your project to the Dropbox, situated on the high of this web page. For directions on find out how to use the Dropbox, learn these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.(See the Syllabus part “Due Dates for Assignments & Exams” for due dates.)The deliverable for this lab will embrace the next.· The Pupil Reply Sheet file under supplies a spot for every question and the output of the question. You’ll copy and paste this info out of your MySQL atmosphere. Make certain your title, course quantity, and lab quantity are in your file which shall be submitted to the iLab Dropbox for Week four.Required SoftwareMicrosoft Workplace: WordUse a private copy or entry the software program at.devry.edu/”>https://lab.devry.edu.All StepsMySQLAccess the software program at.devry.edu/”>https://devry.edupe.web:8300Lab StepsSTEP 1: Create the Database and TablesCreate the database and tables (that shall be utilized in labs 4â7) by downloading the next information.·.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CreateOMTables.docx”>CreateOMTables.docx(Directions)·.equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/create_OM_db.sql”>create_OM_db.sql(Database Script)STEP 2: Obtain the Week four Lab Directions and Reply SheetFollow the directions to finish the lab by downloading the next information.·.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 positive to check with the ERD for the database in.equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/OM_ERD.docx”>OM_ERD.docxwhen creating your queries.STEP three: Submit Your Reply sheetComplete the Reply Sheet to point out your queries and outcomes and submit in line with the lab directions.That is the tip of Lab#four.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: Obtain the Week 5 Lab Directions and Reply SheetLab 5 of seven: Retrieving Information From A number of Tables (39 factors).readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Hearken to this web page utilizing ReadSpeaker”>Pay attention.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?iLab OverviewScenario/SummaryLab 5 offers with writing queries utilizing a number of tables as coated within the studying and lecture materials this week. In some circumstances, you may be given the choice to decide on the JOIN syntax to make use of, in different circumstances, you may be requested to take a particular strategy. Utilizing the inaccurate course of when the method is specified will end in factors being taken off for that downside.DeliverablesNOTESubmit your project to the Dropbox, situated on the high of this web page. For directions on find out how to use the Dropbox, learn these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.(See the Syllabus part “Due Dates for Assignments & Exams” for due dates.)The deliverable for this lab will embrace:The Pupil Reply Sheet file that you’ll obtain under supplies a spot for every question and the output of the question. You’ll copy and paste this info out of your MySQL atmosphere. Make certain your title, course quantity, and lab quantity are in your file which shall be submitted to the iLab Dropbox for Week 5.Required SoftwareMicrosoft Workplace: WordUse a private copy or entry the software program at.devry.edu/”>https://lab.devry.edu.All StepsMySQLAccess the software program at.devry.edu/”>https://devry.edupe.web:8300Lab StepsPRELIMINARY STEP: If You Have Not Created the Database But, Please Full.This lab will make the most of the tables that have been created in Lab four. You probably have not but created these tables,you’ll be able to create the database and tables (utilized in labs 4â7) by downloading the next information.·.equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/CIS336_CreateOMTables.docx”>CreateOMTables.docx(Directions)·.equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/create_OM_db.sql”>create_OM_db.sql(Database Script)STEP 1: Obtain the Week 5 Lab Directions and Reply SheetFollow the directions to finish the lab by downloading the next information.·.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 positive to check with the ERD for the database in.equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/OM_ERD.docx”>OM_ERD.docxwhen creating your queries.STEP 2: Submit Your Reply sheetComplete the Reply Sheet to point out your queries and outcomes and submit in line with the lab directions.That is the tip 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: Obtain the Week 6 Lab Directions and Reply SheetLab 6 of seven: Group Features and Subqueries·.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Hearken to this web page utilizing ReadSpeaker”>Pay attention.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?iLab OverviewScenario/SummaryLab 6 will introduce group or combination capabilities and subqueries. Be sure that to comply with the directions supplied by every step.DeliverablesNOTESubmit your project to the Dropbox, situated on the high of this web page. For directions on find out how to use the Dropbox, learn these.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.(See the Syllabus part “Due Dates for Assignments & Exams” for due dates.)The deliverable for this lab will embrace the next.The Pupil Reply Sheet file that you’ll obtain under supplies a spot for every question and the output of the question. You’ll copy and paste this info out of your MySQL atmosphere. Make certain your title, course quantity, and lab quantity are in your file which shall be submitted to the iLab Dropbox for Week 5.Required SoftwareMicrosoft Workplace: WordUse a private copy or entry the software program at.devry.edu/”>https://lab.devry.edu. All StepsMySQLAccess the software program at.devry.edu/”>https://devry.edupe.web:8300Lab StepsPRELIMINARY STEP: If You Have Not Created the Database But, Please Full.This lab will make the most of the tables that have been created in Lab four. You probably have not but created these tables, you’ll be able to create the database and tables (utilized in labs 4â7) by downloading the next information.· .equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/CIS336_CreateOMTables.docx”>CreateOMTables.docx (Directions)· .equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/create_OM_db.sql”>create_OM_db.sql (Database Script)STEP 1: Obtain the Week 6 Lab Directions and Reply SheetFollow the directions to finish the lab by downloading the next information.· .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 positive to check with the ERD for the database in.equella.ecollege.com/gadgets/184903ef-b6c7-433c-89e6-d48b5ad6f3be/zero/OM_ERD.docx”>OM_ERD.docx when creating your queries.STEP 2: Submit Your Reply SheetComplete the reply sheet to point out your queries and outcomes, and submit in line with the lab directions.That is the tip of Lab #6All Week QuizDevry CIS336 Week 2
Quiz Latest 2016 MarchDevry CIS336 Week 2 Quiz Latest 2016 MarchQuestion 1. Question Assignment : (TCO 2) Which assertion is FALSE relating to
a main key?Solely father or mother tables should have a main key.The values have to be distinctive.It may be made up of a number of attributes.The worth can’t be NULL.Question Assignment 2. Question Assignment : (TCO 2) _____ integrity insures that the
worth of a overseas key should match a main key worth within the desk to which it
is said, or be null.ReferentialEntityDataLogicalQuestion three. Question Assignment : (TCO 2) A verb associating two nouns in a
enterprise rule often interprets to a(n) ____ within the information mannequin.entityattributerelationshipconstraintQuestion four. Question Assignment : (TCO four) A(n) _____ supplies a graphical
description of an information mannequin.entity relationship diagramdata dictionarybusiness rulepseudocodeQuestion 5. Question Assignment : (TCO 2) A _____ main secret is made up of
multiple attribute.compositeforeignbridgelinkingQuestion 6. Question Assignment : (TCO four) Within the determine under, the OrderLineItems
entity is there to implement what kind of relationship between Orders and
Merchandise?One to oneOne to manyMany to manyNo relationshipQuestion 7. Question Assignment : (TCO 2) When designing a database, you
ought to _____.make certain entities are in regular type earlier than desk buildings are
createdcreate desk buildings then normalize the databaseonly normalize the database when efficiency issues occurconsider extra vital points, akin to efficiency, earlier than
normalizingQuestion eight. Question Assignment : (TCO 2) A desk that’s in 1NF and consists of
no partial dependencies solely is claimed to be in _____.1NF2NF3NFBCNFQuestion 9. Question Assignment : (TCO 2) A desk is just not in 1NF if _____.it has a main key definedall of the important thing attributes are definedthere are repeating teams within the tableall attributes are depending on the first keyQuestion 10. Question Assignment : (TCO 2) Entity attributes and first keys
should not current within the _____ information mannequin.logicalphysicalconceptualnetworkDevry CIS336 Week three
Quiz Latest 2016 MarchDevry CIS336 Week three Quiz Latest 2016 March1. Question Assignment : (TCO three) The _____ column attribute will
routinely generate distinctive numbers in sequence.DEFAULTAUTO_INCREMENTAUTO_SEQUENCENOT NULLQuestion 2. Question Assignment : (TCO 5) The _____ key phrase is utilized in an
ALTER assertion to take away a column from an current desk.MODIFY COLUMNADD COLUMNDELETE COLUMNDROP COLUMNQuestion three. Question Assignment : (TCO three) Which makes use of the least quantity of
storage?âExampleâ saved in a column of kind CHAR(20)âExamâ saved in a column of kind CHAR(20)âExâ saved in a column of kind CHAR(20)All of them use the identical quantity of storage.Question Assignment four. Question Assignment : (TCO three) The TIME information kind in MySQL can
retailer _____.dates onlytimes onlydates and timesNone of the aboveQuestion 5. Question Assignment : (TCO three) Which assertion is fake relating to
the creation of a overseas key constraint at desk degree or with an ALTER
assertion?The father or mother desk should exist already.The sector should already be outlined within the desk.The PK and FK fields should have the identical title.The PK and FK fields might have totally different names.Question Assignment 6. Question Assignment : (TCO three) A overseas key constraint can solely
reference a column in one other desk that has been assigned a(n) _____
constraint.NOT NULLUNIQUEPRIMARY KEYDEFAULTQuestion 7. Question Assignment : (TCO three) You might be making a desk known as
Division, with fields for the first key DeptID (Integer) and division
title (VARCHAR). What (if something) is incorrect with the next code?CREATE TABLE Division(deptID Major Key INTEGER ,deptName NOT NULL VARCHAR(10));You need to use curly braces, not parentheses.The info kind should instantly comply with the sector title.The key phrases can’t be in higher case.Nothing is incorrect.Question Assignment eight. Question Assignment : (TCO three) What datatype is finest to retailer a
personâs age?INTEGERVARCHARDECIMALFLOATQuestion 9. Question Assignment : (TCO 5) Which assertion will take away the
subject STATUS from the CUSTOMERS desk?ALTER TABLE prospects REMOVE standing;ALTER TABLE prospects DROP standing;ALTER TABLE prospects DROP COLUMN standing;ALTER TABLE prospects DELETE standing;Question Assignment 10. Question Assignment : (TCO eight) Once you write an INSERT assertion
with a column record, which columns might be omitted from the column record?AUTO_INCREMENT onlyDEFAULT onlyNOT NULL onlyAUTO_INCREMENT, DEFAULT, and fields that enable NULLDevry CIS336 Week four
Quiz Latest 2016 MarchDevry CIS336 Week four Quiz Latest 2016 MarchQuestion 1. Question Assignment : (TCO 6) To retrieve all fields from a
desk, useSELECT ALL.SELECT ANY.SELECT ().SELECT *.Question Assignment 2. Question Assignment : (TCO 6) Which operator could be most
applicable to find out books with a retail worth within the vary of $50 to $100?LIKEINBETWEEN>Question Assignment three. Question Assignment : (TCO 6) Which code returns the date subject
HIREDATE within the format: Friday, April fifth, 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 Assignment four. Question Assignment : (TCO 6) Given a buyer desk with fields
for firstname and lastname, which of the next will show the shopper
title as a single subject within the format âJones, Tomâ with a heading?SELECT CONCAT(lastname, firstname) as âNameâ FROM buyer;SELECT CONCAT(firstname, lastname) as âNameâ FROM buyer;SELECT CONCAT(lastname, â, â, firstname) as âNameâ FROM buyer;SELECT CONCAT lastname â, â firstname as âNameâ FROM buyer;Question Assignment 5. Question Assignment : (TCO eight) The column to be up to date by the
UPDATE command is specified within the _____ clause.WHEREMODIFYALTERSETQuestion 6. Question Assignment : (TCO 6) Given a desk orders with fields
for orderid, orderdate, and shipdate, which question will show the ordered for
solely these orders that haven’t 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 Assignment 7. Question Assignment : (TCO 6) Which WHERE clause will return information
on all workers with a final title starting with âSâ?WHERE lastname = âSâWHERE lastname = âSpercentâWHERE lastname LIKE âSâWHERE lastname LIKE âSpercentâQuestion Assignment eight. Question Assignment : (TCO 6) Given a books desk with fields of
title, price, and retail, what if something is incorrect with the next question
(assuming all fields exist)?SELECT * FROM books WHERE price > 20 ORDER BY retail;You need to type and filter on the identical subject.You can not use ORDER BY and WHERE in the identical question.The WHERE clause should at all times be final.Nothing is incorrect.Question Assignment 9. Question Assignment : (TCO eight) You may delete a number of rows in
a desk through the use of the _____ command.UPDATEDROPDELETEALTERQuestion 10. Question Assignment : (TCO 6) Given a books desk with fields:
title, class (akin to âSPORTSâ), price, retail; what situation will return
âCOMPUTERâ books with a retail worth between $50 and $100 ?WHERE retail > 50 AND < 100 AND class = âCOMPUTERâWHERE class = âCOMPUTERâ AND (retail BETWEEN 100 and 50)WHERE class = âCOMPUTERâ AND retail < 50 AND retail > 100WHERE class = âCOMPUTERâ AND ( retail BETWEEN 50 AND 100)Devry CIS336 Week 5
Quiz Latest 2016 MarchDevry CIS336 Week 5 Quiz Latest 2016 March1. Question Assignment : (TCO 7) The implicit inside be a part of syntax is outlined as
_____.NATURAL JOINJOIN ONJOIN USINGWHERE clauseQuestion 2. Question Assignment : (TCO 7) To affix 4 tables would require
_____ be a part of circumstances.432Can’t inform with out an ERD.Question Assignment three. Question Assignment : (TCO 7) Given the 2 tables described
under, which of the next JOIN queries (if any) is just not appropriate?buyer: with the fields customerid(PK), lastname, firstnameorder: with the fields orderid(PK), orderdate, customerid(FK)SELECT lastname, orderdate from buyer JOIN order ON
buyer.customerid = order.customerid;SELECT lastname, orderdate from buyer JOIN order USING
(customerid);SELECT lastname, orderdate from buyer, orders;All the aboveQuestion four. Question Assignment : (TCO 7) In a be a part of, column names have to be
certified onlyin inside joins.in outer joins.when the code is complicated.when the identical column names exist in each tables.Question Assignment 5. Question Assignment : (TCO 7) A left be a part of returnsrows within the left desk that donât fulfill the be a part of situation.unmatched rows from each the left and proper tables.rows in the fitting desk that donât fulfill the be a part of situation.the Cartesian product of the 2 tables.Question Assignment 6. Question Assignment : (TCO 7) Once you use the USING key phrase for
a jointhe be a part of can’t be an outer be a part of.the be a part of can’t be based mostly on multiple column.the be a part of have to be based mostly on a column or columns which have the identical
title in each tables.the be a part of have to be an inside be a part of.Question Assignment 7. Question Assignment : (TCO 7) Contemplate the ERD under. What number of
tables could be required to create a question to show the shopper first and
final title together with orderdate of every order they positioned?OneTwoThreeFourQuestion eight. Question Assignment : (TCO 7) Contemplate the ERD under. What tables
shall be wanted to create a report displaying the firstname and lastname of
prospects who’ve positioned an order for any product with keyboard within the
description?buyer, product onlycustomer, order, product onlycustomer, orderline onlycustomer, order, orderline, productQuestion 9. Question Assignment : (TCO 7) Contemplate the ERD under. What tables
shall be wanted to create a report displaying buyer first and final title alongside
with order date? The report ought to present all prospects even when they’ve by no means
positioned an order.SELECT firstname, lastname, orderdate from buyer LEFT JOIN
order;SELECT firstname, lastname, orderdate FROM buyer RIGHT JOIN
order ON buyer.customerid = order.customerid;SELECT firstname, lastname, orderdate FROM buyer JOIN order
USING (customerID);SELECT firstname, lastname, orderdate FROM buyer LEFT JOIN
order ON buyer.customerid = order.customerid;Question Assignment 10. Question Assignment : (TCO 7) Contemplate the ERD under. Be aware that
there are some merchandise produced in-house that don’t require a vendor, thus
their vendorID is NULL. Additionally be aware that not all distributors at the moment provide
merchandise. Which question could be used to generate a report displaying vendorname and
productname, and can embrace ALL distributors even when they don’t at the moment provide
any merchandise?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 Assignment : (TCO 7) Which is NOT an combination perform?SUMCOUNTROUNDMAXQuestion 2. Question Assignment : (TCO 7) Which of the next statements
is appropriate?WHERE operates on teams fashioned by combination capabilities and HAVING
operates on particular person rows.WHERE can solely be used together with HAVING.HAVING can solely be used together with WHERE.WHERE operates on particular person rows and HAVING operates on teams
fashioned by combination capabilities.Question Assignment three. Question Assignment : (TCO 7) Given the books desk described
under, which of the next will show the date of the e-book with the
earliest publication date?books: bookid(PK), ISBN, title, pubdate, price, retail, class,
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 Assignment 5. Question Assignment : (TCO 7) Which of the values listed under
might be returned by a subQuestion Assignment referenced as follows?WHERE vendorid = (subQuestion Assignment)A single valueA column of a number of rowsA tableA subQuestion Assignment canât be used on this means.Question Assignment 6. Question Assignment : (TCO 7) What kind of subQuestion Assignment is executed
as soon as for every row processed by the principle question?CorrelatedUncorrelatedInnerOuterQuestion 7. Question Assignment : (TCO 7) Given the 2 tables described
under, which of the next queries will show the names of the purchasers
with orders shipped after December 1, 2014?buyer: wit
