Hello NPTEL Learners, In this article, you will find NPTEL Introduction to Database Systems Assignment 6 Week 6 Answers 2023. All the Answers are provided below to help the students as a reference don’t straight away look for the solutions, first try to solve the questions by yourself. If you find any difficulty, then look for the solutions.
NPTEL Introduction to Database Systems Assignment 6 Answers 2023 Join Group👇
Note: We are trying to give our best so please share with your friends also.
NPTEL Introduction to Database Systems Assignment 6 Answers 2023:
We are updating answers soon Join Group for update: CLICK HERE
Use the following schema of the academic institution relational database in the following questions wherever required.
student(rollNo, name, degree, year, sex, deptNo, advisor)
department(deptId, name, hod, phone)
professor(empId, name, sex, startYear, deptNo, phone)
course(courseId, cname, credits, deptNo)
enrollment(rollNo, courseId, sem, year, grade)
teaching(empId, courseId, sem, year, classRoom)
preRequisite(preCourseId, courseId)
deptNo is a foreign key in the student, professor and course relations referring to deptId of department relation;
advisor is a foreign key in the student relation referring to empId of professor relation;
hod is a foreign key in the department relation referring to empId of professor relation;
rollNo is a foreign key in the enrollment relation referring to rollNo of student relation;
courseId is a foreign key in the enrollment, teaching relations referring to courseId of course relation;
empId is a foreign key of the teaching relation referring to empId of professor relation;
preCourseId and courseId are foreign keys in the preRequisite relation referring to courseId of the course relation.
Q.1. Under which of the following conditions, the update operations on views are NOT allowed?
(i) if the view definition has an aggregate operator
(ii) if the view definition includes two or more tables
(iii) if the view is defined on a single table without group by, aggregates and the SELECT clause includes the primary key of the table
State whether the following statements are true or false.
Q.2. HAVING clause can be used in a query only if GROUP BY clause is used
- True
- False
Q.3. GROUP BY clause can be used in a query only if HAVING clause is used
- True
- False
NPTEL Introduction to Database Systems Assignment 7 Answers Join Group👇
Q.4. It is mandatory to use an aggregate function in a query if GROUP BY clause is used
- True
- False
Q.5. Aggregate functions can be used in GROUP BY clauses
- True
- False
Q.6. In which of the following SQL clauses of a main query can a sub-query be made use of ?
(i) FROM (ii) WHERE (iii) HAVING
Q.7. Which of the following queries would select the courses with at least 10 ‘W’ grades in some offering of the course ?
- Answer: A
NPTEL Introduction to Database Systems Week 6 Answers Join Group👇
CLICK HERE
Q.8. Which of the following queries will retrieve students whose name has ‘p’ as the second letter ?
- SELECT rollNo FROM student where name = ‘_p’;
- SELECT rollNo FROM student where name LIKE ‘_p’;
- SELECT rollNo FROM student where name LIKE ‘_p%’;
- SELECT rollNo FROM student where name IN ‘_p%’;
Q.9. Consider two instances of the relations R1(A, B) and R2 (C, D) with the number of rows 10 and 8, respectively. What is the least possible number of tuples in the result of the following query?
SELECT *
FROM R1 FULL OUTER JOIN R2 ON R1.A = R2.C
- 0
- 18
- 8
- 10
Q.10. Consider the following queries. Which of the following queries is correct to find the courses with no prerequisites?
(i) SELECT courseId
FROM preRequisite
GROUP BY courseId
HAVING count(preCourseId) = 0
(ii) SELECT courseId
FROM preRequisite a
WHERE NOT EXISTS (
SELECT preCourseId FROM preRequisite b WHERE a.courseId = b.courseId)
Which of the following statements is correct regarding the above query?
Q.11. Which of the following queries would find the id and name of the senior-most hod(s)?
- Answer: A
Q.12. Which one of the following queries would find the teacher(s) who taught CS1100 the highest number of times?
- Answer: D
Q.13. Answer: C
NPTEL Introduction to Database Systems Assignment 6 Answers Join Group👇
Disclaimer: This answer is provided by us only for discussion purpose if any answer will be getting wrong don’t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided by Chase2learn. This tutorial is only for Discussion and Learning purpose.
About NPTEL Introduction to Database Systems Course:
Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard
Course Outcome:
- Week 1 : Introduction and part of E/R Model Module
- Week 2 : ER Model Module
- Week 3 : Relational Model Module
- Week 4 : Relational Model Module
- Week 5 : TRC Module and part of SQL Module
- Week 6 : SQL Module
- Week 7 : Indexes Module
- Week 8 : Indexes Module + Query Processing Module
- Week 9 : Normal Forms Module
- Week 10 : Normal Forms Module
- Week 11 : Transaction Processing Module
- Week 12 : Transaction Processing Module
CRITERIA TO GET A CERTIFICATE:
Average assignment score = 25% of average of best 8 assignments out of the total 12 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100
Final score = Average assignment score + Exam score
YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.
If you have not registered for exam kindly register Through https://examform.nptel.ac.in/
Join Our Telegram Group:- CLICK HERE