Organization of Data

Database: Magnet Supply Company Sales System

Here is the lab assignment:

Create a data dictionary for Magnet Supply Company Order System

Create a relational diagram for Magnet Supply Company Order System

Issue SQL select commands (see Getting Started lab) and answer the following questions: (answer the question but also provide SQL and result)

How many different job codes are available?

What is the job code for Linda Fickes?

What is/are the name(s) of the vendor(s) location in PA?

How many vendors are there?

What is the zip code for customer 1001?

What is the sale price for product 4010?

please and thank you