{"id":932,"date":"2021-04-26T05:50:17","date_gmt":"2021-04-26T05:50:17","guid":{"rendered":"https:\/\/bcisnotes.com\/fourthsemester\/?p=932"},"modified":"2021-04-26T05:50:17","modified_gmt":"2021-04-26T05:50:17","slug":"database-management-system-fall-2017-pokhara-university-bcis","status":"publish","type":"post","link":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/","title":{"rendered":"Database Management System || Fall, 2017 || Pokhara University || BCIS"},"content":{"rendered":"

Database Management System – Fall, 2017<\/h2>\n

This is the question set along with answers to Database Management System Fall 2017, which was taken by the Pokhara University.<\/p>\n

Pokhara University \u2013 Database Management System <\/strong>Fall 2017<\/strong><\/p>\n\n\n\n\n\n\n
Level:\u00a0 Bachelor<\/td>\nSemester \u2013Fall<\/td>\n\u00a0Year: 2017<\/td>\n<\/tr>\n
Program: BCIS<\/td>\n\u00a0Full Marks: 100<\/td>\n<\/tr>\n
Course: Database Management System<\/td>\n\u00a0 Pass Marks: 45<\/td>\n<\/tr>\n
\u00a0\u00a0\u00a0\u00a0 Time:\u00a0 3hrs.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Section “A”<\/p>\n

Very Short Answer Questions<\/strong><\/p>\n

Attempt all the questions.<\/p>\n

    \n
  1. Define database system.<\/li>\n
  2. Define data model<\/li>\n
  3. What are inner joins?<\/li>\n
  4. Define remote backup system.<\/li>\n
  5. What are the characteristics of a relational database?<\/li>\n
  6. Define query language.<\/li>\n
  7. What are aggregate functions?<\/li>\n
  8. What are database anomalies?<\/li>\n
  9. What are ACID properties?<\/li>\n
  10. Define log-based protocols.
    \nSection “B”<\/p>\n

    Descriptive Answer Questions<\/strong><\/p>\n

    Attempt any six<\/strong> questions<\/li>\n

  11. What is application architecture? Explain one-tier and two-tier architecture.<\/li>\n
  12. What is locking? Explain two-phase locking.<\/li>\n
  13. What is the structure of a relational database? Explain with the figure.<\/li>\n
  14. Consider the following relations and perform the following operations:
    \nSuppliers(sid,sname,address)
    \nParts(pid,pname,color)
    \nCatalog(sid,pid,cost)
    \nI. Find the names of suppliers who supply some red parts.
    \nII. Find the sids of suppliers who supply some red or green parts.
    \nIII. Find the pids of the most expensive parts supplied by suppliers named Yasmin shah.
    \nIV. Update supplier\u2019s name whose address is Kathmandu<\/li>\n
  15. Define data normalization? Explain 2NF with a suitable example.<\/li>\n
  16. What is a recovery system? What are the failures of the database? Explain its type.<\/li>\n
  17. Why concurrency control is required? List various states of Transaction. Explain lock base protocols.
    \nSection”C”<\/p>\n

    Case Analysis<\/strong><\/li>\n

  18. Draw an entity-relationship diagram for the University database as information provided below:\u2013 A lecturer, identified by his or her number, name, and room number, is responsible for organizing a number of course modules.
    \n\u2013 Each module has a unique code and also a name and each module can involve a number of lecturers who deliver part of it.
    \n\u2013 A module is composed of a series of lectures and because of economic constraints and common sense, sometimes lectures on a given topic can be part of more than one module.
    \n\u2013 A lecture has a time, room, and date and is delivered by a lecturer and a lecturer may deliver more than one lecture.
    \n\u2013 Students, identified by number and name, can attend lectures and a student must be registered for a number of modules and also store the date.
    \n\u2013 Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor.<\/li>\n<\/ol>\n

    If you liked Database Management System || Fall, 2017 then, you may also like\u00a0Fundamentals of Organizational Behaviour || Fall,2017 || Pokhara University || BBA\/BBA-BI\/BBA-TT\/BCIS\/BHCM<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    Database Management System – Fall, 2017 This is the question set along with answers to Database Management System Fall 2017, which was taken by the […]<\/a><\/p>\n<\/div>","protected":false},"author":3,"featured_media":933,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[27,278,270],"yoast_head":"\nDatabase Management System || Fall, 2017 || Pokhara University || BCIS<\/title>\n<meta name=\"description\" content=\"This is the question set along with answers Database Management System Fall 2017, which was taken by the Pokhara University.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Management System || Fall, 2017 || Pokhara University || BCIS\" \/>\n<meta property=\"og:description\" content=\"This is the question set along with answers Database Management System Fall 2017, which was taken by the Pokhara University.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\" \/>\n<meta property=\"og:site_name\" content=\"BCIS Fourth Semester\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-26T05:50:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png\" \/>\n\t<meta property=\"og:image:width\" content=\"340\" \/>\n\t<meta property=\"og:image:height\" content=\"230\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Her Highness\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Her Highness\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\"},\"author\":{\"name\":\"Her Highness\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/fcc10e27b06f3f95367e914911b47eb3\"},\"headline\":\"Database Management System || Fall, 2017 || Pokhara University || BCIS\",\"datePublished\":\"2021-04-26T05:50:17+00:00\",\"dateModified\":\"2021-04-26T05:50:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\"},\"wordCount\":431,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#organization\"},\"image\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png\",\"keywords\":[\"Database management system\",\"DBMS questions\",\"Question Bank\"],\"articleSection\":[\"Q\/A\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\",\"name\":\"Database Management System || Fall, 2017 || Pokhara University || BCIS\",\"isPartOf\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png\",\"datePublished\":\"2021-04-26T05:50:17+00:00\",\"dateModified\":\"2021-04-26T05:50:17+00:00\",\"description\":\"This is the question set along with answers Database Management System Fall 2017, which was taken by the Pokhara University.\",\"breadcrumb\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png\",\"contentUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png\",\"width\":340,\"height\":230,\"caption\":\"Database Management System || Fall, 2017 || Pokhara University || BCIS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bcisnotes.com\/fourthsemester\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Management System || Fall, 2017 || Pokhara University || BCIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#website\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/\",\"name\":\"BCIS Fourth Semester\",\"description\":\"Notes of Information and Technology\",\"publisher\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bcisnotes.com\/fourthsemester\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#organization\",\"name\":\"BCIS Fourth Semester\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg\",\"contentUrl\":\"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg\",\"width\":300,\"height\":100,\"caption\":\"BCIS Fourth Semester\"},\"image\":{\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/fcc10e27b06f3f95367e914911b47eb3\",\"name\":\"Her Highness\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9f5c6e84ebb073447dba2985b41b0fdc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9f5c6e84ebb073447dba2985b41b0fdc?s=96&d=mm&r=g\",\"caption\":\"Her Highness\"},\"sameAs\":[\"http:\/\/bcisnotes.com\/fourthsemester\"],\"url\":\"https:\/\/bcisnotes.com\/fourthsemester\/author\/jaya\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Management System || Fall, 2017 || Pokhara University || BCIS","description":"This is the question set along with answers Database Management System Fall 2017, which was taken by the Pokhara University.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/","og_locale":"en_US","og_type":"article","og_title":"Database Management System || Fall, 2017 || Pokhara University || BCIS","og_description":"This is the question set along with answers Database Management System Fall 2017, which was taken by the Pokhara University.","og_url":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/","og_site_name":"BCIS Fourth Semester","article_published_time":"2021-04-26T05:50:17+00:00","og_image":[{"width":340,"height":230,"url":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png","type":"image\/png"}],"author":"Her Highness","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Her Highness","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#article","isPartOf":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/"},"author":{"name":"Her Highness","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/fcc10e27b06f3f95367e914911b47eb3"},"headline":"Database Management System || Fall, 2017 || Pokhara University || BCIS","datePublished":"2021-04-26T05:50:17+00:00","dateModified":"2021-04-26T05:50:17+00:00","mainEntityOfPage":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/"},"wordCount":431,"commentCount":0,"publisher":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#organization"},"image":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage"},"thumbnailUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png","keywords":["Database management system","DBMS questions","Question Bank"],"articleSection":["Q\/A"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/","url":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/","name":"Database Management System || Fall, 2017 || Pokhara University || BCIS","isPartOf":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage"},"image":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage"},"thumbnailUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png","datePublished":"2021-04-26T05:50:17+00:00","dateModified":"2021-04-26T05:50:17+00:00","description":"This is the question set along with answers Database Management System Fall 2017, which was taken by the Pokhara University.","breadcrumb":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#primaryimage","url":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png","contentUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/04\/new_qn-9.png","width":340,"height":230,"caption":"Database Management System || Fall, 2017 || Pokhara University || BCIS"},{"@type":"BreadcrumbList","@id":"https:\/\/bcisnotes.com\/fourthsemester\/database-management-system-fall-2017-pokhara-university-bcis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bcisnotes.com\/fourthsemester\/"},{"@type":"ListItem","position":2,"name":"Database Management System || Fall, 2017 || Pokhara University || BCIS"}]},{"@type":"WebSite","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#website","url":"https:\/\/bcisnotes.com\/fourthsemester\/","name":"BCIS Fourth Semester","description":"Notes of Information and Technology","publisher":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bcisnotes.com\/fourthsemester\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#organization","name":"BCIS Fourth Semester","url":"https:\/\/bcisnotes.com\/fourthsemester\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/","url":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg","contentUrl":"https:\/\/bcisnotes.com\/fourthsemester\/wp-content\/uploads\/2021\/02\/cropped-4-1.jpg","width":300,"height":100,"caption":"BCIS Fourth Semester"},"image":{"@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/fcc10e27b06f3f95367e914911b47eb3","name":"Her Highness","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bcisnotes.com\/fourthsemester\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9f5c6e84ebb073447dba2985b41b0fdc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9f5c6e84ebb073447dba2985b41b0fdc?s=96&d=mm&r=g","caption":"Her Highness"},"sameAs":["http:\/\/bcisnotes.com\/fourthsemester"],"url":"https:\/\/bcisnotes.com\/fourthsemester\/author\/jaya\/"}]}},"_links":{"self":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts\/932"}],"collection":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/comments?post=932"}],"version-history":[{"count":1,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts\/932\/revisions"}],"predecessor-version":[{"id":934,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/posts\/932\/revisions\/934"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/media\/933"}],"wp:attachment":[{"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/media?parent=932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/categories?post=932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bcisnotes.com\/fourthsemester\/wp-json\/wp\/v2\/tags?post=932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}