Organization of Data Database: Magnet Supply Company Sales System Here is the la

Question

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?<br

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

Explanation / Answer

Since you haven't provided a lot of information regarding the schema I'll be unable to make a data dictionary and relational diagram. Also I would be using the t for the generic table which you would need to replace by the proper table name to get an appropriate result in SQL.

Different job codes- select job_code from t;

Job code for Linda Fickes- select job_code from t where name="Linda Fickes";

Assuming I have to find the vendor's name where the location is PA- select name_vendor from t where location="PA";

Number of vendors- select count(distinct vendors) from t;

Zip code for customer 1001- select zip_code from t where customer_no=1001;

Sale price for product 4010- select sale_price where product_id=4010;

All these are very generic queries and you need to replace all the variable and table names by appropriate names.

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.