Question: Create a database called sales and then, create the following tables with the appropriate data type for each column and inset data, you should apply

Create a database called sales and then, create the following tables with the appropriate data type for each column and inset data, you should apply the primary key and foreign key constraints. Not: you can use null to express the null values during inserting data. Salesman table: Customer table: 1. Find those salesmen with all information who gets the commission within a range of 12 and 14 ordered by the name. 2. Find the highest grade for each of the cities of the customers. 3. Find the name and city of those customers who are served by a salesman

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 Databases Questions!

questions on client_master table: 1. Retrieve the list of names and cities of all the clients 2. List all the clients who are located in Bombay 3. Display the information for client no 0001 and 0002...

Instructions Answer the following questions related to the Happy Cruise Lines company (refer to Minicase 1 on page 17). Each question should be answered using proper rules of grammar, punctuation,...

Please use SQL Server Management Studio to answer the following questions Using the above diagram answer the following questions: Write a script file that will create a database called Customer....

(LO 4-2, LO 4-3) Match the data example to its appropriate data type. Data Examples Primary key Foreign key ER (entity-relationship) diagrams Relational database diagrams Database Description A...

Computer Information system problem: Microsoft Access You must create an Access database called Brooklyn99RealEstate . You must the create following tables (Users, Buyers, Seller, Property, Feature)...

USING SQL DATA DEFINITION LANGUAGE TO CREATE TABLES, ALTER TABLES, INSERT RECORDS For this lab, ALL of the tasks will be done with SQL by creating SQL Scripts (queries) in the NEW SQL QUERY window....

ANSWER Q4, HAVE INCLUDED ALL PARTS FOR REFERENCE BUT JUST ANSWER QUESTION 4: SQL QUERIES Question 1 (5 Points): Creating the database: Create a database using your name. Then create the following...

rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name varchar(25) student last name major_id integer the ID of the...

Part A (10 marks) A University records the subject registration information of their students in a database named University.mdb , which contains three tables, STUDENT , SUBJECT and SUBJECT_REG . A...

Using Microsoft Access, create the following traffic ticket database with its associated tables, fields (including appropriate data type), primary keys and foreign keys. A traffic ticket is a notice...

The current assets of Exxon Mobil Corporation follow: $ millions 2014 2013 Current assets Cash and cash equivalents $13,068 $8,453 Notes and accounts receivable, less estimated doubtful amounts...

Hw A Border has L= 300 m w=5m Q = 18.6115 Si= 0.7% n=0.2 Infiltration equation D=st 2 mm Infiltration equation D=5 2 Mw 0.6 0.6 I minutes C minutes. X (m) 0 30 60 90 120 150 180 210 240 270 300 X...

Indicate the effect each separate transaction has on investing cash flows. Sold a truck costing $ 4 5 , 5 0 0 , with 2 3 , 8 0 0 of accumulated deprivation, for $ 9 8 0 0 cash. the sale results in a...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+10. How are inflation and unemployment related in the short run?

=+ 7. Explain the two main causes of market failure and give an example of each.

=+8. Why is productivity important?