Contents. ERD 2. TABLES with insert commands 2. EXECUTI
Added on -2019-09-22
| 15 pages
| 519 words
| 313 views
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
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan