In this CIS336 LAB 1 exercise, you will analyze a de-normalized data set presented in the form of a spreadsheet. You will next construct a series of dependency diagrams, transforming…
The CIS336 LAB 3 lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of…
CIS336 LAB 4 Lab 4 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. This lab will also introduce…
Lab 5 will introduce the concept of multi-table JOINS in order to work with data in two or more related tables simultaneously. This lab may be completed using either DeVry’s…
CIS336 Lab 1 Normal Forms and Entity Relationship Diagrams, CIS 336 Lab 2 The Expanded Entity Relationship Diagram, CIS336 Lab 3 Building the Physical, CIS336 Lab 4 Introduction to Select…
CIS336 Lab 7 Working with Views Lab 7 will introduce the concept of database views. This lab may be completed using either DeVry’s Omnymbus EDUPE-APP lab environment, or a local…