Question: 1- Why is it important to learn SQL? In which jobs you need to know SQL? 2A- What is the definition of DML and DDL?

1- Why is it important to learn SQL? In which jobs you need to know SQL?

2A- What is the definition of DML and DDL? Give examples in each case.

2B- Consider the following two tables below: VENDOR and PRODUCT.

Write a SQL statement for each of below:

a) Show all Vendor names, vendor phone numbers in VENDOR table

b) Show all products sold by Gomez Bros.

c) Show all products with a price of greater than $100.

VENDOR

PRODUCT

1- Why is it important to learn SQL? In which jobs you

The Subject name is Database Management System.

\begin{tabular}{|c|l|l|l|l|l|l|} \hline V_CODE & \multicolumn{1}{|c|}{ V_NAME } & V_CONTACT & V_AREACODE & V_PHONE & V_STATE & V_ORDER \\ \hline 21225 & Bryson, Inc. & Smithson & 615 & 2233234 & TN & Y \\ \hline 21226 & SuperLoo, lnc. & Flushing & 904 & 2158995 & FL & N \\ \hline 21231 & D\&E Supply & Singh & 615 & 2283245 & TN & Y \\ \hline 21344 & Gomez Bros. & Ortega & 615 & 8892546 & KY & N \\ \hline 22567 & Dome Supply & Smith & 901 & 6781419 & GA & N \\ \hline 23119 & Randsets Ltd. & Anderson & 901 & 6783998 & GA & Y \\ \hline 24004 & Brackman Bros. & Browning & 615 & 2281410 & TN & N \\ \hline 24288 & ORDVA, Inc. & Hakford & 615 & 8981234 & TN & Y \\ \hline 25443 & B\&K, Inc. & Smith & 904 & 2270093 & FL & N \\ \hline 25501 & Damal Supplies & Smythe & 615 & 8903529 & TN & N \\ \hline 25595 & Rubicon Systems & Orton & 904 & 4560092 & FL & Y \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Why is it important to learn SQL? In which jobs you need to know SQL? 2A- What is the definition of DML and DDL? Give examples in each case. 2B- Consider the following two tables below: VENDOR and...

2A- What is the definition of DML and DDL? Give examples in each case. 2B- Consider the following two tables below: VENDOR and PRODUCT. Write a SQL statement for each of below: a) Show all Vendor...

Topic: Business Organization & Management Rules: Please read the below study case first and then answer the following questions with new answers. No duplicated answers ! Questions List: 1. Based on...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Please read the question Question: Choose one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That is, what's the...

Please read the question Question: Choose another different one of the teaching strategies from the article that you read 1. What is the teacher is trying to accomplish by using this technique? (That...

Read the article: Global Impact of Organizational Ethics. We share a global marketplace that allows us the opportunity to expand our organizational boundaries. This can lead to increased profit...

There are three seating categories at a stadium. For a softball game, Class A seats cost $15, Class B seats cost $12, and Class C seats cost $9. Design a modular program that asks how many tickets...

A scale drawing of a building uses a scale of 1 : 20 a The height of the building on the drawing is 25 cm. What is the height, in metres, of the building in real life? b The length of the building in...

5. A force of 10 N applied to one end of a cord keeps an object tied to the other end moving at a speed of 2.0 m/s in a horizontal circle of radius 3.0 m. What is the mass of the object? A 1200-kg...