Question: Create a database named MyWorkPlace. Before issuing the Create database statement, drop the database if it exists. Information about the database should be located in

Create a database named MyWorkPlace. Before issuing the Create database statement, drop the database if it exists. Information about the database should be located in the Master database. Use the instructor video, notes and MyGuitarShop script as a guide. Within the MyWorkPlace database, create the following tables:
Create Table Employee
(
Emp_Fname varchar(max),
Emp_Lname varchar(max),
Emp_Addr varchar(max),
Emp_City varchar(max),
Emp_State varchar(255),
Emp_Zip varchar(255),
Emp_Salary decimal (6,2),
Dept_Num INT REFERENCES Department (Dept_Num),
)
Create Table Department
(Using SSMS,
Dept_Num INT PRIMARY KEY,
Dept_name varchar(255)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!