Tables, Keys, and Constraints


 

Start the VM for assignment three. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then select the AdventureWorksDW2017 database for this assignment.

In this assignment, students will create database tables and implement keys and restraints.

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 Microsoft Excel 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 BusinessEntityID column as an integer. Include a DoB (Date of Birth) column and a date format.
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.

 

 

The post Tables, Keys, and Constraints first appeared on COMPLIANT PAPERS.



This essay is written by:

Prof. SirMojo Verified writer

Finished papers: 435

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Hire This Writer
© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
How to Avoid Plagiarism
  • Use multiple resourses when assembling your essay
  • Use Plagiarism Checker to double check your essay
  • Get help from professional writers when not sure you can do it yourself
  • Do not copy and paste free to download essays
Get plagiarism free essay
Need Help? Chat with us
Loading...