Cis 336 Ilab 2 of 7

In: Computers and Technology

Submitted By alexmicane
Words 1464
Pages 6
HELPIDO.COM

-----------------------------------------------------
Follow this link to get the tutorial

www.helpido.com/cis336ilab2/

-------------------------------------------------------

CIS/336 iLab 2 of 7 - SQL Course
________________________________________
L A B O V E R V I E W

Scenario/Summary

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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its profits, has recently purchased the store. The store sells general groceries, wines and liquors, and has a small deli counter. The store is open from 5:00 a.m. to 12:00 midnight. Many of the customers are repeat customers who come in to buy products they forgot from their regular grocery shopping expedition at the supermarket.

The store sells about 3,000 different products ranging from toilet…...

Similar Documents

Cis336,Cis/336,Cis 336,Cis/336 Ilab 2 of 7,Cis336 Ilab 2 of 7,Cis 336 Ilab 2 of 7

...HELPIDO.COM FOLLOW THIS LINK TO GET THE TUTORIAL ---------------------------------------------------- http://helpido.com/category/cis-336/ ---------------------------------------------------- cis 336 CIS/336 iLab 6 of 7 – SQL Course Oracle Single Row and Group Functions L A B O V E R V I E W Scenario/Summary Lab #6 will introduce the various aspects of the Single-Row and Group Functions available in the Oracle Database. Most functions can be used in either the SELECT statement or the WHERE clause, but more commonly are used in the SELECT. Chapters 5 and 6 cover most all of the normal processing you use in these functions. In some cases, you will be asked to used more than one function within a single SELECT statement. 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 and 5. Each query in the script file you will create must be numbered (use –1 comments for numbering) and in order. The SQL for the following exercises should be written using notepad and run in SQL*Plus. Read each problem carefully and follow the directions as stated. A Clean Script File: A script file is meant to be like a program. The file can be run every time the code needs to be executed without having to retype the code again each time. For this reason, it is important that there are no errors in the code inside the file. You can go back and forth......

Words: 1737 - Pages: 7

Cis336,Cis/336,Cis 336,Cis/336 Ilab 2 of 7,Cis336 Ilab 2 of 7,Cis 336 Ilab 2 of 7

...HELPIDO.COM FOLLOW THIS LINK TO GET THE TUTORIAL ---------------------------------------------------- http://helpido.com/category/cis-336/ ---------------------------------------------------- CIS 336 CIS/336 iLab 2 of 7 – SQL Course L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its profits, has recently purchased the......

Words: 1473 - Pages: 6

Cis 336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its......

Words: 1464 - Pages: 6

Cis 336 Ilab 7 of 7

...HELPIDO.COM ------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab7of7/ ------------------------------------------------- CIS/336 iLab 7 of 7 - SQL Course ________________________________________ 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. The SQL for the following exercises should be written using notepad and run in SQL*Plus. Read each problem carefully and follow the directions as stated. A Clean Script File: A script file is meant to be like a program. The file can be run every time the code needs to be executed without having to retype the code again each time. For this......

Words: 1102 - Pages: 5

Cis/336 Ilab 2 of 7 - Sql Course

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its profits, has recently......

Words: 1464 - Pages: 6

Cis/336 Ilab 2 of 7 - Sql Course

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its......

Words: 1464 - Pages: 6

Cis/336 Ilab 2 of 7 - Sql Course

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its......

Words: 1464 - Pages: 6

Cis/336 Ilab 2 of 7 - Sql Course

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and improve its......

Words: 1464 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7 - Sql Course

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

Cis336 Cis 336 Cis/336 Ilab 2 of 7

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab2/ ------------------------------------------------------- CIS336 CIS 336 CIS/336 iLab 2 of 7 - SQL Course ________________________________________ L A B O V E R V I E W Scenario/Summary 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 Clapham Specialty Store is a small, specialist grocery and delicatessen. A new owner, John Balfour, who would like to expand the store and......

Words: 1467 - Pages: 6

[ Zobacz cały opis... ] | Utilitaires | Eli Stone