Contents. ERD 2. TABLES with insert commands 2. QUERIES

Added on - 18 Oct 2019

  • 7

    pages

  • 505

    words

  • 41

    views

  • 0

    downloads

Showing pages 3 of 7
ContentsERD.............................................................................................................................................................2TABLES with insert commands..................................................................................................................2QUERIES....................................................................................................................................................4Q1)...........................................................................................................................................................4Q2)...........................................................................................................................................................6Q3)...........................................................................................................................................................6
ERDTABLES with insert commandsCREATE DATABASE EMP_GROUP_DB;USE EMP_GROUP_DB;CREATE TABLE USERS(userID INT PRIMARY KEY,user_name VARCHAR(20) NOT NULL);
INSERT INTO USERS VALUES(1,'Modesto'),(2,'Ayine'),(3,'Christopher'),(4,'Cheong woo'),(5,'Saulat'),(6,'Heidy');CREATE TABLE GROUPS(groupID INT PRIMARY KEY,group_name VARCHAR(30)NOT NULL);INSERT INTO GROUPS VALUES(10,'I.T.'),(11,'Sales'),(12,'Administration'),(13,'Operations');CREATE TABLE ROOMS(roomID INT PRIMARY KEY,roomName VARCHAR(30) NOT NULL);INSERT INTO ROOMS VALUES(1,'101'),(2,'102'),(3,'Auditorium A'),(4,'Auditorium B');CREATE TABLE USERS_GROUP(userID INT,groupID INT,PRIMARY KEY( userID, groupID),FOREIGN KEY (userID) REFERENCES USERS(userID),FOREIGN KEY (groupID) REFERENCES GROUPS(groupID));