This is the question set along with answers Database Management System Spring 2016, which was taken by the Pokhara University.<\/p>\n
Pokhara University \u2013 Database Management System, Spring 2016<\/strong><\/p>\n Section “A”<\/strong><\/p>\n Very Short Answer Questions<\/strong><\/p>\n Attempt all the questions.<\/p>\n 1. Describe any two tables that might be used to store information in a social networking system such as Facebook. Section “B”<\/strong> Attempt any six questions 6\u00d710 Section “C”<\/p>\n Attempt all questions If you liked Database Management System || Spring 2016, then you May Also Like\u00a0Data Analysis and Modeling || Spring, 2016 || Pokhara University || BBA\/BBA-BI\/BBA-TT\/BCIS<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\n\n
\n Level:\u00a0 Bachelor<\/td>\n Semester \u2013Spring<\/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
\n2. What are the four main functions of a database administrator?
\n3. Define the terms: primary keys, candidate key, and super key.
\n4. Draw a relation showing the basic data structure model in it.
\n5. Write the function of \u2018GRANT\u2019 and \u2018REVOKE\u2019 in MySQL.
\n6. What is a Materialized View?
\n7. Enlist Basic data types used in DBMS.
\n8. Enlist the type of functional dependency.
\n9. How Lock-Based protocol works?
\n10. What are the various types of transaction failures?<\/p>\n
\nDescriptive Answer Questions<\/strong><\/p>\n
\n11. Illustrate mapping cardinality with suitable examples of each.
\n12. A database of a Library System consists of three minimum relations(a) Member, (b) book, and (c) issue. Draw a database schema along with the primary key, foreign key dependencies, relation name, and minimum of four attributes in each relation.
\n13. Consider the following relations:
\nCourse (CID, title, dept_name, credits)
\nStudent (SID, name, dept_name,tot_credits)
\nTeacher (TID, name, dept_name, salary)
\nWrite SQL statements to:
\na. Create relation student.
\nb. Find the titles of courses in the \u2018Computer Science\u2019 department that have 3 credits.
\nc. Find the highest salary of any Teacher.
\nd. Find all the teachers earning the highest salary (hint: there may be more than one with the same salary)
\ne. If you need to create a relation Teaching, what will be the attributes?
\n14. Illustrate the terms UNION, INTERSECT, DIFFERENCE, EXCEPT, and COMMIT with an example of each.
\n15. Check for redundancy of Functional Dependency in R (W X Y Z) with X \u2192W, WZ \u2192XY, Y \u2192WXZ. If exists convert it into canonical form.
\n16. What is ACID property? Explain serializability in Transaction.
\n17. How do you prevent deadlock? In data recovery, explain log-based recovery and checkpoint
\n18.<\/p>\n
\nRead the case situation given below and answer the questions that follow.
\nMoon Set Colony has 5 blocks of Towers (buildings). Each block has 15 floors of apartments. Each apartment has one guest room, one living room, one dining room, and two bedrooms. In the basement, every family gets a parking slot for one car and one motorcycle. A separate parking system is made for guests\/visitors. The management wants to install DBMS on the gate with the features:
\n\u2022 Any visitor is asked to tell the name of the resident of the colony s\/he wants to meet and it is verified in the database before entry.
\n\u2022 Visitor\u2019s detailed information is recorded.
\n\u2022 If the visitor is in the vehicle, its information also be recorded.
\n\u2022 Database also provides family details, location, the vehicular status of the people who reside in this colony.
\ni) Draw an E-R diagram of the system.
\nii) Enlist the max number of tables you require in the system.
\niii) Show all possible and relevant attributes of at least two tables.
\niv) Offer some Views (logical) of the system.<\/p>\n