Question: wer all the questions uestion LO1: Use a database management system to design and build a database application aximum Marks 5 Approx Time: 15 Min


wer all the questions uestion LO1: Use a database management system to design and build a database application aximum Marks 5 Approx Time: 15 Min uestion I Consider the seven relations for a car-rental database application provided below. Write appropriate SQL DDL statements to define the database. (CL01) (5 marks) (15 Min, Approximate 75-100 words) CUSTOMER(Cust#, Cname, City) RENTAL(Rental#, Rdate, Cust#, Time, Date, Hourly rate) RENTAL_CAR(Rental#, Car#, Driver#, Start_time, End time, Amount received) CAR(Car#, Year, Model, Price, Depreciation, Last_service) DRIVER(Driver#, DName, DAddress) Question 101: Use a database management system to design and build a database application lax Marks 3 Approx Time 7 Min Question a Write SOL update statements to do the following out the dacaluse scheme hown in Following Figure tal Insert a new course. Tinancial Accounting, tac 1905 BUSINESS (by Insert a new section is facral Tantepdate the cord for the student whose student numiris rand changes dans from STUDENT wer all the questions uestion LO1: Use a database management system to design and build a database application aximum Marks 5 Approx Time: 15 Min uestion I Consider the seven relations for a car-rental database application provided below. Write appropriate SQL DDL statements to define the database. (CL01) (5 marks) (15 Min, Approximate 75-100 words) CUSTOMER(Cust#, Cname, City) RENTAL(Rental#, Rdate, Cust#, Time, Date, Hourly rate) RENTAL_CAR(Rental#, Car#, Driver#, Start_time, End time, Amount received) CAR(Car#, Year, Model, Price, Depreciation, Last_service) DRIVER(Driver#, DName, DAddress) Question 101: Use a database management system to design and build a database application lax Marks 3 Approx Time 7 Min Question a Write SOL update statements to do the following out the dacaluse scheme hown in Following Figure tal Insert a new course. Tinancial Accounting, tac 1905 BUSINESS (by Insert a new section is facral Tantepdate the cord for the student whose student numiris rand changes dans from STUDENT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
