CIS 336 Entire Course

CIS336 Entire Course includes: 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 Insert Update and Delete Statements CIS336… Read More

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 copy of the MySQL database running on your own computer using the OM database tables. The… Read More

CIS336 Lab 6 Group Functions and Subqueries

Lab 6 will introduce the concept of group functions and subqueries to meet more complex report requirements. This lab may be completed using either DeVry’s Omnymbus EDUPE-APP lab environment, or a local copy of the MySQL database running on your… Read More

CIS336 Lab 5 Joining Tables

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 Omnymbus EDUPE-APP lab environment, or a local copy of the… Read More

CIS336 Lab 3 Building the Physical

The 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 the lab, you will need to download the zip file titled CIS336Lab3Files from… Read More

CIS336 Lab 2 The Expanded Entity Relationship Diagram

This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be given a business scenario for a University Medical Center, which is a small community hospital. The business specifications will outline a… Read More