CIS 336 PAPERS Learn by Doing/cis336papers.com

1
CIS 336 PAPERS Learn by Doing/cis336papers.
com
2
CIS 336 PAPERS Learn by Doing

• CIS 336 All iLabs Week 1 to Week 7 Devry
  University (Devry)
• FOR MORE CLASSES VISIT
• www.crj201papers.com
•  
• CIS 336 All iLabs Week 1 to Week 7 Devry
  University

3
CIS 336 PAPERS
Learn by Doing

• CIS 336 Entire Course Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• CIS 336 Entire Course Devry University

4
CIS 336 PAPERS Learn by
Doing

• CIS 336 Final Exam 1 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• 1. (TCO 1) Most DBMS are referred to as
  _____________database management systems. (Points
  4)
• elemental
• linked
• hierarchical
• relational
• 2. (TCO 1) Data constitutes the building blocks
  of _____________. (Points 4)
• information
• processing
• applications
• programming

5
CIS 336 PAPERS Learn by
Doing

• CIS 336 Final Exam 2 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• 1. (TCO 7) Write a join query using NATURAL JOIN
  that for every order in the ORDERS table will
  list the order number and order date along with
  the cusnumber, last name, and first name of the
  customer who placed the order.
• 2. (TCO 8) Write a query that will list the part
  number, part description, and on-hand value
  (units on hand unit price) for each part in
  item class AP. Give the expression an alias of
  "On Hand Value".
• 3. (TCO 8) Write a sub query that will list the
  part number, part description, and units on hand
  of all parts where the number of units on hand is
  greater than the average of units on hand for all
  parts.

6
CIS 336 PAPERS Learn by
Doing

• CIS 336 Final Exam 3 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• 1. (TCO 2) Explain what physical independence
  means. (Points 15)
• 2. (TCO 8) Sally wants to query the EMP table and
  determine how many of the employees live in each
  of the cities the company has factories in. She
  writes the following query but it does not work.
  What is wrong with the way the query is
  constructed?
• 3. (TCO 3) Explain in what two specific cases
  presented in the text composite primary keys are
  particularly useful. (Points 15)
• 4. (TCO 7) How are comparisons done on character
  string data in a queries WHERE clause, and why
  would this be especially useful in comparing
  certain attributes? (Points 15)

7
CIS 336 PAPERS Learn by
Doing

• CIS 336 Final Exam 4 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• (TCO 8) Write a query that will display the
  earliest date an order was placed.
• 3. (TCO 7) Using the BETWEEN operator, write a
  query that will list all details about all orders
  that were placed during the period of September
  3rd thru September 5th of 1998.
• 5. (TCO 7) Write a query that will list the
  customer first and last name and the sales rep
  commission rate using JOIN ON.

8
CIS 336 PAPERS Learn by
Doing

• CIS 336 Final Exam 4 Sets of Answers (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• CIS 336 Final Exam 4 Sets of Answers

9
CIS 336 PAPERS Learn by
Doing

• CIS 336 Quiz 1 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• (TCO 3) Normalization works through a series of
  stages called normal forms. Typically _________
  stages must be completed before a table can be
  considered normalized.
• (TCO 3) The conflicts between design efficiency,
  information requirements, and processing speed
  are often resolved through
• (TCO 3) The PK must uniquely identify each entity
  instance. A primary key must be able to guarantee
  unique values. It cannot contain nulls. This
  rationale belongs to
• (TCO 9) The SQL command that lets you insert data
  into a table, one row at a time, is _____________.

10
CIS 336 PAPERS Learn by
Doing

• CIS 336 Quiz 2 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• (TCO 2) Within a table, the primary key must be
  unique so that it will identify each row. When
  this is the case, the table is said to exhibit
  ___________.
• (TCO 2) A field that consists of data values that
  can be used for arithmetic procedures is a
  _________ type field.
• (TCO 2) A relationship is an association between
  ___________
• (TCO 5) The _____________ model represents a
  global view of the data.
• (TCO 5) In Crow's Foot notation, a forked end
  means

11
CIS 336 PAPERS Learn by
Doing

• CIS 336 Quiz 3 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• (TCO 7) 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.
• (TCO 7) The ______________________ comparison
  operator is used to search for values which are
  not NULL.
• TCO 7) You want to write a query that will return
  the customer number, first and last name from the
  book_order table (shown below) for all customers
  who have a P.O. Box and who live in either
  Trenton or Chicago. Write the query that will
  accomplish this task.

