StudentName VARCHAR2(25),
Computers and Technology, 20.09.2020 16:01 cat706
CREATE TABLE Student_T
(StudentID NUMBER NOT NULL,
StudentName VARCHAR2(25),
CONSTRAINT Student_PK PRIMARY KEY (StudentID));
CREATE TABLE Faculty_T
(FacultyID NUMBER NOT NULL,
FacultyName VARCHAR2(25),
CONSTRAINT Faculty_PK PRIMARY KEY (FacultyID));
CREATE TABLE Course_T
(CourseID CHAR(8) NOT NULL,
CourseName VARCHAR2(15),
CONSTRAINT Course_PK PRIMARY KEY (CourseID));
CREATE TABLE Section_T
(SectionNo NUMBER NOT NULL,
Semester CHAR(7) NOT NULL,
CourseID CHAR(8),
CONSTRAINT Section_PK
PRIMARY KEY(CourseID, SectionNo, Semester),
CONSTRAINT Section_FK FOREIGN KEY (CourseID)
REFERENCES Course_T (CourseID));
CREATE TABLE Qualified
(FacultyID NUMBER NOT NULL ,
CourseID CHAR(8) NOT NULL,
DateQualified DATE,
CONSTRAINT IsQualified_PK PRIMARY KEY (FacultyID, CourseID),
CONSTRAINT QualifiedFaculty_FK FOREIGN KEY (FacultyID) REFERENCES Faculty_T (FacultyID),
CONSTRAINT QualifiedCourse_FK FOREIGN KEY (CourseID) REFERENCES Course_T (CourseID));
CREATE TABLE Registration_T
(StudentID NUMBER NOT NULL,
SectionNo NUMBER NOT NULL,
Semester CHAR(7) NOT NULL,
CONSTRAINT IsRegistered_PK PRIMARY KEY (StudentID, SectionNo, Semester),
CONSTRAINT StudentIsRegistered_FK FOREIGN KEY(StudentID)
REFERENCES Student_T(StudentID),
CONSTRAINT CourseIsRegistered_FK
FOREIGN KEY (SectionNo, Semester)
REFERENCES Section_T(SectionID, Semester));
Required:
a. Write SQL queries to answer the following questions:
b. Which students have an ID number that is less than 50000?
c. What is the name of the faculty member whose ID is 4756?
d. What is the smallest section number used in the first semester of 2008?
e. How many students are enrolled in Section 2714 in the first semester of 2008?
f. Which faculty members have qualified to teach a course since 1993? List the faculty ID, course and date of qualification.
Answers: 2
Computers and Technology, 22.06.2019 05:10
Read the code below. what will the computer print if the input for year_variable is 1700? if year_variable == 1776: print("your answer is correct. the declaration of independence was signed in “year_variable”.") elif year_variable < 1776: compute_variable = 1776 - year_variable. print("add “compute_variable“ years to your answer for the correct answer.") elif year_variable > 1776: compute_variable = year_variable - 1776 print("subtract “compute_variable” years from your answer for the correct answer.")
Answers: 1
Computers and Technology, 22.06.2019 10:00
According to alisa miller foreign news bureaus
Answers: 3
Computers and Technology, 22.06.2019 11:30
What do character formats do for your document's message? a.set the tone b.provide organization c.provide clarity d.set how texts align with documents
Answers: 2
Computers and Technology, 22.06.2019 15:00
Who is the first president to use social media as part of his campaign strategy
Answers: 1
CREATE TABLE Student_T
(StudentID NUMBER NOT NULL,
StudentName VARCHAR2(25),
StudentName VARCHAR2(25),
Mathematics, 01.03.2021 17:10
English, 01.03.2021 17:10
English, 01.03.2021 17:10
Mathematics, 01.03.2021 17:10
Mathematics, 01.03.2021 17:10
Chemistry, 01.03.2021 17:10
History, 01.03.2021 17:10
Mathematics, 01.03.2021 17:10
Chemistry, 01.03.2021 17:10