Reference no: EM132274414

Complete the following using SQL Server:

Create/ save a new database.

Create/ save four database tables in the database, based on the following table layout:

Department

Department Number (integer) - Primary key

Department Name (characters)

Employee

First Name (characters)

Last Name (characters)

SSN (integer) - primary key

Salary (money or decimal)

Department Number (integer)

Project

Project Name (characters)

Project Number (integer) - primary key

Department Number (integer)

Project Assignment

Employee SSN (integer) - primary key

Project Number (integer)

Input five records into each table.

Save your database tables.

Capture and paste screenshots of your database and tables into a Microsoft PowerPoint presentation or Word document