Cis336: All Ilabs Week 1 to Week 7: Devry University

CIS 336 All iLabs week 1 to Week 7 Devry University
reduplicate and paste this link to get the tutorial: http://homeworkfox.com/tutorials/general-questions/4159/cis-336-all-ilabs-week-1-to-week-7-devry-university/

CIS 336 Week 1 iLab 1 Devry University


|L A B O V E R V I E W | |


 
|Scenario/Summary |


This lab will introduce you to the processes mixed in defining one of the tonality components of a selective information model; the relationship diagram (RD). In this lab, you will lam a relationship diagram for two of the steps shown. note in mind when you atomic number 18 trying to decide which positioning of the relationship should be the one side and which should be the numerous that you must first decide which side has the primary observe, 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 external key numerous 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 crows feet.
This will familiarize you with how to set up MS Visio to draw database diagrams. Steps 1 - 3 below intention the Customer, Order, and Employee disconcerts of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts roughly 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 covering the PRIMARY KEY constraints.
|TABLE Customer has the following attributes |
| |
|CustNo...If you privation to get a full essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper