Database Homework Assignment

“FIRST…

Below you will see a file that contains the data for the JustLee database…the data is listed in table order…the tables are listed alphabetically…the first thing you need to do is to create the INSERT statements for the data…there are two catches to doing that…

The data in the file matches the way the fields in the database should be arranged and defined…if your tables are not defined correctly (or if they are defined differently from the data), you will not be able to INSERT the data as it is in the file…so be prepared to make changes…if that is the case, you are going to have to change your tables…

REMEMBER…you cannot insert data for a foreign key before the data is inserted for the primary key…so you need to make sure you insert data in the proper sequence…

MAKE SURE YOU SAVE THIS AS A TEXT FILE…EVEN IF THE EXTENSION SAYS TXT IT CAN STILL BE A PDF…make sure you try opening the file to be sure…I WILL NOT GRADE A PDF FILE…

SECOND…

Just to give you a little practice, I have included THREE very basic SQLs for you to get to work…we will be doing a LOT more on the SELECT next week…but I want you to at least do a few basic items…the three SQLs you need to write are:

Display a list of all data contained in the BOOKS table (REMEMBER MY NOTE IN THE POWER POINT ON ‘*’)…

List the title and publication date for each book in the BOOKS table…use the column heading “Publication Date” for the pubdate…

Determine which categories are in the BOOKS table…list each category only once…

So NOW what exactly do you need to submit?…you again need to submit a text file…the file should contain the following items in the sequence outlined below:

ALL of your DROP statements first…

ALL of your CREATE statements next…

ALL of your CONSTRAINT statements…

ALL of your INSERT statements…

ALL of your DESCRIBE statements…

ALL of your CONSTRAINT VIEW statements…

ALL of your CONSTRAINT VIEW BY COLUMN statements…

ALL of your data displayed…

Your THREE homework SQLs…”