![[NEW SOLN] CIS336 LAB 1 NORMAL FORMS AND ENTITY RELATIONSHIP DIAGRAMS](https://grademerit.com/wp-content/uploads/edd/2023/11/Screenshot-2023-11-13-at-14.44.40.png)
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…
![[NEW SOLN] CIS336 LAB 3 BUILDING THE PHYSICAL](https://grademerit.com/wp-content/uploads/edd/2023/11/Screenshot-2023-11-13-at-14.22.51.png)
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…
![[NEW SOL] CIS336 LAB 4 INTRODUCTION TO SELECT INSERT UPDATE AND DELETE STATEMENTS](https://grademerit.com/wp-content/uploads/edd/2023/11/Screenshot-2023-11-13-at-14.09.45.png)
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…
![[NEW SOLN] CIS336 LAB 7 WORKING WITH VIEWS](https://grademerit.com/wp-content/uploads/edd/2023/11/Screenshot-2023-11-12-at-15.14.29.png)
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…
![[NEW SOLN] CIS336 LAB 2 THE EXPANDED ENTITY RELATIONSHIP DIAGRAM](https://grademerit.com/wp-content/uploads/edd/2023/11/Screenshot-2023-11-13-at-14.38.44.png)