
DBM 294 Week 2 Individual Assignment Data Definition Language
Instructions:
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_LastName where LastName is
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.
Submit, in addition to the one above, a file containing screen shots
which show the database with the name visible, and the tables showing
all columns, primary and foreign keys.
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.
Do NOT add any data to your tables - that will come in subsequent
weeks.
Questions & Answers
Have a Question?
Be the first to ask a question about this.