Hello, I am having issues getting my tables to work properly. If anyone would be

Question

Hello,

I am having issues getting my tables to work properly. If anyone would be able to write the steps out on how to do it (my book isnt very helpful in directions). Below are the directions for the first part of the lab.

The goal is develop a database for the Wedgewood Pacific Corporation using MS SQL Server . In MS SQL Server, create a new database called WPC. 2. Create the DEPARTMENT and EMPLOYEE tables shown below along with the PROJECT and ASSIGNMENT tables shown on the next page, and set the relationships between the tables explained below: DEPARTMENT Column Name Required Remarks Type nvarchar(35) Primary KeyYes nvarchar(30) No nvarchar(15) No nvarchar 12) No Key Yes Yes Yes OfficeNumber Phone EMPLOYEE Column Name Required Type bigint: Identity Primary KeyYes nvarchar(25) No nvarchar(25) No nvarchar(35) Foreign KeyYes nvarchar(12 No nvarchar(100) No Key Remarks Surrogate Key Yes Yes Phone No Emai

Explanation / Answer

You can create a MySQL database by using MySQL Command Line Client.

Open the MySQL console and write down password, if you set one while installation.

creating database called WPC:

creating table department:

CREATE TABLE Department(  

DepartmentName VARCHAR(35) NOT NULL ,  

BudgetCode VARCHAR(30) NOT NULL,  

   OfficeNumber VARCHAR(15) NOT NULL,

Phone VARCHAR(15) NOT NULL,  

   PRIMARY KEY ( DepartmentName)

);

creating table Employee:

CREATE TABLE Employee(  

EmployeeNumber [bigint] IDENTITY(1,1) NOT NULL ,  

FirstName VARCHAR(25) NOT NULL,  

LastNAme VARCHAR(25) NOT NULL,

Department VARCHAR(35) NOT NULL,

Phone  VARCHAR(12) ,

Email  VARCHAR(100) NOT NULL,

   PRIMARY KEY ( EmployeeNumer)

);

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.