Chapter 3, Problem 3.6AYK

Delete the LARGE_PROPERTY table from the database.

Create a view containing the records for each guest at the ParkView Hotel          Hotel (hotelno, hotelname, city) Room (roomno, hotelno, Type, price) Booking (hotelno, guestno, datefrom, dateto, roomno) Guest (guestno, guestname, guestaddress)

you are supposed to create an excel sheet for student grade sheet. There must be at least 10 records. Following columns will be needed for the sheet.       Also add summary of the grades as follows. Grade Count A 6 B 4 C 8 D 2 F 10 TOTAL 30   Grading Criteria to calculate grades is as follows: Marks Grade 90-100 A 80-89 A- 75-79 B+ 70-74 B 65-69 C+ 60-64 C 50-59 D Less than 50 F