Using the schema below:

• STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)

• DEPT(Did, Dname)

• PROF(Pid, Pname, Did, Birth_Date)

• COURSE(Cno, Did, Cname)

• SECTION(Sectno, Did, Cno, Pid)

• ENROLL(Eid, Sid, Cno, Sectno, Grade)

Which SQL query retrieves department names that have fewer than 5 professors?

 _______ is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined.

The functional dependency that is present between multiple non-key attributes is known as:

Which of the following is not Armstrong’s Axiom?

Every weak entity set can be converted into a strong entity set by:

Which is following answer is not aggregate function in the sql: (Choose all that apply)

Using the schema:

● STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)

● DEPT(Did, Dname)

● PROF(Pid, Pname, Did, Birth_Date)

● COURSE(Cno, Did, Cname)

● SECTION(Sectno, Did, Cno, Pid)

● ENROLL(Eid, Sid, Cno, Sectno, Grade)

Which SQL query correctly finds the maximum grade of students who have enrolled in the course with ID 7?

Which SQL clause is used to filter the results of grouped data when using aggregate functions?

An entity set that has a primary key is called a ___________

If B is an attribute and A→B, Then B is said to be ________ by a.