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 “Mumbai” shall receive bonus of 10% of their total sales. Similarly, all of the salespeople who sell in “Calcutta”, receive a bonus of 8% and so on. Thus, the value for bonusPercent is completely dependent on the city in which the salesperson sells the insurance. As a database engineer, you are required to: a. Write 5 sample records for the given relation in tabular structure.

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

Related questions

Question

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 “Mumbai” shall receive bonus of 10% of their total sales. Similarly, all of the salespeople who sell in “Calcutta”, receive a bonus of 8% and so on. Thus, the value for bonusPercent is completely dependent on the city in which the salesperson sells the insurance.

As a database engineer, you are required to:

a. Write 5 sample records for the given relation in tabular structure.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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