In this assignment, will start to Build/Implement your Database in MS SQL Server.. Based on the ERD:
Fantastic news! We've Found the answer you've been seeking!
Question:
In this assignment, will start to Build/Implement your Database in MS SQL Server..
Based on the ERD:
- CREATE all tables
- INSERT data - add at least 10 records for each table
- TEST the implementation - Write SQL statements to test the implementation
Tasks: Review the resources below to complete this assignment. You have five tasks:
**** Upload screenshots for each of the above in a Word file explaining your process and what problems you experienced.
- Review this source for how to create SQL Server Database — Create, Alter, Drop, Restore.
- Review this source for how to create SQL Server Table — CREATE, ALTER, DROP [T-SQL Examples].
- Review this source for how to create SQL PRIMARY KEY — How to Create & Add to Existing Table.
- Review this source for how to create SQL FOREIGN KEY — How to Create in SQL Server with Example.
- Review this source for how to create SQL SERVER JOINS Tutorial — INNER, LEFT, RIGHT, OUTER
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: