FREE Trial

Create a separate table with the same structure as the Booking table to hold archive records. Using

Question:

Create a separate table with the same structure as the Booking table to hold archive records. Using the INSERT statement, copy the records from the Booking table to the archive table relating to bookings before 1st January 2013. Delete all bookings before 1st January 2013 from the Booking table.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 92% (14 reviews)

CREATE TABLE BookingOld hotelNo CHAR 4 NOT NULL guestNo ...View the full answer


answer-question-section
Answered By
tutor-profile-image
Deborah Joseph
My experience has a tutor has helped me with learning and relearning. You learn everyday actually and there are changes that are made to the curriculum every time so being a tutor has helped in keeping me updated about the present curriculum and all. I have also been able to help over 100 students achieve better grades particularly in the categories of Math and Biology both in their internal examinations and external examinations.
5.00+ 2+ Reviews 10+ Question Solved
Related Book For  book-img-for-question
Database Systems A Practical Approach to Design Implementation and Management

Database Systems A Practical Approach to Design Implementation and Management

ISBN: 978-0132943260

6th Edition Global

Authors: Thomas Connolly, Carolyn Begg

See More Books
Question Posted:
See More Questions

Students also viewed these Computer Sciences questions

Computer Organization And Architecture Evolutionary Concepts Principles And Designs 1st Edition - ISBN: 0367255731 - Free Book