11.Which of the following query finds the names of the employees who have taught at least one course? a)SELECT DISTINCT e.ename FROM employee e, course c WHERE e.eid = c.cid; b)SELECT e.ename FROM employee, course WHERE e.eid = c.cid; c)None of these d)SELECT e.ename FROM employee e, course c WHERE e.eid = c.cid; 12.If A-> B, C,D,E and D -> E are functional dependencies of the relation R(A,B,C,D,E) Then identify the best normal form of the given relation R. a)2NF b)BCNF c)3NF d)1NF 13.The attributes of relationship completes in employee completes course should be a)empid, cno, cname, grade b)empid, cno, grade c)empid, ename, dept, phone no d)cno, cname, grade
11.Which of the following query finds the names of the employees who have taught at least one course?
a)SELECT DISTINCT e.ename FROM employee e, course c WHERE e.eid = c.cid;
b)SELECT e.ename FROM employee, course WHERE e.eid = c.cid;
c)None of these
d)SELECT e.ename FROM employee e, course c WHERE e.eid = c.cid;
12.If A-> B, C,D,E and D -> E are functional dependencies of the relation R(A,B,C,D,E)
Then identify the best normal form of the given relation R.
a)2NF
b)BCNF
c)3NF
d)1NF
13.The attributes of relationship completes in employee completes course should be
a)empid, cno, cname, grade
b)empid, cno, grade
c)empid, ename, dept, phone no
d)cno, cname, grade
14.What is the meaning of LIKE 'a%a%'
a)Feature ends with two a's
b)Feature begins with two a's
c)Feature has two a's in it, at any position
d)Feature begins with a and has at least one a's in it at any position
15.If in JOIN operation, conditions of JOIN operation are not satisfied then results of operation is
a)zero tuples and empty relation
b)one tuple from one relation
c)one tuple from two relation
d)two tuples from empty relations
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)