Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
INSTRUCTIONS: 3. The paper contain total 10 tasks. b. Compile both running query and output sereen shot in a single word file with proper numbering
INSTRUCTIONS: 3. The paper contain total 10 tasks. b. Compile both running query and output sereen shot in a single word file with proper numbering of c. File must be named with your name and roll number (C-g. ABX_roll) d. Upload the task file at LMS. c. Any kind of cheating will disqualify the student and will result in 100% negative marking. task. Consider a company named XYZ has a team of salesmen belonging from different states and working in different cities of Pakistan. Company wants to maintain a database for these salesman in a following manner: City Sman_10 Sman_Name 501 Kashif Karachi 502 Lahore Rehan Mustafa State Pincode Sal_Amount Remarks Sindh 40002 4000 Good Punjab 40001 3000 Average Punjab 40032 5000 Outstanding Balochistan 40044 2500 Below Average KPK 40052 4000 Good 503 Faisalabad 504 Farrukh Quetta 505 Adil Peshawar a As a Database Administrator you need to perform the following task: 1) Create a table Salesman, with all the entries as shown in above table. Set "Pincode" as primary key. [9-Marks] 2) Using constraint concept, display all the states from where company has hired salesmen. [3-Marks] 3) List the complete record of all the salesmen from "Punjab" state and "Sindh" state. [3-Marks) 4) Determine the minimum and maximum salary of the salesman. Also change the Sal Amount to salary. [3-Marks) 5) Determine the number of salary packages company is offering for the salesman post. [3-Marks) 6) Display the salesman name with their given remarks in the format: Kashif - Good [3-Marks] 7) Add a new column named Bonus after the Remarks column and convert it in upper case. [3-Marks] 8) Calculate the sum and average of the salary company is paying to all salesman. [3-Marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started