1. Create a database of salesman:a. Table Description:Salesman Number – Integer – Primary Key – Not NullSalesman Name – VarCharo Quarterly Sales – Real (Float)• Note: input of sales per quarter (1st, 2nd, 3rd, 4th)Total Sales - DoubleCommission – Real (Float)b. Compute the Total Salesc. Compute the Commission based on the following:Total Sales<= 5000<= 10000Commission10% of Total Sales15% of Total Sales<= 1500020% of Total Sales<= 20000> 20000d. Search a salesman (input must be Salesman Number), determine if the salesman isexisting in the database, otherwise update the record by inputting new values ofQuarterly Sales.e. Search a salesman (input must be Salesman Number), determine if the salesman isexisting in the database, otherwise delete the record.f. Display all the record of database.25% of Total Sales35% of Total Sales or 15000 whichever is higher

As per the requirement created a table. When we enter the record in a table at the starting…

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 System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Description The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +--- | Id | Name | Salary | ManagerId | +---- | 1 | 2 | 3 | 4 +---- | Joe | 70000 | 3 | Henry | 80000 | 4 | Sam | Max Given the Employee table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager. + | Employee | + | Joe + | 60000 | NULL | 90000 | NULL I
Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.
Database course: Write SQL queries to do the following A. List names of IT students. B. List titles of courses of type E. C. Display the results of student with ID 201006 D. List student names and the courses they took. E. List total credits that student with ID 201002.
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…
LAB DBI DATABASE
SQL Query For Given Problem
SQL knowledge question
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
SQL question help
se SQL program Server2014 ... A company undertakes a number of projects, the employees work on it, and during the process of analyzing the system we found the following points: The company is made up of a number of departments (the department number, which is a single number, the name of the department, the department's website) There are employees (the employee's number is a single number, his name, address, salary, and job) The employee belongs to one department only, and each department has more than one employee. There are projects (the project number, which is a single number, the name of the project, the project site) Each project has a specific department that it manages, and the department may manage it more than one project. More than one employee works in the project, and the employee may work in more than one project. Each employee has a number of work hours per week in each project. Required: 4. Create a Trigger that indicates the end of the entry operation on any of…
Database Systems SQL