Problem: Implement a database that matches the specifications developed in your Week One individual assignment.

Submit a file containing the SQL code needed to perform the following tasks:

• Create a database named DBM294_LastNamewhereLastNameis replaced with your own last name.
• Create the tables you designed in week one within this database.
• Create the primary and foreign key constraints on those tables in accordance with the original specification.

Your document should be a plain text file (not an MS Office document, PDF, or similar), and it should contain nothing but the SQL code needed to do the above. Make sure that executing your code will result in the creation of the database, tables, and related constraints. This means that you should test your code live against Microsoft^® SQL Server^® in the Toolwire^®environment.

You may use the GUI tools to perform the above tasks and then generate the associated SQL scripts automatically, but again, you should test the execution of those scripts before submitting them.