Cis/336 Ilab 1 of 7 - Sql Course

In: Computers and Technology

Submitted By unnekulsom
Words 941
Pages 4
HELPIDO.COM

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

www.helpido.com/cis336ilab-1-of-7/

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

CIS/336 iLab 1 of 7 - SQL Course

________________________________________
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. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for Order.

The following are the TABLE definitions for the first three tables showing the PRIMARY KEY constraints.
TABLE Customer has the following attributes

CustNo NUMBER(5)

CustFirstName…...

Similar Documents

Cis/336 Ilab 1 of 7 - Sql Course

...HELPIDO.COM -------------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-1-of-7/ -------------------------------------------------------- CIS/336 iLab 1 of 7 - SQL Course ________________________________________ 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. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer......

Words: 941 - Pages: 4

Cis/336 Ilab 1 of 7 - Sql Course

...HELPIDO.COM -------------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-1-of-7/ -------------------------------------------------------- CIS/336 iLab 1 of 7 - SQL Course ________________________________________ 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. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer......

Words: 941 - Pages: 4

Cis/336 Ilab 4 of 7 - Sql Course

...HELPIDO.COM ----------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-4-of-7/ ----------------------------------------------------- CIS/336 iLab 4 of 7 - SQL Course ________________________________________ Lab 4 of 7: Building the Physical Model 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. 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 clause. This includes the use of specific "wild card" characters which allow you to search for character or number patterns within the data. You can also perform mathematical expressions within the SELECT statement to create derived output. The ORDER BY clause allows you to sort the output data in either ascending (the default) or descending order.......

Words: 1407 - Pages: 6

Cis/336 Ilab 5 of 7 - Sql Course

...HELPIDO.COM ------------------------------------------------ Follow this link to get the tutorial www.helpido.com/cis336ilab5-of-7/ ------------------------------------------------ CIS/336 iLab 5 of 7 - SQL Course ________________________________________ Lab 5 of 7: Retreiving data from Multiple Tables (28 points) 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. 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 clause. This includes the use of specific "wild card" characters which allow you to search for character or number patterns within the data. You can also perform mathematical expressions within the SELECT statement to create derived output. The ORDER BY clause allows you to sort the output data in either ascending (the default) or descending order. Lab #5 will explore all of these applications of the SELECT statement. General Lab Information and Considerations This...

Words: 1573 - Pages: 7

Cis/336 Ilab 5 of 7 - Sql Course

...HELPIDO.COM ------------------------------------------------ Follow this link to get the tutorial www.helpido.com/cis336ilab5-of-7/ ------------------------------------------------ CIS/336 iLab 5 of 7 - SQL Course ________________________________________ Lab 5 of 7: Retreiving data from Multiple Tables (28 points) 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. 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 clause. This includes the use of specific "wild card" characters which allow you to search for character or number patterns within the data. You can also perform mathematical expressions within the SELECT statement to create derived output. The ORDER BY clause allows you to sort the output data in either ascending (the default) or descending order. Lab #5 will explore all of these applications of the SELECT statement. General Lab Information and Considerations This...

Words: 1573 - Pages: 7

Cis/336 Ilab 7 of 7 - Sql Course

...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 7 of 7 - Sql Course

...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 7 of 7 - Sql Course

...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 1 of 7 - Sql Course

...HELPIDO.COM -------------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-1-of-7/ -------------------------------------------------------- CIS/336 iLab 1 of 7 - SQL Course ________________________________________ 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. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer......

Words: 941 - Pages: 4

Cis/336 Ilab 7 of 7 - Sql Course

...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 7 of 7 - Sql Course

...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

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

...HELPIDO.COM ------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab7of7/ ------------------------------------------------- CIS336 CIS 336 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......

Words: 1105 - Pages: 5

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

...HELPIDO.COM ------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab7of7/ ------------------------------------------------- CIS336 CIS 336 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......

Words: 1105 - Pages: 5

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

...HELPIDO.COM -------------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-1-of-7/ -------------------------------------------------------- CIS 336 CIS336 CIS/336 iLab 1 of 7 - SQL Course ________________________________________ 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. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts......

Words: 944 - Pages: 4

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

...HELPIDO.COM -------------------------------------------------------- Follow this link to get the tutorial www.helpido.com/cis336ilab-1-of-7/ -------------------------------------------------------- CIS 336 CIS336 CIS/336 iLab 1 of 7 - SQL Course ________________________________________ 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. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts......

Words: 944 - Pages: 4

490 افلام تركي 2017 HD 6.3 ﺩﺭاﻣﺎ فيلم سيد النوارس 2017 مترجم اون لاين مشاهدة وتحميل فيلم الدراما سيد النوارس 2017 Martilarin Efendisi 2017 كامل اون لاين وتحميل مباشر بجودة... | June 30, 2018 | Last Message