2- Suppose the fallowing information about some product in a cloths markets , wherethere are two discount offer (ai jag) , that depend on prod_type , write a suitableformula find the new price , note : new price=old price +(discount rate 8 old price )A1dis1=-15%dis2=-20%23 prod_type price $ new price$ 34.00$ 23.00$ 56.00$ 67.00$ 56.0041?6?7?1?91- Find the new price where the discount value depending on prod_type as fallow :Prod_type= 1> disl , prod_type=2 →dis22- find the sum of all new price3- find the number of prod_type 1 and newprice >=30 $4- Find the average of price for prod_type 25- find the second largest new price212r

The question is on finding the excel formula for the given questions. As it is a multipart question,…

2- Suppose the fallowing information about some product in a cloths markets , where there are two discount offer (asasl a) , that depend on prod_type , write a suitable formula find the new price , note : new price-old price +(discount rate 8 old price ) B dis1= -15% dis2= -20% 3 prod_type price $ new price $ 34.00 $ 23.00 $ 56.00 $ 67.00 $ 56.00 1 1- Find the new price where the discount value depending on prod_type as fallow : Prod_type= 1> disl ,prod_type=2 >dis2 2- find the sum of all new price 3- find the number of prod_type 1 and newprice >=30 $ 456 789

2- Suppose the fallowing information about some product in a cloths markets , where there are two discount offer (asasl a) , that depend on prod_type , write a suitable formula find the new price , note : new price-old price +(discount rate 8 old price ) B dis1= -15% dis2= -20% 3 prod_type price $ new price $ 34.00 $ 23.00 $ 56.00 $ 67.00 $ 56.00 1 1- Find the new price where the discount value depending on prod_type as fallow : Prod_type= 1> disl ,prod_type=2 >dis2 2- find the sum of all new price 3- find the number of prod_type 1 and newprice >=30 $ 456 789

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

Given the business rule "An employee may have many degrees." Suppose that an employee has the following degrees. BA, BS, MBA, etc. These degrees could be stored in a single string as a multivalued attribute name EMP_DEGREE in an EMPLOYEE table such as the one shown below: EMP_NUM EMP_LNAME EMP_DEGREE 123 Carter BA, BS, MBA 124 Smith BBA, MBA 125 Jones AS 126 Doe BS, MS, PhD. This design is flawed, so correct it by creating additional table(s) and attributes(s) and show the relationships between them. Show all the data above in your table(s). Add additional data if new attributes were added. Show primary and foreign keys in your table(s).
The following statement tells the decomposition of the people survived a.k.a column Survived as of 0 (not survived) or 1 (survived). Create a similar statement using groupby function to further breakdown by Sex. In other words, add additional sex dimension. The desired output should be similar to the following: Sex Survided female 0 81 1 233 male 0 468 1 109Name: Survived, dtype: int64 In [16]:
Consider the following database instance. Table name: Students Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen Table name: Courses Primary key: cid cid cname 1 ICS 2 Finance Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1 5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’); INSERT INTO Students VALUES (6, ‘Ellen’); INSERT INTO Register VALUES (1, 2); INSERT INTO Courses VALUES (5, ‘Systems’); INSERT INTO Register VALUES (6, 5); INSERT INTO Register…
Consider the following database instance. Table name: Students Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen Table name: Courses Primary key: cid cid cname 1 ICS 2 Finance Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1 5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’); INSERT INTO Students VALUES (6, ‘Ellen’); INSERT INTO Register VALUES (1, 2); INSERT INTO Courses VALUES (5, ‘Systems’); INSERT INTO Register VALUES (6, 5); INSERT INTO Register…
Consider the following typed relational schema describing books and borrowers in a library:Book(isbn:integer, title:string, publisher:string, year:integer)Author(isbn:integer, name:string, rank:integer)Borrower(bid:integer, name:string, address:string)Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)Assume the following:• dates are represented as a count of the number of days since Jan 1 1990• there is a system function today that returns today's date• the relational operators < and > allow you test before and after on dates• all loans are for a period of 14 days• the whenReturned field is null until the book is returned• the rank field specifies whether the author is the first, second, third, ... author Implement solutions to the following: Write an SQL query to show which books (title only) have never been borrowed.
Consider the following typed relational schema describing books and borrowers in a library:Book(isbn:integer, title:string, publisher:string, year:integer)Author(isbn:integer, name:string, rank:integer)Borrower(bid:integer, name:string, address:string)Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)Assume the following:• dates are represented as a count of the number of days since Jan 1 1990• there is a system function today that returns today's date• the relational operators < and > allow you test before and after on dates• all loans are for a period of 14 days• the whenReturned field is null until the book is returned• the rank field specifies whether the author is the first, second, third, ... author Implement solutions to the following: Write an SQL query to list each overdue book (title) and the borrower's name.
Consider the following typed relational schema describing books and borrowers in a library:Book(isbn:integer, title:string, publisher:string, year:integer)Author(isbn:integer, name:string, rank:integer)Borrower(bid:integer, name:string, address:string)Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)Assume the following:• dates are represented as a count of the number of days since Jan 1 1990• there is a system function today that returns today's date• the relational operators < and > allow you test before and after on dates• all loans are for a period of 14 days• the whenReturned field is null until the book is returned• the rank field specifies whether the author is the first, second, third, ... author Implement solutions to the following: Write an SQL query to show which books are currently out on loan.
Consider the following typed relational schema describing books and borrowers in a library:Book(isbn:integer, title:string, publisher:string, year:integer)Author(isbn:integer, name:string, rank:integer)Borrower(bid:integer, name:string, address:string)Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)Assume the following:• dates are represented as a count of the number of days since Jan 1 1990• there is a system function today that returns today's date• the relational operators < and > allow you test before and after on dates• all loans are for a period of 14 days• the whenReturned field is null until the book is returned• the rank field specifies whether the author is the first, second, third, ... author Implement solutions to the following: Write an SQL query to show which books (title only) are currently out on loan. *******IF U WILL ANSWER THIS ILL GIVE U A BONUS JUST GIVE ME YOUR GCASH OR ANY EWALLET AFTER U ANSWER THE QUESTION ********
Consider the following typed relational schema describing books and borrowers in a library:Book(isbn:integer, title:string, publisher:string, year:integer)Author(isbn:integer, name:string, rank:integer)Borrower(bid:integer, name:string, address:string)Borrowings(isbn:integer, borrower:integer, whenTaken:date, whenReturned:date)Assume the following:• dates are represented as a count of the number of days since Jan 1 1990• there is a system function today that returns today's date• the relational operators < and > allow you test before and after on dates• all loans are for a period of 14 days• the whenReturned field is null until the book is returned• the rank field specifies whether the author is the first, second, third, ... author Implement solutions to the following: Write an SQL query to show which books (title only) have multiple authors.