Table 1 Instructor Table CREATE TABLE Instructor FName VARCHAR2(20), LName VARCH
ID: 3841800 • Letter: T
Question
Table 1 Instructor Table CREATE TABLE Instructor FName VARCHAR2(20), LName VARCHAR2(20), Email VARCHAR2(20 Username VARCHAR2 (20 passwrd VARCHAR2(20), PRIMARY KEY Username Table 3 Messages Table CRFATF TABI F Messages Due DATF Subject VARCHAR2(20), Lmail VARCHAR2 (20), SName VARCIIAR2(20), Username VARCI IAR2 (20), MSG VARCIIAR2 (300) HORLIGN KLI (Usernam RFT R Table 5 Categories lable CRFATF TARI F Calegories Calld INTFGFR PCalld INTFGFR, Cat Name VARC IAR2020 CatPicture BLOB PRIMARY KLY (Catld), HORLIGN KLI (pCatld) RLHL. NCLS Categories Table 7 List Tuble CREATE TABLE Lst Lid INTEGER, e VARCHAR2 (20), Lnam Username VARCHAR2 (20) PRIMARY KEY (Lid FOREIGN KET Username REFERENCES RegUsers Table 2 RegUsers Table CREATE TABLE RegUsers FName VARCHAR2 (20), LName VARCHAR2 (20), Email VARCHAR2(200, Username VARCHAR2 (20), passwrd VARCHAR2 (20 PRIMARY KEY (username), FOREIGN KET (Username) REFERENCES Re sers Table 4 Dictionary Table CRLAIL Dictionary LIABLL words VARCIAR2(20), picture BLOB, OB Table 6 Question Table CRFATF TABI F Question Qid INTFGFR Lexi VARCHAR2 (60), Canswer MARCI IAR2(40), optionl VARCIAR2(40 option VARCIIAR2040 option VARCIIAR2(40), PRIMARY KLY (Qid)); Table 8 Exam Table CREATE TABLE Exam Exam o INTEGER Tme NUMBER LV VARCHAR2 20 PRIMARY KEY (ExamNo)Explanation / Answer
1) Queries Applied on Instructor Table:
All users with last name Mohammad
SELECT * FROM Instructor where LNAME = 'Mohammad'
All users with first name Sara
SELECT * FROM Instructor where FNAME = 'Sara'
All the information about the registered users
SELECT * FROM RegUsers
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.