Testing the Database

 

To test our database, let’s create a new SQL file called test.sql. We’ll do all our testing on this file.

 

First, we’ll check if our tables are created correctly. Try executing the following statements to check if the tables are correct:

 

SELECT * FROM members;

SELECT * FROM pending_terminations;

SELECT * FROM bookings;

SELECT * FROM rooms;

 

members, bookings and rooms should contain the same information as the respective tables shown in Appendix B.

 

pending_terminations, on the other hand, should be empty.

 

Got it? Good!

 

Next, let’s try the insert_new_member procedure. Try executing the following statements:

 

CALL insert_new_member ('angelolott', '1234abcd', '[e-mail]');

 

SELECT * FROM members ORDER BY member_since DESC;

 

You should get the table below. The new member added is shown on the first row of the table...