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

Added on - 22 Sep 2019

  • 15

    Pages

  • 519

    Words

  • 231

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 15 pages
ContentsERD.............................................................................................................................................................2TABLES with insert commands..................................................................................................................2EXECUTION SCREEN SHOTS.........................................................................................................................4All tables list............................................................................................................................................8QUERIES..................................................................................................................................................12Q1).........................................................................................................................................................12Q2).........................................................................................................................................................14Q3).........................................................................................................................................................14
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));
INSERT INTO USERS_GROUP VALUES(1,10),(2,10),(3,11),(4,11),(5,12);CREATE TABLE GROUP_ACCESS_ROOMS(groupID INT,roomID INT,PRIMARY KEY( groupID,roomID),FOREIGN KEY (roomID) REFERENCES ROOMS(roomID),FOREIGN KEY (groupID) REFERENCES GROUPS(groupID));INSERT INTO GROUP_ACCESS_ROOMS VALUES(10,1),(10,2),(11,2),(11,3);EXECUTION SCREEN SHOTS
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document