Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Create a database of salesman: a. Table Description: o Salesman Number – Integer - Primary Key – Not Null o Salesman Name – VarChar o Quarterly Sales – Real (Float) Note: input of sales per quarter (1s, 2nd, 3rd, 4th) o Total Sales - Double o Commission – Real (Float) b. Compute the Total Sales c. Compute the Commission based on the following: Total Sales <= 5000 <= 10000 Commission 10% of Total Sales 15% of Total Sales <= 15000 20% of Total Sales 25% of Total Sales <= 20000 > 20000 35% of Total Sales or 15000 whichever is higher

Create a database of salesman: a. Table Description: o Salesman Number – Integer - Primary Key – Not Null o Salesman Name – VarChar o Quarterly Sales – Real (Float) Note: input of sales per quarter (1s, 2nd, 3rd, 4th) o Total Sales - Double o Commission – Real (Float) b. Compute the Total Sales c. Compute the Commission based on the following: Total Sales <= 5000 <= 10000 Commission 10% of Total Sales 15% of Total Sales <= 15000 20% of Total Sales 25% of Total Sales <= 20000 > 20000 35% of Total Sales or 15000 whichever is higher

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 97C: The following tables provide a very small portion of the data that will be kept in the database....
See similar textbooks
icon
Related questions
Question
100%
1. Create a database of salesman: a. Table Description: Salesman Number – Integer – Primary Key – Not Null Salesman Name – VarChar o Quarterly Sales – Real (Float) • Note: input of sales per quarter (1st, 2nd, 3rd, 4th) Total Sales - Double Commission – Real (Float) b. Compute the Total Sales c. Compute the Commission based on the following: Total Sales <= 5000 <= 10000 Commission 10% of Total Sales 15% of Total Sales <= 15000 20% of Total Sales <= 20000 > 20000 d. Search a salesman (input must be Salesman Number), determine if the salesman is existing in the database, otherwise update the record by inputting new values of Quarterly Sales. e. Search a salesman (input must be Salesman Number), determine if the salesman is existing in the database, otherwise delete the record. f. Display all the record of database. 25% of Total Sales 35% of Total Sales or 15000 whichever is higher
Transcribed Image Text:1. Create a database of salesman: a. Table Description: Salesman Number – Integer – Primary Key – Not Null Salesman Name – VarChar o Quarterly Sales – Real (Float) • Note: input of sales per quarter (1st, 2nd, 3rd, 4th) Total Sales - Double Commission – Real (Float) b. Compute the Total Sales c. Compute the Commission based on the following: Total Sales <= 5000 <= 10000 Commission 10% of Total Sales 15% of Total Sales <= 15000 20% of Total Sales <= 20000 > 20000 d. Search a salesman (input must be Salesman Number), determine if the salesman is existing in the database, otherwise update the record by inputting new values of Quarterly Sales. e. Search a salesman (input must be Salesman Number), determine if the salesman is existing in the database, otherwise delete the record. f. Display all the record of database. 25% of Total Sales 35% of Total Sales or 15000 whichever is higher
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Dataset
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS