Tables/Keys/Constraints-Start the VM for assignment three. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), select the Database Engine as the server type, and then click Connect. Select Databases, then create a new query within the most current version of AdventureWorks database for this assignment.
In this assignment, students will create database tables and implement keys and restraints.
Using Tables/Keys/Constraints,the human resources department has requested that you create a table that can be used to store birthdays in the database. This table will be used to support a newsletter that is distributed internally to report on office events.
Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a CSV file for a visual check of accuracy.
Create a Microsoft Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to provide a screenshot for each.
- Create a new table called Birthday with the following columns: BusinessEntityID column as an integer, and a DoB (Date of Birth) column in as date.
- Add a constraint to make BusinessEntityID a primary key.
- Insert one record for BusinessEntityID 1 and include 1990/01/01 as the birthday.
- Once added, query your new table showing the new record.
Submit the Word document (with screenshots) that show Tables/Keys/Constraints.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Answer Preview-Tables, Keys, and Constraints-SYM-400
