Customer Employee PK CustomerPhoneKey PK Employeekey CustomerLastName 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 EmployeeKey FK Orderkey FK ProductKey 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.

Q: Customer Employee PK CustomerPhoneKey PK Employeekey CustomerLastName %23 EmployeeLastName…

A: The d and e part is given below along with explanation

Q: tblShippers V ShoperiD tblProducts 8 ProductID Companytiame SupplierD tblOrderDetails CategoryD P…

A: It violates integrity constraints: Absence of Primary key and foreign key constraints. It violates…

Q: THIS PROGRAM IN JAVA LANGUAGE OOP KINDLY USE GUI  eShop Create/View/Edit Profile Admin account for…

A: GIVEN: To use GUI for eShop

Q: Explain the following UML ClASS DIAGRAM

A: Aggregation: The aggregation relationship is also known as “has-a” relationship. The aggregation…

Q: RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager towniD Number PK pointiD managerID Number PK…

A: According to the given question we are required to find the highest summer and lowest winter…

Q: Customer Freight Address PK Customerid O PK id PK FulName FK1 Customerid Complex Number Contactumber…

A: create table Address(Id int primary key,Complex_Number int,Complex_Name varchar(50),Street…

Q: Login AddVidoe OrderLiveVidoe AddReport ReadReport Contact The Nursery ReportsEmergency Situation…

A: Answer : i attached an image please have a look once.

Q: key value Customer BillingAddress OrderID's referances key value Order ShippingAddress…

A:

Q: RESORT MANAGEMENT SYSTEM Town terest Manager ointiD PK towniD Number PK manageriD Number |…

A: According to the given question we are required to find the highest summer and lowest winter…

Q: For each customer: CID (unique), CName (unique), For each manager: MID (unique), MFullName (composed…

A: Q. For Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel) For Hotel: HotelID…

Q: College Management System(CMS) Department Student department_id number --> PK department_name…

A: The Answer is

Q: SupplierAddress SupAddress Street City District Superstore StorelD Procurement_Sup…

A: Code for creating tables:   create table Customer(CustomerID int primary key, CustomerName text,…

Q: In the image provided which keys would be Primary, Foreign, or Surrogate in this star schema?

A: Primary keys:It is unique key in data table assigned to link one data table with other. Example of…

Q: Actor System 1.       Sales clerk answers telephone and connects to a customer 2.       Clerk…

A: Activity chart for flow of control  We use Activity Diagrams to show the progression of control in a…

Q: Actor System 1.       Sales clerk answers telephone and connects to a customer 2.       Clerk…

A: Activity diagram for flow of control We use Activity Diagrams to illustrate the flow of control in a…

Q: RESORT MANAGEMENT SYSTEM Pointofnterest Town Manager PK townD Number Number pointo Number PK…

A: Required:   From the given database schema we have to write a SQL query that displays the total…

Q: tromdate RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager pointiD PK towniD Number managerib…

A: Required: We have to write a SQL query that displays the total count of characters ordered by…

Q: ummer & lowest winter temperature and display the output as "HOT SUMMER" a RESORT MANAGEMENT SYSTEM…

A: According to the given question we are required to find the highest summer and lowest winter…

Q: AccountAndRelatedContacts(Integer no, Map(); pi++) Account(Name="Test'+"+ i); (e)PF ts; pj++)

A: Given:

Q: description. pasword Admin id password Admin login Company login User name has password Android…

A: According to the information given:- We have to  describe given flow chart.

Q: amount is more than 50,000. RESORT MANAGEMENT SYSTEM Manager Town Pointofinterest PK Number…

A: The below query will give you the guest name and id whose total bill is more than 50,000 and also…

Q: RESORT MANAGEMENT SYSTEM Town Pointofnterest Manager towniD Number Varchar(30) varchar(30)…

A: Please Find Below your SQL Querry Thank you

Q: RESORT MANAGEMENT SYSTEM Pointofinterest Town Manager Number Varchar(30) varchar0) varchar(0)…

A: Required:   We have to write a SQL query that displays the guest names who are from Ooty and the…

Q: Customer Trip Guide CustomerNum TripID GuideNum LastName TripName StartLocation LastName FirstName…

A: Third normal formFirst Normal Form (1NF) :For any relation to be in the first normal form (1NF), the…

Q: RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager townD Number Varchar0) varchar(0) varchar(30)…

