Write CREATE TABLE statements to create the five tables that are left for you to do (These are the yellow relations on diagram: P_SPECIES, P_SIGHTING, P_SITE, P_DIVE, P_ZONE). Create these exactly as the information from the diagram states. Make no changes to this design. Your score for this section is based on how accurately you create the database from the information provided to you. Be sure you do the following in your CREATE TABLE and/or ALTER TABLE statements:
Insert your create table statements (and alter table statements if used) in the correct location of the CREATE TABLE
script provided separately (in the same Blackboard folder as this document).
Debug your script so that it deletes all 9 tables in the database and then recreates them (with any changes you may
have made in the statements). The provided but incomplete script is already set up for this. Just insert your
statements where indicated in the script (and debug)
Get Free Quote!
293 Experts Online