INFO $2630$: REVIEW ASSIGNMENT

SQL

Now that you know how to create a database, add data to it$,$ retrieve it$,$ manipulate it$,$ and

change it$,$ let's look at an example end to end!

Task $1$: Write a create script $(30$ pts$)$

Using the ERD pictured below, write all the table and constraint creation statements you

would need to create the database in a single file: creat.sq$|$

Make sure to end each statement with a semicolon $($

The creation scripts we have used in class are a great guide!

At the top of the file, write a statement to drop $($if the database exists$),$ create and use

the appropriate database. Name your database school.

Save your script as a $.$sql file.

Task $2$: Execute your creation scripts

Run your database creation scripts on your database server.

If you encounter any errors, address the issue and run the script again. This is

why we start the script by first dropping the database if it already exists.