HomeworkLib
Question

Please help me answer the following. Database Management System please No handwriting thank you Consider the...

Please help me answer the following.

Database Management System
please No handwriting

thank you

Consider the following two tables:

Sales (SID, VID, Commission)
Sales_Person (SalesPersonID, SName, STitle, SPhone,
Sum_Commission)


-   Using Oracle notation, write a trigger that allows to keep the Sum_Commission attribute of Sales_Person equal to the sum of the Commission attribute in Sales for each sales person.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

BELOW IS THE QUERIES OF SALES PERSON AND THE FUNCTIONS ABOVE.

select s.SID, s.VID, s.Commission, p.SalesPersonID, p.SName, p.STitle, p.SPhone from sales s INNER JOIN Sales_Person p ON p.Sum_Commission = sum(s.Commission) GROUP BY s.VID;

if you have any query contact me THUMBS UP!

0 0
Add a comment
Know the answer?
Add Answer to:
Please help me answer the following. Database Management System please No handwriting thank you Consider the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Database Management System please No handwriting thank you Discuss in your own words what is meant...

    Database Management System please No handwriting thank you Discuss in your own words what is meant by client/server architecture

  • Please help me answer the following. Computer Networks please No handwriting thank you please No handwriting...

    Please help me answer the following. Computer Networks please No handwriting thank you please No handwriting A transport-layer protocol provides two types of services: connectionless and connection-oriented. Define both of these services in your own words.

  • Please help me to solve Please, No handwriting COURSE; introduction to database Q- write a query ...

    Please help me to solve Please, No handwriting COURSE; introduction to database Q- write a query SQL by Using the info below A. Normalize the Tables (in 3NF at least) B. Create the Normalized Tables and Populate them with at least 5 Rows C. Write the Wholesale Management System requested Queries & Execute them VERY IMPORTANT Screenshots from MySQL (or any other software you use) of all the tables after queries result. - Database system for a Wholesale Management System...

  • Please HELP, THANK YOU SO MUCH Consider the below schema of the university database (keys are...

    Please HELP, THANK YOU SO MUCH Consider the below schema of the university database (keys are in bold and underline) Part(pid: string, pname: string, description: string, color: string) Department(did: string, dnamestring, address: string) Supplier(sid string,.sname:string, address:string) Order(did:string. sid string pidstring, time:string, quantityreal, pricereal) The key fields are underlined, and the domain of each field is listed after the field name. Thus pid is the key for Part, did is the key for Department, sid is the key for Supplier, and...

  • Hi there, Could you please help me with the following? 1- Weaknesses of Microsoft SQL Server...

    Hi there, Could you please help me with the following? 1- Weaknesses of Microsoft SQL Server Benefits 2- Weaknesses of Oracle Cloud Database 3- Weaknesses of MySQL Thank you

  • Please help me answer these Questions. (with clear details and handwriting, if possible) Thank you so...

    Please help me answer these Questions. (with clear details and handwriting, if possible) Thank you so much, to those who help me solve these questions. I really appreciate it! Have a wonderful day! The following information is given for The Market Place on September 30, 19X4. $14,630 10,921 2,160 Cash book balance Cash bank balance Outstanding checks Service charges Interest on checking NSF check Deposits in transit 38 54 401 6,345 Book error - recorded a deposit for cash sales...

  • Please help me answer all of the questions. (Please with clear handwriting and explanations.) Thank you to anyone...

    Please help me answer all of the questions. (Please with clear handwriting and explanations.) Thank you to anyone who can Help, really appreciate it! Have a wonderful day. Kegin Company sells many products, y sells many products. Whamo is one of its popular items. Below is an analysis d hory purchases and sales of Whamo for the month of March. Kegin Company uses the periodic Inventory system. Sales Selling Price Unlt Units Purchases Unit Cost $40 Units 3/1 3/3 100...

  • This is third time im posting this Question COURSE; introduction to database Please, No handwriting thanks...

    This is third time im posting this Question COURSE; introduction to database Please, No handwriting thanks for your efforts Design the database by following . Execute the sample requested queries. . ER Diagram. . All schemas before and after normalization. . All SQL statements of: -Creating tables. - Inserting data in tables. -Queries. 5. Screenshots from MySQL (or any other software you use) Question is - Database system for a Wholesale Management System Consider a database system for a Wholesale...

  • Please Use your keyboard (Don't use handwriting) Thank you.. HW 2: Following Transactions Occurred at Ali...

    Please Use your keyboard (Don't use handwriting) Thank you.. HW 2: Following Transactions Occurred at Ali Company during 2017: - 111 bought 15000 Share from Al Nasr Share by $100 Per Share , Broker Commission was 0.22%, Which Number Were 200000 Share - 114 Sold 4000 Share from Al Nasr Share by $76, Broker Commission was 0.20%. I Sold 2000 Share from Al Nasr Share by $118. Broker Commission was 0.22% 31/12 Al Nasr Share at Exchange Commission Realized 92...

  • Can someone please help me solve the following database management question a - d please help...

    Can someone please help me solve the following database management question a - d please help uestion-4 The relational database schema of Question-3 is reproduced here. COURSE (NUMBER, TITLE, ENROLLED) RANK-1 (CNUMBER, R1-SSN) RANK-2 (CNUMBER, R2-SSN) TALLEST (CNUMBER, TALL-SSN) STUDENT (SSN, NAME, MAJOR, SEX, GPA) Formulate the following queries in soL. (30] (a) List the course numbers in which "Jack Hernandez" is the first ranked student. You are not allowed to use any JOIN operation and your answer must be...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT