Use master

DROP DATABASE Assignment_duongvtph00550

GO

CREATE DATABASE Assignment_duongvtph00550

Go

USE Assignment_duongvtph00550

Go

CREATE TABLE PHONG(

MA_PHONG varchar(10) PRIMARY KEY,

TEN_PHONG nvarchar(40) NOT NULL,

)

CREATE TABLE BAN(

MA_BAN varchar(10) PRIMARY KEY,

TEN_BAN nvarchar(40) NOT NULL,

MA_PHONG varchar(10)REFERENCES PHONG(MA_PHONG)

)

CREATE TABLE THE_LOAI(

MA_THE_LOAI varchar(10) PRIMARY KEY,

TEN_THE_LOAI nvarchar(40) NOT NULL

)

CREATE TABLE MON_AN(

MA_MON varchar(10) PRIMARY KEY,

TEN_MON nvarchar(40) NOT NULL,

GIA_TIEN int NOT NULL,

MA_THE_LOAI varchar(10)REFERENCES THE_LOAI(MA_THE_LOAI)

)

CREATE TABLE DANG_NHAP(

TEN_DANG_NHAP varchar(30) PRIMARY KEY,

MAT_KHAU varchar(30) NOT NULL,

QUYEN_HAN varchar(20) NOT NULL,

)

INSERT INTO PHONG

VALUES('P01', N'Phòng 1')

INSERT INTO PHONG

VALUES('P02', N'Phòng 2')

INSERT INTO PHONG

VALUES('P03', N'Phòng 3')

INSERT INTO BAN

VALUES('B01', N'Bàn 1', 'P01')

INSERT INTO BAN

VALUES('B02', N'Bàn 2', 'P01')

INSERT INTO BAN

VALUES('B03', N'Bàn 3', 'P02')

INSERT INTO BAN

VALUES('B04', N'Bàn 4', 'P02')

INSERT INTO BAN

VALUES('B05', N'Bàn 5', 'P03')

INSERT INTO BAN

VALUES('B06', N'Bàn 6', 'P03')

INSERT INTO BAN

VALUES('B07', N'Bàn 7', 'P03')

INSERT INTO THE_LOAI

VALUES('TL1', N'Nước khoáng')

INSERT INTO THE_LOAI

VALUES('TL2', N'Nước ngọt')

INSERT INTO THE_LOAI

VALUES('TL3', N'Nước ép')

INSERT INTO THE_LOAI

VALUES('TL4', N'Đồ ăn nhanh')

INSERT INTO THE_LOAI

VALUES('TL5', N'Kem')

INSERT INTO MON_AN

VALUES('F001', N'Nước khoáng Lavie','20000', 'TL1')

INSERT INTO MON_AN

VALUES('F002', N'Cafe', '12000', 'TL2')

INSERT INTO MON_AN

VALUES('F003', N'Cocacola', '20000', 'TL2')

INSERT INTO MON_AN

VALUES('F004', N'Nước ổi ép', '25000', 'TL3')

INSERT INTO MON_AN

VALUES('F005', N'Bánh Hăm-Bơ-Gơ', '18000', 'TL4')

INSERT INTO MON_AN

VALUES('F006', N'Khoai tây chiên', '15000', 'TL4')

INSERT INTO MON_AN

VALUES('F007', N'Nem chua rán', '25000', 'TL4')

INSERT INTO MON_AN

VALUES('F008', N'Kem thập cẩm', '22000', 'TL5')

INSERT INTO MON_AN

VALUES('F009', N'Kem chocolate', '25000', 'TL5')

INSERT INTO DANG_NHAP

VALUES('admin', 'admin', 'admin')

INSERT INTO DANG_NHAP

VALUES('thungan1', '123456', 'thungan')

INSERT INTO DANG_NHAP

VALUES('thungan2', '123456', 'thungan')