12
CIS 336 PAPERS Learn by
Doing

• CIS 336 Quiz 4 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• (TCO 8) Oracles pseudo table used only for cases
  where a table is not really needed is _________?
• (TCO 7) Using the BOOK_CUSTOMER and BOOK_ORDER
  tables shown below for reference which SQL
  statement will return the same results as the
  following SQL statement?
• (TCO 7) A table alias or qualifier cannot be
  assigned in the FROM clause of which type of
  join?
• (TCO 7) The _______ query joins a table to itself
  using aliases to distinctly identify each
  instance of the table.

13
CIS 336 PAPERS Learn by
Doing

• CIS 336 Quiz 5 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• (TCO 8) Which of the following is NOT a valid
  statement?
• (TCO 8) Based on the contents of the BOOKS table
  shown below, which of the following SQL
  statements will return the total profit generated
  by books in the COOKING category?
• (TCO 8) Which comparison operator evaluates a
  subquery and if it returns false, will not
  execute the calling query?
• (TCO 8) The following SQL statement contains
  which type of subquery?

14
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 1 iLab 1 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• L A B S T E P S STEP 1 Drawing your first ER
  diagram Title Identify the foreign key columns in
  the table structures above and draw a
  relationship diagram depicting the relationships
  between the tables. In the Order table , the
  CustNo column references the Customer table and
  the EmpNo column references the Employee table.
  For each relationship, identify the table on the
  "1" side of the relationship and the table on the
  "Many" side. STEP 2 Extending the ER diagram
  Extend your relationship diagram from problem 1
  by adding two tables (OrdLine and Product). Table
  definitions for the table structures and primary
  keys constraints are shown below. You will need
  to identify the FOREIGN KEY(s) to complete this
  problem.

15
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 2 iLab 2 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• L A B S T E P S STEP 1 Drawing entities and
  attributes Be sure to include all of the entities
  that have been defined. You need to include at
  least the primary and foreign key attributes
  where applicable in your diagram. STEP 2
  Indication of all relationships Be sure that you
  link all entities based on PK to FK
  relationships. There may be a case where you need
  to identify a combination PK and if so make sure
  that all of the relationships involved are
  defined. Be sure that you have set your Visio
  editor to show Crow's Foot notation. Also, be
  sure that you are defining the correct
  cardinality for the relationships. STEP 3 Naming
  of relationships Do not accept the default naming
  convention for your relationships in all cases.

