Given this unnormalised relation:SHOW_TICKET (show_id, show_title, show_category, show_datetime, show_duration, venue_no, venue_name, seat_no, ticket_category, ticket_price)and this sample data:show_id10321032103210321038103820332033show_titleStill We RiseStill We RiseStill We RiseStill We RiseDriftwoodDriftwoodShrek JrShrek JrExplain and give example/s of:(a) super key(b) candidate key(c) primary key [(d) surrogate key [(e) functional dependency1show_category show_datetime show_duration venue_noClassical Music2 hrs 30 minsClassical Music2 hrs 30 minsClassical Music2 hrs 30 minsClassical Music2 hrs 30 minsMusical1 hrs 50 mins1 hrs 50 mins1hr1122222MusicalMusicalMusical1hr25/06/2022 19:0025/06/2022 19:0025/06/2022 19:0026/06/2022 19:3025/06/2022 19:0025/06/2022 19:0026/06/2022 11:3026/06/2022 11:30SYour answer must include examples drawn from SHOW_TICKET relation.$22venue_name seat_no ticket_category ticket_priceAlexander Theatre F7GeneralStudentGeneralPensionerGeneralStudentAdultAlexander Theatre F8Alexander Theatre G9Robert Blackwood F7Robert Blackwood F7Robert Blackwood F8Robert Blackwood F8Robert Blackwood F9Kid$14$22$16$35$25$20$55227

Part a Suberkey is the set of attributes that can determine all of the relationship's other…

Given this unnormalised relation: SHOW_TICKET (show_id, show_title, show_category, show_datetime, show_duration, venue_no, venue_name, seat_no, ticket_category, ticket_price) and this sample data: show_id 1032 1032 1032 1032 1038 1038 2033 2033 show_title Still We Rise Still We Rise Still We Rise Still We Rise Driftwood Driftwood Shrek Jr Shrek Jr 1 show_category show_datetime show_duration venue_no Classical Music 25/06/2022 19:00 2 hrs 30 mins Classical Music 25/06/2022 19:00 2 hrs 30 mins Classical Music 25/06/2022 19:00 2 hrs 30 mins Classical Music 26/06/2022 19:30 2 hrs 30 mins Musical 25/06/2022 19.00 25/06/2022 19:00 1 hrs 50 mins Musical 1 hrs 50 mins 1hr Musical 26/06/2022 11:30 26/06/2022 11:30 Musical 1hr Explain and give example/s of: (a) super key (b) candidate key (c) primary key [ (d) surrogate key [ (e) functional dependency Your answer must include examples drawn from SHOW_TICKET relation. 1 1 2 2 2 2 2 $22 venue_name seat_no ticket_category ticket_price Alexander Theatre F7 General Student General Pensioner General Student Adult $14 $22 $16 Alexander Theatre F8 Alexander Theatre G9 Robert Blackwood F7 Robert Blackwood F7 Robert Blackwood F8 Robert Blackwood F8 Robert Blackwood F9 $35 $25 $20 Kid $5

Given this unnormalised relation: SHOW_TICKET (show_id, show_title, show_category, show_datetime, show_duration, venue_no, venue_name, seat_no, ticket_category, ticket_price) and this sample data: show_id 1032 1032 1032 1032 1038 1038 2033 2033 show_title Still We Rise Still We Rise Still We Rise Still We Rise Driftwood Driftwood Shrek Jr Shrek Jr 1 show_category show_datetime show_duration venue_no Classical Music 25/06/2022 19:00 2 hrs 30 mins Classical Music 25/06/2022 19:00 2 hrs 30 mins Classical Music 25/06/2022 19:00 2 hrs 30 mins Classical Music 26/06/2022 19:30 2 hrs 30 mins Musical 25/06/2022 19.00 25/06/2022 19:00 1 hrs 50 mins Musical 1 hrs 50 mins 1hr Musical 26/06/2022 11:30 26/06/2022 11:30 Musical 1hr Explain and give example/s of: (a) super key (b) candidate key (c) primary key [ (d) surrogate key [ (e) functional dependency Your answer must include examples drawn from SHOW_TICKET relation. 1 1 2 2 2 2 2 $22 venue_name seat_no ticket_category ticket_price Alexander Theatre F7 General Student General Pensioner General Student Adult $14 $22 $16 Alexander Theatre F8 Alexander Theatre G9 Robert Blackwood F7 Robert Blackwood F7 Robert Blackwood F8 Robert Blackwood F8 Robert Blackwood F9 $35 $25 $20 Kid $5

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....

See similar textbooks

Similar questions

The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.
The Driver Relationship team wants to analyze drivers and their car usages in InstantRide for the month October. Thus, they want to focus on each driver and respective car allocation occurred. In more detail, the team requires the DRIVER_ID and the CAR_ID with their usage counts as the TOTAL column for the travels occurred in the month of October. Since the team wants to also learn the total number of the travels by the drivers you need to use GROUP BY ROLLUP functionality.
CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…
DCIT184 STAT181 Closely examine the following tables and use it to answer the questions that follow: department student_type student_category id |name | location | contact id name id name Computer Science Mathematics Statistics Sociology 005 | History English Linguistic North Ave 1 | +233234545453 North Ave 2 | +233234564554 North Ave 3 001 002 1 | Regular 2| Distance 3 | Sandwich 1 | Foreign 2| Local 003 +233285475547 004 East Ave 4 +233264638374 East Ave 2 +233244454744 006 East Ave 3 +233245653443 007 East Ave 4 +233268888888 course code | title dept_id | credit CSIT205 Object Oriented Techniques For IT Problem Solving Applied IT Programming Database Fundamentals Office Productivity Tools Programming Fundamentals Introduction to History History of The Gold Coast Introduction To Basic Statistics CSIT206 3 CSIT207 DCIT103 DCIT104 HIST101 5 | 3 HIST103 3 STAT101 Student id first_name last_name dob contact stud_cat_id | stud_type_id e0000001 Stephen Amankwah 1999-01-12 +233456789021 1…
Q2: A-Given the following tables: Student Subject Std_ID 001 002 003 004 Fname Smith Smith Beal Thomson Lname Jolin Susan Fred Marie Std_ID 001 001 002 002 003 Semester 004 Falls03 Spro4 Falls03 C_ID Eng01 Ger01 Eng01 Ger01 Ger01 CSection Spro4 Spro4 Spro4 1. For each table in the database, identify the primary key and the foreign key(s). 2. Do the tables exhibit entity integrity? Explain your answer? 3. Do the tables exhibit referential integrity? Explain your answer? Ita01 ZZZZZZ IN 2N IN 2N IN CName English IN German English German German Italian Grade A B A B A B
MySQL CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...6. Find the last name of all employees that were not hired on Tuesday *hint: (UseDATE_FORMAT() function amd the format you need is %W, also use UPPER()7. Find the number of employees in each department who have a manager.8. Find the number of employees for each manager whose employees' minimum salary is greaterthan 5000.9. Find the number of…
What happens if you try to decrease the scale or precision of a NUMBER column to a value less than the data already stored in the field?
Q4 There are 9 workers for ASH Development Sdn. Bhd. Unfortunately, there are only 4 rooms available for these workers. Every week, a worker name is randomly selected to do odd jobs for the company. When a worker has been selected randomly, a these rooms are full. Based on Figure Q4, worker's ID number 0 (Umar) is randomly selected for the first week, and the 4 boxes represent 4 rooms for as shown in Table Q4. room needs to be vacated if workers. Table Q4 Worker's ID Worker's Name Umar 1. Lukman Arif Yusuf Anas Muadz Aleef Hafiz 8. Amir 9. Taufik WI 4 6 2 9. 4 1 3 8 D R2 R3 R4 W W W1 w1 Wi w1 W1 w1 w1 wi Wi W1 2 3 4 56 78 9 1 2 3 4 5 6 8 9 Figure Q4 Investigate the number of page faults occur by illustrating the way how the room is managed using the list of weekly random selection of workers as shown in Figure Q4 using the following algorithms: (a) Optimal Page Replacement (OPR) replacement algorithm 2. RRR
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.
The data in flat files has been provided: INVOICE TABLE INVOICE_NUM CUSTOMER_ID INVOICE_DATE EMPLOYEE_ID COIN_ID DELIVERY_ID 8111 11011 15 May 2021 emp103 7111 511 8112 11013 15 May 2021 emp101 7116 512 8113 11012 17 May 2021 emp101 7112 513 8114 11015 17 May 2021 emp102 7111 514 8115 11011 17 May 2021 emp102 7115 515 8116 11015 18 May 2021 emp103 7115 516 8117 11012 19 May 2021 emp105 7112 517 8118 11013 19 May 2021 emp105 7112 517 COIN_RETURNS TABLE RETURN_ID RETURN_DATE REASON CUSTOMER_ID COIN_ID EMPLOYEE_ID ret001 25 May 2021 Customer not satisfied with product 11011 7116 emp101 ret002 25 May 2021 Product missing part 11013 7114 emp103 COIN TABLE COIN_ID PRODUCT PRICE QTY 7111 1oz Gold Kruger Rand R 5 999 10 7112 1oz Silver Kruger Rand R 12 999 8 7113 Gold Big 5 Uncirculated R 15 999 8 7114 Silver Big 5 Pack R 7 999 5 7115 1oz Gold Palaeontology R 11 999 15 7116 1oz Silver Palaeontology R 7 999 12 COIN_DELIVERY TABLE…
Write a PL/SQL script to print all the details of the Jobs table using a cursor. Your query must include %RowType (to access the column names and datatypes of jobs table), and a cursor attribute to print the total number of rows returned. DEPARTMENTS LOCATIONS DEPARTMENT_ID * DEPARTMENT_NAME F P * LOCATION_ID STREET_ADDRESS POSTAL_C MANAGER_ID LOCATION_ID JOB_HISTORY PF* EMPLOYEE_ID * START_DATE CITY P END DATE F * JOB_ID F STATE_PROVINCE F COUNTRY_ID DEPARTMENT_ID EMPLOYEES EMPLOYEE_ID FIRST_NAME LAST_NAME U * EMAIL PHONE_NUMBER HIRE_DATE * JOB_ID P. COUNTRIES P COUNTRY_ID COUNTRY_NAME F JOBS REGION_ID P * JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY SALARY COMMISSION_PCT REGIONS IF MANAGER_ID P * REGION_ID REGION_NAME F DEPARTMENT_ID
SQL Table: CREATE TABLE employees ( employee_id INT PRIMARY KEY, first_name VARCHAR(255), last_name VARCHAR(255), email VARCHAR(255) UNIQUE, phone_number VARCHAR(255), hire_date DATE, job_id VARCHAR(255), salary DECIMAL(10,2), commission_pct DECIMAL(5,2), manager_id INT, department_id INT, FOREIGN KEY (manager_id) REFERENCES employees(employee_id), FOREIGN KEY (department_id) REFERENCES departments(department_id)); CREATE TABLE departments ( department_id INT PRIMARY KEY, department_name VARCHAR(255), manager_id INT, FOREIGN KEY (manager_id) REFERENCES employees(employee_id)); INSERT INTO employees (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id)VALUES (1, 'John', 'Doe', 'john.doe@example.com', '555-555-5555', '2022-01-01', 'IT_PROG', 8000, 0.2, 3, 10), (2, 'Jane', 'Smith', 'jane.smith@example.com', '555-555-5556', '2022-02-01', 'IT_PROG', 9000,…