QUESTION 4 Consider the following relational database: CUSTOMER (CustID, CustFName, CustLName, CustAdd, City, State, Country, PhoneNum)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff
Posted Date:
Students also viewed these databases questions
-
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)...
-
Ms. Acosta received a job as a teacher with a starting salary of $3 According to her contract, she will receive a 1.5% increase in her salary every year. How much will Ms. Acosta earn in 7 years.
-
Look on the Internet for time management resources that are designed specifically for students. If you cannot find one, look at the University of Guelph library web page. (a) Why is it important to...
-
On September 1, 2015, Health Wise International acquired a 12 percent, nine-month note receivable from Herbal Innovations, a credit customer, in settlement of a $22,000 account receivable. Prepare...
-
When the Concepcions went to AT&T to get a phone, they were confused as to why they were paying money for the phone when it was advertised as being free. They had to pay sales tax on the full normal...
-
Data pertaining to the current position of Brin Company are as follows: Cash .................$520,000 Temporary investments ..........380,000 Accounts and notes receivable (net) .....700,000...
-
A 480-g iron pan is heated on a stove to a temperature of 130 C. The pan is then dropped into a partially-filled sink of water at 20 C. The final temperature reached by the sink and the pan is 40 C....
-
5) An object hangs by means of two cords around two rods, as seen below. rod A) F > F C) F = F 0 F object weight 10 N F The object is held in equilibrium by forces F1 and F2, and its weight is 10 N....
-
IAS 37: Find the error in the following statements. a. When calculating the amount of reserves, it is calculated by reducing the amount of compensation. b. Insurance claims are treated as contingent...
-
Have you, or do you know somebody who, found wrongdoing at a company? If not at a company, how about in one of your classes? What actions were taken and why? Looking back at what was done, was that...
-
As an IT professional, It is required to speak with others either face to face, by phone, or in virtual meetings. Provide 2 examples of verbal communication. What form were your communications in...
-
Think about a strategy for sharing the story Brown Bear, Brown Bear and Five Little Monkeys Jumping on the Bed with young children. How would you present this story to a child? What would you change...
-
Research and select three examples of professional business memos for communication. Select three that you think reflect the qualities you would like to see in your own work. Then, address the...
-
You have the following projections about the costs in a family restaurant for next year: Net income required: 22% after income tax on the owner\'s present investment of $80,000, income tax rate is...
-
Show that every group G with identity e and such that x * x = e for all x G is abelian.
-
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:...
-
In a large office building, there is a woman dead in her locked office, sitting at her desk. Except for the desk, chair, and contents on the desk, the office is empty and the air conditioner is...
-
How many birthdays does the average person have?
-
A murderer is condemned to death. He has to choose between three rooms. The first is full of raging fires, the second is full of assassins with loaded guns, and the third is full of lions that havent...
Study smarter with the SolutionInn App