CIS 336 Final Exam 4
For more course tutorials visit
www.devrycart.com
1. (TCO 7) For every order, list the order number, order date, part number, part description, and item class for each part that makes up the order.
2. (TCO 8) Write a query that will display the customer number, last name, and first name for every customer I whose first name begins with the letter "D".
3. (TCO 8) Write a query that will display the earliest date an order was placed.
4. (TCO 7) Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.
5. (TCO 7) Write a query that will list the customer first and last name and the sales rep commission rate using JOIN ON.
---------------------------------------------------------------------------------------------------------------------------------------------------------
CIS 336 Week 1 iLab 1 Devry University
For more course tutorials visit
www.devrycart.com
L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD).
In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, 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 foreign key "many" 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 crow's feet.
This will familiarize you with how to set up MS Visio to draw database...