# CIS 336 Tutorials / cis336dotcom

## CIS 336 Tutorials / cis336dotcom

CIS 336 Entire Course: Devry University (Devry)

For more course tutorials visit
www.cis336.com

CIS 336 Entire Course: Devry University
..............................................................................................................................................................................
CIS 336: All iLabs Week 1 to Week 7: Devry University (Devry)

For more course tutorials visit
www.cis336.com

CIS 336: All iLabs Week 1 to Week 7: Devry University
..............................................................................................................................................................................
CIS 336 Week 1 iLab 1 Devry University (Devry)

For more course tutorials visit
www.cis336.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. When finished you should have a total of 5 tables represented in your diagram for this problem. To copy and paste the diagram into Word, select Edit from the menu and then Copy Diagram. Open a Word document and use CTRL-V to paste the diagram. TABLE Product has the following attributes ProdNo CHAR(8) ProdName VARCHAR2(20) ProdNo is the PRIMARY KEY TABLE OrdLine has the following attributes OrdNo CHAR(8) ProdNo CHAR(8) Qty NUMBER(5) The combination of OrdNo and Prodno is the PRIMARY KEY ....