This is the question set along with answers Database Management System Fall 2016, which was taken by the Pokhara University.<\/p>\n
Pokhara University \u2013 Database Management System<\/strong>\u00a0Fall 2016<\/strong><\/p>\n Section “A”<\/strong><\/p>\n Very Short Answer Questions<\/strong><\/p>\n Attempt all the questions.<\/p>\n Section “B”<\/strong> Attempt any six questions Section “C”<\/strong> 18. Draw an entity-relationship diagram for the following information\u2019s: If you liked our content Database Management System || Fall, 2016<\/strong> then, you may also like\u00a0Data Analysis and Modeling || Fall, 2016 || Pokhara University || BCIS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\n\n
\n Level:\u00a0 Bachelor<\/td>\n Semester \u2013Fall<\/td>\n \u00a0Year: 2016<\/td>\n<\/tr>\n \n Program: BCIS<\/td>\n \u00a0Full Marks: 100<\/td>\n<\/tr>\n \n Course: Database Management System<\/td>\n \u00a0 Pass Marks: 45<\/td>\n<\/tr>\n \n \u00a0\u00a0\u00a0\u00a0 Time:\u00a0 3hrs.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \n
\nDescriptive Answer Questions<\/strong><\/p>\n
\n11. Consider the following relations:
\nCourse (course id, title, dept_name, credits)
\nStudent (ID,name,dept_name,tot_cred)
\nInstructor (ID, name, dept_name, salary)
\nWrite SQL statements:
\na. Find the titles of courses in \u2018Computer Science\u2019 department that have 3 credits.
\nb. Create relation student.
\nc. Find the highest salary of any instructor.
\nd. Find all the instructors earning the highest salary (hint: there may be more than one with the same salary)
\n12. What is a Materialized view? Illustrate about \u2018commit\u2019 and \u2018rollback\u2019 in transaction.
\n13. What is ACID property? Explain about serializability in Transaction.
\n14.Define data normalization? Explain 1NF, 2NF, 3NF with suitable example.
\n15. What is recovery system? What are the failures of database? Explain its type.
\n16. Why concurrency control is required? List various state of transaction.
\nExplain lock base protocols.
\n17. a) What is schema diagram? Give an example.
\nb) Discuss the desirable properties of decomposition.<\/p>\n
\nCase Analysis<\/strong><\/p>\n
\n-A college contains many departments
\n– Each department can offer any number of courses
\n-Many instructors can work in a department
\n-An instructor can work only in one department
\n-For each department there is a Head
\n-An instructor can be head of only one department
\n-Each instructor can take any number of courses
\n-A course can be taken by only one instructor
\n-A student can enrol for any number of course
\n-Each course can have any number of students
\nAssume your own entity and attributes.<\/p>\n