16
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 3 Group Project Task 1 Data Model
  (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• Deliverables for this task
• A completed Data Model to include An ERD,
  showing all tables, related attributes, and the
  primary and foreign keys. This diagram must show
  both the relationship and cardinality of the
  relationship using accepted notation. A Data
  Dictionary (or meta data chart) showing a minimum
  of the table name, columns, data types, length,
  and constraints. Team member responsibilities
  document outlining contributions by team members
  to this deliverable.
• Related Tutorials

17
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 3 iLab 3 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• STEP 4 The SELECT statements The next step of
  the lab will be to create the select statements
  to verify the data was inserted correctly. You
  should have seven select statements one for each
  table. The command is SELECT FROM Table_Name
  For example, to select all columns from the
  Student table, the command would be SELECT FROM
  Student Be sure to save all of the above
  statements in your script file. STEP 5 Testing
  and verifying your script Now we come to the
  point of verifying that your script file works by
  creating all of the tables and inserting all of
  the data.

18
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 4 Group Project Task 2 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• DROP TABLE CUSTOMER CASCADE CONSTRAINTS PURGE
• After testing and verifying that all of your
  create statements work, create a spooled output
  file with the SET ECHO ON session command set so
  that your code and the results will show.
• Deliverables for this task
• Revisions of Task 1 (if any) based on feedback
  from your instructor. Task 2 comprised of the
  CREATE TABLE script file and the output file
  showing that it works. Team member
  responsibilities document outlining contributions
  by team members to this deliverable.
• Related Tutorials

19
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 4 iLab 4 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• L A B S T E P S STEP 1 Using the BOOKS table,
  write a query that will list the categories for
  the books in inventory. List each category only
  once in your result set. STEP 2 Using the BOOKS
  table, write a query that will list the title and
  publisher ID for each book in the table. Use the
  column heading of "Publisher ID" for the pubid
  field. STEP 3 Using the BOOKS table, write a
  query that will list the book title, retail
  price, and the amount of markup for each book.
  The amount of markup is the retail price minus
  the cost. Use the column heading Price Markup
  for the arithmetic expression column. STEP 4
  Using the BOOK_CUSTOMER table, write a query that
  will list the customers first name, last name,
  and city for those customers living in zip code
  31206.

20
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 5 Group Project Task 3 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• Task 3 - Verification of Logical Model(45 points)
• Develop the SQL statements to insert records into
  the database. You should ensure that the data in
  the database is sufficient to allow for each of
  the reports requested by Ms. Smith to be tested.
  You need to show a minimum of three insert
  queries for each database table that you have
  created. Some tables will obviously require more
  to ensure that all of the required data is in the
  database (i.e., the packages table, program
  table, etc). To submit this task, add a comment
  heading called INSERT STATEMENTS to your
  corrected SQL script from Task 2.

21
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 5 iLab 5 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• Lab 5 of 7 Retreiving data from Multiple Tables
  (28 points) Submit your assignment to the Dropbox
  located on the silver tab at the top of this
  page. For instructions on how to use the Dropbox,
  please click here. (See Syllabus/"Due Dates for
  Assignments Exams" for due dates.) L A B O V E
  R V I E W 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 write
  a query using either the TRADITIONAL method of
  joining tables or using the JOIN key word. In
  some cases, you will be asked to use a specific
  approach.

22
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 6 Group Project Task 4 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• Deliverables for this task
• Any revisions of task 3 based on feedback from
  your instructor. Task 4 comprised of the complete
  script file (DROP, CREATE, INSERT, SELECT, and
  UPDATE statements) and the output file showing
  that it works. Team member responsibilities
  document outlining contributions by team member
  to this deliverable.

23
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 6 iLab 6 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
• STEP 12 Back to top Using the BOOK_CUSTOMER
  table, write a sub query that will return the
  names of those customers who were referred by the
  same individual who referred Jorge Perez. Do not
  display Jorge Perezs name in the returned
  results (Hint you should only have two customers
  displayed and the exclusion for Jorge Perez must
  be associated with the upper query). STEP 13
  Back to top Using the BOOKS table, create a query
  using the correct functions to return the
  category name, total number books per category
  with a column alias of "Category Total", and the
  total cost of all the books per category with an
  alias of "Cost".

24
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 7 Group Project Task 5 (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• Create a heading of REPORTING STATEMENTS as a
  comment at the bottom of your group project
  database script file. Add the six report queries
  to this area. In instances where you are asked to
  allow for user input, please specify an
  appropriate value based upon the data in your
  script. For example, Report 1 is a DATE driven
  report therefore, you should use a single date
  in your WHERE clause to display the information.
  Task 5 is the final task for the project and is
  designed to demonstrate that you have adequately
  satisfied the requirements of the project. The
  following is what you are to submit for Task 5

25
CIS 336 PAPERS Learn by
Doing

• CIS 336 Week 7 iLab 7 Devry University (Devry)
• FOR MORE CLASSES VISIT
• www.cis336papers.com
•  
• STEP 7 Create a unique index on the combined
  columns ORDERID and CUSTOMERID in the BOOK_ORDER
  table. Give the index a name of BOOK_ORDER_IDX.
  STEP 8 Determine how many objects you currently
  own in your schema by querying the USER_OBJECTS
  view in the Data Dictionary. Your result set
  should list the different object types that you
  find and include a count by object type.

26
CIS 336 PAPERS
Learn by Doing