Customer Employee PK CustomerPhoneKey PK Employeekey CustomerLastName %23 EmployeeLastName CustomerFirstName EmployeeFirstName CustomerAddress1 EmployeeHireDate CustomerAddress2 CustomerCity CustomerState Product CustomerZip PK ProductKey ProductName ProductUnitSize ProductUnitPrice CustomerOrder PK Orderkey OrderDate OrderDetail OrderTime FK CustomerPhoneKey PK OrderDetailkey FK OrderKey FK ProductKey EmployeeKey OrderDetailQuantity OrderDetailPriceCharged Use the ERD of Perfect Pizza database which of a pizza delivery shop to write SQL queries for the following: a) Join the product and the OrderDetail table so that the result contains the product name, product unit size, and product unit price, as well as the charged price. Do it for order 2000. b) List all the order and order details for each order made by the customer with the phone number 2065556623. c) Return the name of the product with the highest price and its price. Use a subquery. d) List any Products that have never been ordered? Use a sub query. e) Which product unit prices are greater than the average unit price? Include the product name, the product price, and the average in the results. Use Subqueries.

Customer Employee PK CustomerPhoneKey PK Employeekey CustomerLastName %23 EmployeeLastName CustomerFirstName EmployeeFirstName CustomerAddress1 EmployeeHireDate CustomerAddress2 CustomerCity CustomerState Product CustomerZip PK ProductKey ProductName ProductUnitSize ProductUnitPrice CustomerOrder PK Orderkey OrderDate OrderDetail OrderTime FK CustomerPhoneKey PK OrderDetailkey FK OrderKey FK ProductKey EmployeeKey OrderDetailQuantity OrderDetailPriceCharged Use the ERD of Perfect Pizza database which of a pizza delivery shop to write SQL queries for the following: a) Join the product and the OrderDetail table so that the result contains the product name, product unit size, and product unit price, as well as the charged price. Do it for order 2000. b) List all the order and order details for each order made by the customer with the phone number 2065556623. c) Return the name of the product with the highest price and its price. Use a subquery. d) List any Products that have never been ordered? Use a sub query. e) Which product unit prices are greater than the average unit price? Include the product name, the product price, and the average in the results. Use Subqueries.

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

dont dont dont copys trict verystcrcity report
. It comprises the following tables: in AccessCRYPTOCODES: A list of 17 currencies the company is interested in.CRYPTOHISTORY : Several years of daily activities for the 17 currencies.CRYPTOCOINS-2018-2-9: Details of known currencies that were activewhen the data was complied.Exchanges-2018-2-9: A list of active exchanges on 2018-2-9 (provided as an excel file).You are asked to prepare several queries, as well as some reports.
Web technology Question: Professor don't reject this....I need this answer otherwise I will report to administration....please answer it according to asked question. Q.No.2. Suppose there is a MySQL database named MyDatabase, the name of database server is DatabaseServer, User Name for the database server "Ghazi Messam" and Password is “1121” There is one table named tbl_Projects (ProjectSID, ProjectTitle, ProjectSupervisor,CellNo,Email). As project title is: Student Registration form As project supervisor is: Ghazi Messam As cell no: 03137025001 As Email is: ghazimessam@gmail.com You are required to design a HTML page to get the value for each of these attributes. Then finally post the data to next page and store the input data to database. Add Screen Shot of Creating database, Database Table and Sample Data.
Create a database in phpmyadmin using the carwash ERD you created last activity. (Recommend using SQL)
Network securityData warehousingSelectionDistinctionAnd joining two tables using an IDAuthorizationEncryptionPurpose of data securityDatabase transactionWhat is a transaction Types of transactionsHow can you use transaction to do what you want to do
25. What is a Table View?26. What is a Table View Controller?27. What is Navigation Controller?28. Difference between action and outlet?29. What is a story board? Can one app have Multiples?30. Illistrate an example of Data source vs Delegate?31. NSMangedObjects NSMangedObjectContext NSPersistanceStoreCoordinatorEntities Atributes Relations nsfetchRequest nsfetchResultController32. Illustrate an example of entities with a relation of many to many.
Which of the following are true about primary keys? SELECT ALL THAT APPLY. A) They must reference one or more columns in a single table. B) They are usually implemented using an index. C) They guarantee that no two rows in a table have duplicate primary key values. D) They must be defined for every database table.
CSV FILE INFO• Option: Scrape, not download, the CSV file instead of scraping table. Create the 6 agents to handle the annual data. These agents extract the yearly dataa time over the range 1990 thru 2019. When the data has been extracted, the plota linear regression for each threaded agent.Threading rules:▪ Only one agent can access the database at a time.▪ The database inquiry only request one cell of data per request for data.▪ The agents must make repeated requests for annual data.After collecting the data, plot a liner regression for each gas using either Matplotlibor Plotly.
create Database CTU_YOURICASNOGOUSE CTU_YOURICASNO;GOCREATE TABLE Course( CourseID int PRIMARY KEY, CourseName varchar(255), CourseDesc varchar(255),);CREATE TABLE Students( ICASNo int Primary Key, StudentName varchar (255)NOT NULL, StudentSurname varchar (255)NOT NULL, StudentContact varchar (255)NOT NULL, StudentEmail varchar(255)NOT NULL, HighSchoolAttended varchar(255)NOT NULL, courseID int,);CREATE TABLE Semester( SemesterID int Primary Key, SemesterStartDate varchar(255)NOT NULL, SemesterEndDate varchar(255)NOT NULL, ICASNo varchar(255),);CREATE TABLE Facilitator( FacilitatorID int Primary Key, FacilitatorName varchar(255) Not Null, FacilitatorContact varchar(255)Not Null, FacilitatorEmail varchar(255)Not Null, ICASNo varchar(255)Not Null, ); CREATE TABLE Module( ModuleID int Primary Key, ModuelName varchar(255)Not Null, ModuleDuration varchar(255)Not Null, FacilitatorID varchar(255)Not Null,); Using the…
ITD 256 Case Study 1 United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Multiple auctions may take place at one gallery. Use draw.io to create your ERD. Relationships and tables are the only requirement for this case study.
PrimeVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. PrimeVideo can own several copies (VIDEO) of each movie (MOVIE). For example, a kiosk may have 10 copies of the movie Twist in the Wind. In the database, Twist in the Wind would be one MOVIE, and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime; therefore, there is an M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. The complete ERD is provided in the figure. Write the SQL code to create the table structures for the entities shown in the figure. The structures should contain the attributes specified in the ERD. Use data types (and lengths, if applicable) that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD. Make…
Given the following XML file student.xml <?xml version="1.0" encoding="UTF-8"?> <Myclass transacted= ”123”> <studlist> <student Rating= “average” > <firstName>John</firstName> <lastName>Smith</lastName> <email>jsmith@gmail.com</email> <mobile>0211223344</mobile> </student> <student Rating= “top 10” > <firstName>Ali</firstName> <lastName>Faizal</lastName> <email>ali@gmail.com</email> <mobile>0211223345</mobile> </student> </studlist> <Details> <location>Block15</location> <floor>First</floor> <roomno>909</roomno> </Details> </Myclass> Write an DTD document for the above xml file. What is the document root?