Cis 336 All Ilabs Week 1 To Week 7 Devry University

Front 1

CIS 336 All iLabs Week 1 to Week 7 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-all-ilabs-week-1-to-week-7-devry-university/

Back 1

CIS 336 All iLabs Week 1 to Week 7 Devry University

Front 2

CIS 336 Week 1 iLab 1 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-1-ilab-1-devry-university/

Back 2

L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, or unique identifier. Once you have decided the primary key of the relationship, you have identified the "one" side of the relationship. Note that for an RD, the foreign key "many" side of the relationship points to the primary key "one" side. The "one" side should have the arrowhead point of the connecting line. This is different than an entity/relationship diagram (ERD) that we will draw next week, where the "many" side has crow's feet. This will familiarize you with how to set up MS Visio to draw database diagrams.

Front 3

CIS 336 Week 2 iLab 2 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-2-ilab-2-devry-university/

Back 3

Lab two introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be given a business scenario for a company named Clapham Specialty Store, which is a small specialist grocery and delicatessen. The business specifications will outline a number of things about the business, some of which will apply directly to the database you are being asked to model. There is a table which lists the entities (tables) that will be needed for the database and related attributes (columns) for each entity. There is also a column that lists specific information about the entity that will be helpful in determining its relationship to other entities within the model. Be sure to include the minimum and maximum occurrences of each relationship (cardinality) and to supply a name to the relationship that will work in both directions. If there is not a single word that will apply, then supply a separate name for each direction of the relationship. Narrative/Case Study The

Front 4

CIS 336 Week 3 Group Project Task 1 Data Model

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-3-group-project-task-1-data-model/

Back 4

Present a detailed data model for the project scenario. You can create your data model using Microsoft Visio, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e. I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary).

A key component to every task submission is the team responsibilities document. This document should outline the contributions that each member of the team made to completing the task deliverable. There is a sample document in the Doc Sharing tab that can be used, or each team can come up with their own design. As stated in the syllabus, although this is a team project, each member will also be graded on their involvement in the project. This assessment needs to be honest and accurate in describing the individu

Front 5

CIS 336 Week 3 iLab 3 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-3-ilab-3-devry-university/

Back 5

Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in Oracle itself. The editor interface to the Oracle server is SQL*Plus, and 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. Before attempting Lab #3, you need to be sure you have read through the SQL*Plus tutorial which can be found in Doc Sharing as well as under the SQL*Plus Tutorial tab in Week 3. This tutorial describes the functionality of the editor and will take you through the process of setting up and using the SQL*Plus in the iLab environment so that it will best serve your needs for the remainder of the labs required for this course. The lab for this week addresses taking a logical database design (data model) an

Front 6

CIS 336 Week 4 Group Project Task 2

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-4-group-project-task-2/

Back 6

Task 2 - Logical Model (30 points)

Using the Oracle SQL*Plus editor, develop a database for MiniQuest based on your data model. The database should contain all the tables and attributes discussed in the project specifications. Be sure to use your data dictionary when creating your tables.

A key component to every task submission is the team responsibilities document. This document should outline the contributions that each member of the team made to completing the task deliverable. To submit this task, you need to create a file in notepad called TEAM_X_TASK2.TXT, where X is your team identifier. For example, Team A would name the file TEAM_A_TASK2.TXT. In this file, create a heading called CREATE STATEMENTS, and then develop the CREATE TABLE statements required to create your database tables. Be sure to include the DROP TABLE statements at the top of your file so that you can reuse the file. If you include the wording CASCADE CONSTRAINTS as part of each DROP TABLE statement, then the

Front 7

CIS 336 Week 4 iLab 4 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-4-ilab-4-devry-university/

Back 7

Lab 4 of 7: Building the Physical Model (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 #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 set of tables found in the script file (LeeBooks.sql) found in the Doc Sharing area of the website. You will need to download the file, then run the script in your SQL*Plus session. These tables will be used for the remaining labs in this class. The SELECT statement is the primary means of extracting data from database tables, and allows you to determine exactly which data you want to extract by means of different comparison operators used in the WHERE

Front 8

CIS 336 Week 5 Group Project Task 3

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-5-group-project-task-3/

Back 8

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. Add your INSERT statements for each table after this heading. Keep in mind that you will need to insert data into the tables in the same order that the tables were created. This will minimize any integrity constraint errors you might encounter. Keep in mind also that any values being inserted into a field defined as a foreign key field must first exist in a previous table’s primary key field. Sa

Front 9

CIS 336 Week 5 iLab 5 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-5-ilab-5-devry-university/

Back 9

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. Using the incorrect process when the process is specified will result in points being taken off for that problem.

Front 10

CIS 336 Week 6 Group Project Task 4

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-6-group-project-task-4/

Back 10

Task 4 - Verification of Transaction Processing (30 points)

Develop a query that will identify and mark inactive those customers that have bills overdue by more than 30 days (this can usually be done using a sub-query). Remember, you are only marking a customer as inactive, not actually deleting the customer record from the system.

To submit this task, create a heading called MODIFY STATEMENTS in your group project SQL script, and name the file TEAM_X_TASK4.TXT. This should be the same script that contains your DROP TABLE, CREATE TABLE, and INSERT statements. Once you have verified that your SQL statement or statements work, create a spooled output showing the results of your statements.

Deliverables for this task:

Front 11

CIS 336 Week 6 iLab 6 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-6-ilab-6-devry-university/

Back 11

Week 6. L A B S T E P S STEP 1: Back to top Using the BOOK_CUSTOMER table and the NVL function, create a query that will return a list containing the customer number, first name, last name, and the characters ‘NOT REFERRED’ if the customer was not referred by another customer. Give the derived column an alias of REFERRED BY. Do not list any customers that were referred by another customer. STEP 2: Back to top Using the BOOKS table and the SUBSTR function, create a query that will return a list of book ISBN codes and the book title for all the computer books. Format the ISBN code to display as 9-999-99999-9 (e.g., 1059831198 would display as 1-059-83119-8) STEP 3: Back to top Using the BOOKS table, create a query using the correct functions to return the category name, the total retail of all books per category with a column alias of "Total Retail",

Front 12

CIS 336 Week 7 Group Project Task 5

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-7-group-project-task-5/

Back 12

Develop the queries to support each of the reports that are required by Ms. Smith. It is expected that the information returned by the queries is adequate to be used in the reporting process. Make sure your output contains enough information! The following is a recommendation and the MINIMUM amount of data you should have access to:

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 (your program guide should have enough programs for various channels to support the program guide report) Other tables: A sufficient amount of data to support the above when reports are run

Front 13

CIS 336 Week 7 iLab 7 Devry University

Copy the link to get this tutorial:

http://www.homeworkmade.com/cis-336/cis-336-week-7-ilab-7-devry-university/

Back 13

L A B O V E R V I E W Scenario/Summary There is a lot more to a database than just tables and the data in them. A very important part of database security has to do with using and understanding Database Views. Being able to enhance the efficiency of the database tables by using additional indexes is also a very important aspect of database development. Finally, being able to create and use Database Sequences to automate some of the sequential processes in the database can not only save time but improve efficiency. In Lab 7, you will have a chance to work with all three of these areas. General Lab Information and Considerations This lab will utilize the same set of tables found in the script file (LeeBooks.SQL) that were used for Labs 4 through 6. Each query in the script file you will create, must be numbered (use either –1 or REM 1 comments for numbering) and in order.