Uxd9qmqe

1### Database Task
2
3Create SQL
4	HelpdeskDatabase
5
6	Users
7		UserId      (Int)  IDENTITY PRIMARY KEY NOT NULL
8		UserName  	(VarChar(50))  NULL
9		CategoryId  (Foreign Key)  NULL
10	
11	Categories
12		CategoryId  INT
13		CategoryName VARCHAR (50)
14
15	Insert sample data : 2 users, 3 categories admin/techsupport/user
16
17```sql
18USE master
19Go
20
21DROP DATABASE IF EXISTS HelpdeskDatabase
22GO
23
24CREATE DATABASE HelpdeskDatabase
25GO
26
27USE HelpdeskDatabase 
28GO
29
30DROP TABLE IF EXISTS Users 
31DROP TABLE IF EXISTS Categories 
32GO
33
34
35CREATE TABLE Categories(
36	CategoryId INT NOT NULL IDENTITY PRIMARY KEY,
37	CategoryName VARCHAR(50) NULL
38)
39
40CREATE TABLE Users(
41	UserId INT NOT NULL IDENTITY PRIMARY KEY,
42	UserName VARCHAR(50) NULL,
43	CategoryId INT NULL, 
44	FOREIGN KEY (CategoryId) REFERENCES Categories (CategoryId)
45)
46
47INSERT INTO Categories VALUES ('Admin')
48INSERT INTO Categories VALUES ('TechSupport')
49INSERT INTO Categories VALUES ('User')
50INSERT INTO Users VALUES ('Bob',1)
51INSERT INTO Users VALUES ('Bill',3)
52INSERT INTO Users VALUES ('Ben',2)
53SELECT * FROM Categories
54SELECT * FROM Users