A: Required: We have to write a SQL query that displays the guest names who are from Ooty and the first…

Q: Admin Manage Products View Guest -ld: Integer -Name: Char -ld: Integer #Name: Char #Group: Char…

A:

Q: Reports to BRANCH BranchID BranchName OHBranchAddress (Street1, Street2, City, State, ZIP) Phone…

A: Logical database design can be implemented in various approaches. So one of the approaches has been…

Q: products * productCode productlines orderdetails * productLine textDescription htmlDescription image…

A: Since you have not provided the data present in the table, I am providing the query based on certain…

Q: College Management System(CMS) Department Student department_id number --> PK department_name…

A: Here we have to create the table mark from the database schema given.   We use CREATE command for…

Q: E deptname E fax phone H location offers employs hod Student AcademicStaff studentid staffid A…

A: Required:   We have to develop Sql queries according to the given database schema.

Q: S_Customer_T S_Order_T PK Customer_ID PK Order_ID Order Date FK Customer_ID Customer_Name…

A: Conversion to Relational Model: CREATE TABLE S_Customer_T(Customer_ID integer PRIMARY KEY,…

Q: Assemble all information necessary to create an invoice for order number 1006.

A: Query:- SELECT   CUSTOMER_t.CustomerID, CUSTOMER_t.[CustomerName],CUSTOMER_t.CustomerAddress,…

Q: EmployeeNumber SSerialNumber FirstName Make LastName Model ProcessorType ProcessorSpeed MainMemory…

A: Here the relationship between COMPUTER and EMPLOYEE is Many to Many. Therefore a new table…

Q: Consider the following normalized relations from a database in a large retail chain What…

A: Denormalisation is process related to the database. The primary requirement to do denormalisation is…

Q: 1. Sales clerk answers telephone and connects to a customer 2. Clerk verifies customer information…

A: UML diagrams are of three types: Structural diagram Interaction diagram Behavior diagram The…

Q: stuctural User username pattern (private class data) password email Creational pattern Student |- id…

A:

Q: Here are the steps that occur in the use case named 'Create New Library User Account'. The librarian…

A: Solution: Firstly we  identify the tasks carried out by the Actor Librarian: requests will request…

Q: DocPatientAppointments Table DrName John Smith ... PatientAge ClinicID CI C2 AppDate 15-Jun-21 DRID…

A: Note: The solutions of the first two parts are shown below. Please repost the remaining subpart to…

Q: pdate Location_1_c field of Contact if the related Opportunites have same or countldBefore writing…

A: Here is the simplified code for the given problem statement:

Q: Deaseetafteced Date Range Deaseet rame Deaseet Deacesption Deasect Cede Reataucant Region Name…

A: Each entity is described through a set of attributes (e.G., Employee = (Name, Address, Birthdate…

Q: aggregation School Has Department 1 name Address *email generalization +addDept() *removeDept()…

A: Introduction: In the question we have give a class diagram of a school information system, we need…

Q: 1. Using your knowledge of BITS, determine the functional dependencies that exist in the following…

A: Multiple questions are asked. The below answer is provide only for first three questions.

Q: Customer Purchase id phone PK Pk id made_by product Fname Fk cid FK Pid Lname street_Code street…

A: The converted logical schema is given below

Q: ow do I make (swap) EMP_NUM from line 2 to 1? see attached SELECT emp.EMP_NUM, EMP_FNAME, EMP_LNAME,…

A: given: sql statement task: task is to swap the result so that second result comes first in the…

Q: Create script for the following schema CUSTOMER/CLIENT/SHOPPERS/BUYERS(Cust#, CAddress, Ctown,…

A: Step 1-create ER model-                             step 2show all the relations-…

Q: Q. __________ command can be used to send a task to the background.

A: This given question is based on tasks and processes in linux.

Q: which of the following would run a task at 4pm on saturday? a) 0 16 *** /home/brain/runtask.sh b)…

A: According to the question below the Complete Solution:   0 16 ** 6 /home/brain/runtask.sh

Q: HungryMe is a young entrepreneurial company to offer F&B delivery services that operates between…

A:

Q: A controller action can be used to:   Question 24 options:   a)  Return a view   b)  Return a…

A: 1) Controller class contains public methods called Action methods. Controller and its action method…

Q: Airline Reservation Schema customer (customer_id, first_name, last_name, customer_email,…

A: The answer as given below: