1 / 14

CIS 336 DEVRY Course Material - cis336dotcom

CIS 336 is an online course which provides you to get best results.

Nazeer99
Télécharger la présentation

CIS 336 DEVRY Course Material - cis336dotcom

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CIS 336 DEVRY Course Material - cis336dotcom

  2. CIS 336 DEVRY Course Material CIS 336 Entire Course CIS 336 Final Exam 1 (Devry) • CIS 336 Entire Course: Devry University • 9. (TCO 10) Which command will grant a system privilege to a user? (Points : 4) • GRANT systemprivilegeUSERNAMEusernameGRANT PRIVILEGE systemprivilegeTOusernameGRANT systemprivilegeTOusername GRANT systemprivilege ONusername

  3. CIS 336 DEVRY Course Material CIS 336 Final Exam 2 (Devry) CIS 336 Final Exam 3 (Devry) • 5. (TCO 6) Write the SQL statement that will remove the database table EMPLOYEE. (Points : 15) • 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. • 9. (TCO 7) Write a query that will list the customer number, last name, and first name for every customer represented by sales rep 03 or sales rep 12. • 10. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.

  4. CIS 336 DEVRY Course Material CIS 336 Final Exam 4 (Devry) CIS 336 Final Exam 4 Sets of Answers (Devry) • 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. • CIS 336 Final Exam 4 Sets of Answers

  5. CIS 336 DEVRY Course Material CIS 336 All iLabs Week 1 to Week 7 Devry University (Devry) CIS 336 Quiz 1 (Devry) • CIS 336: All iLabs Week 1 to Week 7: Devry University • (TCO 4) The SQL command that lets you save your work to disk, is ___________ • (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?(TCO 3) Explain under what circumstances a partial dependency can exist in a database.

  6. CIS 336 DEVRY Course Material CIS 336 Quiz 2 (Devry) CIS 336 Quiz 3 (Devry) • (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 • TCO 7) You want to write a query that will return the customer number, first and last name from the bookordertable (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.

  7. CIS 336 DEVRY Course Material CIS 336 Quiz 4 (Devry) CIS 336 Quiz 5 (Devry) • (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.(TCO 7) Explain the difference between an inner join and an outer join. • (TCO 9) Based on the contents of the PROMOTION table, which of the following commands will delete only the row for the Free Bookmark from the table?(TCO 8) In using group functions we cannot place a group function in a WHERE clause. Explain how the WHERE clause and HAVING clause similar and why you can use the HAVING with a group function but not a WHERE clause.

  8. CIS 336 DEVRY Course Material CIS 336 Week 1 iLab 1 Devry University (Devry) CIS 336 Week 2 iLab 2 Devry University (Devry) • 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. • L A B S T E P S • 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.

  9. CIS 336 DEVRY Course Material CIS 336 Week 3 Group Project Task 1 Data Model (Devry) CIS 336 Week 3 iLab 3 Devry University (Devry) • 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. • 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;

  10. CIS 336 DEVRY Course Material CIS 336 Week 4 Group Project Task 2 (Devry) CIS 336 Week 4 iLab 4 Devry University (Devry) • 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. • STEP 7: Using the BOOK_CUSTOMER table, write a query using the AND and OR operators that will list the customer information for those customers living in either Florida or New Jersey who have not been referred by another customer. STEP 8: Using the BOOKS table, write a query that will list all information about those books that are not computer books and do not cost more than $30.00 retail.

  11. CIS 336 DEVRY Course Material CIS 336 Week 5 Group Project Task 3 (Devry) CIS 336 Week 5 iLab 5 Devry University (Devry) • Deliverables for this task: • Any revisions of task 2 based on feedback from your instructor. Task 3 comprised of the script file containing DROP TABLE, CREATE TABLE, and INSERT statements, and the output file showing that it works. Team member responsibilities document outlining contributions by team members to this deliverable. • STEP 11: Using the BOOK_CUSTOMER, BOOK_ORDER, ORDER_ITEMS, and BOOKS tables, create a query using traditional join conditions based on comparisons between primary and foreign keys that will list the customer number, first and last name, and book title. Limit your listing to only those books in the ‘FITNESS’ category.

  12. CIS 336 DEVRY Course Material CIS 336 Week 6 Group Project Task 4 (Devry) CIS 336 Week 6 iLab 6 Devry University (Devry) • 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. • STEP 6: Back to top Using the correct tables, create a sub query using either join operation you wish that will list the customer number, first and last name concatenated together, and city for all customers who have placed an order for the most expensive book (based on retail price). Give the combined customer names column and alias of "Customer Name".

  13. CIS 336 DEVRY Course Material CIS 336 Week 7 Group Project Task 5 (Devry) CIS 336 Week 7 iLab 7 Devry University (Devry) • Customer Table: A minimum of 12 customers (this will allow several channels to have more than one customer selecting it as a favorite channel) Billing Table: Records to support the above customers Program Table: A minimum of 25 programs Other tables: A sufficient amount of data to support the above when reports are run • 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.

  14. CIS 336 DEVRY Course Material To make excellent academic records.., Keep following our site!!!

More Related