Question: QUESTION 4 Consider the following relational database: CUSTOMER (CustID, CustFName, CustLName, CustAdd, City, State, Country, PhoneNum) MOVIESHOWTIME (MovieShowTimeID, Time, Date, MovieID, HallID, CustID) MOVIE

QUESTION 4 Consider the following relational database: CUSTOMER (CustID, CustFName, CustLName, CustAdd,

QUESTION 4 Consider the following relational database: CUSTOMER (CustID, CustFName, CustLName, CustAdd, City, State, Country, PhoneNum) MOVIESHOWTIME (MovieShowTimeID, Time, Date, MovieID, HallID, CustID) MOVIE (MovieID, MovieName, Length) HALL (HallID, HallName) SEAT (SeatNum, SeatDetails, HallID) a) Add new attribute for table MOVIE named "Genre". (4 marks) b) Display all movie name which showing on 23/06/2022. View the results by movie name in descending order. c) Total number of customers for each hall. d) Display movie genre with highest sales. (4 marks) (4 marks) (4 marks) e) Total number of customers who are watching "Mat Kilau". (4 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a To add a new attribute named Genre to the table MOVIE you would alter the table structure and add ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Explanation of A very brief overview of the firm and its product or service and target market. 2. Explanation of Vision, Mission Statement & Goals: What is the organization's Vision, mission, and...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

) Explain the collision detection mechanism applied in standard wired medium access control associated with CSMA and indicate why this might be unsuitable for wireless networks. [2 marks] (ii)...

Builtrite's common stock is currently selling for $48 a share and the firm just paid an annual dividend of $2.80 per share.Management believes that dividends and earnings should grow at 8%...

4. Consider the following relational database schema discussed in class, where the pri- mary key of each relation is underlined. Pizzas (pizza) Customers cname, area) Restaurants (rname, area)...

QUESTION 4 Consider the following relational schema for an Online book store database: Product ( BookID , Bookname UnitPrice, Author ID ) Customer order ( Order ID . CustomerID Quantity Ordered,Order...

QUESTION 4 Consider the following relational schema for an Online book store database: Product (BookID, Bookname, UnitPrice, Author_ID) Customer_order(Order_ID,CustomerID,Quantity_Ordered,Order_Date)...

QUESTION 1 Consider the following relational database schema. Book (BookNo, BookTitle, BookType) Orders (Order No, BookNo, CustomerID, Price) Write SQL Query to find the total amount of money spent...

QUESTION 4 Consider the following relational schema for a company: Customer (CustCode, CustName, CustAdress, Payment_Method) Product (ProductCode, ProductName, UnitPrice, UnitCost) CustomerOrder...

QUESTION 4 Consider the following relational schema for a company: Customer ( CustCode , CustName, CustAdress, Payment Method ) Product ( ProductCode , ProductName, UnitPrice, UnitCost )...

Which of the following statements about species-accumulationcurves is FALSE? A) Species-accumulation curves are used to estimate regional, orgamma, diversity. B) The precise shape of a...

Crane Inc. Is an agent for Phillips Co. and negotiates sales contracts between Phillips and the final customer for heating and air conditioning units. By agreement, Crane is to receive a commission...

SAP The point at which the credit check is performed impacts the outcome of the credit check. If credit is checked at the point of , it could result in lost sales since the credit check may pass at...

Alp Inc. had the following activities during 2017: Acquired 2,000 shares of stock in Maybel Inc. for $26,000. Sold an investment in Rate Motors for $35,000 when the carrying value was $33,000. ...

Lino Company's worksheet for the preparation of its 2017 statement of cash flows included the following information: ________________________________December 31 January 1 Accounts...

Use the computerized model in File C07 to solve this problem. a. Refer to Problem. Suppose Cary Corporation is considering installing a new computer system that would provide tighter control of...

As discussed in the chapter, abnormal earnings (AE) are AEt = Xt (re Ã BVt1) where Xt is the firm's net income, re is the cost of equity capital, and BVt1 is the book value of equity at t 1....

A new product is being designed by an engineering team at Odin Security. Several managers and employees from the cost accounting department and the marketing department are also on the team to...

Can we put that she will be making weekly payroll deductions inthe amount of $52.75 to the housing equalling $211.00 monthly

In answering the following questions, assume that the full deletion algorithm is used. Assume that merging is done when a bucket becomes empty. 1. Give an example of Extendible Hashing where deleting...

Consider the execution shown in Figure 18.3. In addition, the system crashes during recovery after writing two log records to stable storage and again after writing another two log records. 1. What...

The following relations keep track of airline flight information: Flights (flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time, price: real) Aircraft (aid:...

Does it matter whether capital and labor are substitutes or complements when figuring out what will happen to the demand for labor if the price of capital increases? Explain.

What historic legal cases support the behavioralist and structuralist views of the antitrust laws? What has been the recent view of antitrust laws?

What are the economic effects of imposition of a new occupational license or examination on a labor market?