Create Database And Refer Data Below 1 Tables With Data Integrity Table Customer Custld Is The Primary Key For This T 1 (52.95 KiB) Viewed 30 times
Create Database and refer data below 1. TABLES WITH DATA INTEGRITY - Table CUSTOMER Custld is the primary key for this table - CustlD - CustNames - Custermail - Table HALL - HallNum is the primary key for this table - HallNuma - Halltroe - HallRate - Table MOVIE - Movield is the primary key for this table - MovielR - Moviename - ShowRate - ShowTime - Moviebanguage - Moviequration - Moviegenre - MoviePrice - Table PAYMENT - Ravmentld is the primary key for this table - Paxmentid - RavmentType - Table TICKET_PURCHASE - Purchaseld is the primary key for this table.while CustID.AavmentldulallNum are the foreign keys for this table
∃ NEW CUSTOMER II secking BOOKING FORM
Total Company Profit
7. SQL QUERIES 7.1 Add Quantity into TICKET_PURCHASE 7.2 Delete customer data 7.3 Count payment via Online Banking 7.4 Display customer who booked Standard Hall or more than 3 tickets 7.5 Display maximum price of movie 7.6 Display movie at certain price 7.7 Display movie in January 2021 7.8 Display total ticket purchase by each customer 7.9 Update Quantity in the TICKET_PURCHASE table 7.10Update ShowRate and ShowTime
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!