10:04 @ Bi We © 56 al | 37% < Posts Follow ® mohsin_alii_14 1d. mester B.E./B.Tech. Degree Examination, June/July 20 a Database Management Systems BCS403 Max. Marks: 100 inswer any FIVE full questions, chodsing ONE full question from each module. Marks, L: Bloom’s level , C: Coltrse outcomes. “Module=1 M[L] Cc} Q. |a.] Define database. Elaborate component modules of DBMS and their | 10/12 | COL interactions. b. | Describe the three-schema architecture. Why do we need mappings among | 06 | L2 | COI |__| schema levels? | ‘c. | Explain the difference between logical and physicaldataindependence. | 04| L2 | CO1 | OR Q2 [a [Draw an ER diagram for an COMPANY database with employee, | 10] L3 | COs department, projectas strong entities and dependent as weak entity. Specify the constraints, relationships and ratios in the ER diagram. b. | Define the following terms with example for each using ER notatio Entity, atthibut@, composite attribute, multivalued attribute, participation role. | Moditle —2 Q3 | a. | Discuss the update operations and dealing with constraint violations with | 08 | L2 | CO2 suitable examples. 3 , | Illustrate the relational algebra operators with, ekimples for select-and | 06 | L2 | CO2 10/ L3 | Cos project operation. [smal . | Discuss the characteristics of relations dat make them different from | 06 | L2 | CO2 ordinary table and files. | | OR. Q4 Ja. | Perform (i) Student U instructor (ii) Stiident 9 Instructor 04] 13 | Coz (iii) Student— Instructor (iv) Instructor ~ Student on the following tables: Student Instructor [Fiiame | Lname Fname_| Lname Susan_|Yao__ |), John _q)Smith Ramesh | Shah, Ricardo | Browne | {0 [Johnny | Kohler} Susan | Mao ‘ | Barbara | Jones Francis _| Johnson Amy —_|\Ford ‘Ramesh | Shah Jimmy™|, Wang Emest “| Gilbert b. | Consider the following relational database schema and write the queries in | 10) L3 cor relational algebra expressions? EMP(Eno, Ename, Salary,"Address, Phone, DNo) | DEPT(DNo, Dname, DLoc, MgrEno) DEPENDENT(End, Dep_Name, Drelation, Dage) (i) List all the employees who reside in ‘Belagavi’. (ii) List all the employees who ear salary between 30000 and 40000 (iii) List all the employees who work for the ‘Sales’ department | (iv) “List all the employees who have at least one daughter (v) “List the department names along with the names of the managers O28 Qs VW 204 W EQBD Liked by _shubha_guoda_79 and others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more m Q 6 @1004 @ Bi NO 56 aul | 37% < Posts Follow mohsin_alii_14 1d. Module —5 @Q9 | a.] What is the two phase locking protocol? How-docSwit Guarantee | 06] L2 | COS | serializability. b, | Describe the wait-die and wound-wait protocols for déadléck prevention. | 08 | L2 | COS «. | List and explain the four major categories of NOSQL system. 06 | L2 | CO3 OR Q.10| a. | What is Multiple Granularity locking?\\How is it implemented using | 10] L2 | COS intension locks? Explain. . | Discuss the following MongoDB CRUD operations with their formats: [06] 12 | Cos (@ Insert i) Delete (iti Read a - i CRIT LIBRARY —|__|__|__ «. | Briefly discuss about Neo4j dataimodel. a we soon | 04/1216 poe sli O28 Qs VW 204 W @eP Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more m Q 6 @FI Nw @ 56 mohsin_alii_14 1d. Model Question Paper- II with effect from 2022 CBCSISCHENM Es Fourth Semester B.E Degree Examination 2024-25 Database Management System (BCS403) TIME: 03 Hours MaxMarks:100 1. Note: Answer any FIVE full questions, choosing at least ONE question from each MODULE 2. M: Marks, L: Bloom’s level, C: Course outcomes. | @ 37% Follow Module - 1 M/L| Cc Qc | a | What is a Database? Explain the three schema architecture with neat diagram. 8 | 12/ Cor b | What are the advantages of using DBMS approach? Explain 8 | 12/ Cor ¢ | Explain the following terms. 4/12) Cor 1. Data Dictionary 2. Weak Entity OR a2 | [Exmlsin the categories of Data Models. 8/12) Cor b | Explain the component modules of DBMS & their interactions with 8 | 12 | Cor jiagram. ‘¢ What are the responsibilities of DBA & database designers? 4/12/ Cor Module - 2 Q.3 | a [Explain the different types of update operations on relational database. How] 6 | L2 | CO2 basic operation deals with constraint violation. b | Explain Unary relational operations with examples. 6 | 12 | Coz © | What is an Integrity Constraint? Explain the importance of Referential| 8 | 12 | CO2 Integrity Constraint OR Q4 [a [Explain the following relational algebra operation. 10/13 | Coz JOIN, DIFFERENCE, SELECT, UNION b | Discuss the E.R to Relational mapping algorithm with example for each 6 | L3 | Coz step. ‘¢ | Explain the relational algebra operation for set theory with examples. 4/12 / Coz Module - 3 Q5 | a |lMlustrate insert, delete, update, alter & drop commands in SQL. 6 | L4| CO3 e OQ 281 Q 9 VW 2934 @eP Liked. by _shubha_guwda_79 and. others W mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more m Q o10:04 @ Bi We © 56 al | 37% < Posts Follow mohsin_alii_14 1d. BCS . | Consider the two tables T; and Tz shown below: : 06) 13 T XQ 1 Tr P [QU AB 10a [5 10[b b c b 1s[b [8 25 | 25[a [6 10 Show the results of the following operations; @ Tr PSynra Ta Gi) TPS oma T2 alelala | Gi) Th Parana es, za Module — 3 [QS a. | Discuss the informal design guidelines for relation schema design. 08 | L2 | Cos Define INF, 2NF, and 3NE_with €xamples. 06 | L2 | CO4 “e, | Write the syntax for INSERT, UPDATE and DELETE “atements in SQL | 06 | L2 | COs | and explain with suitableexamples. a OR Q.6 | a. | Discuss insertionsdelétion and mmodificatiofl anomalies. Why are they | 10| £2 | CO3 considered bad? [ustrate with examples. b, | Illustrate the following with suitable examples: 10| £2 | Co3 (i) Datatypes in SQL Gi) Substring Patten Matchifig-in SQL. r Module - 4 Q7 | a. | Consider the following relations:, ‘ 10] 13 | CO3 Student(Snum, Sname, Branch, level, age) Class(Cname, meet_at, roomfid) Enrolled(Snum, Cname) a Faculty(fid, fname, deptid) Write the following queries in SQL. No duplicates should bg ied in any of the answers. (i) Find the names of all Jutiots (level = JR) ho fe enrolled in a class taught by I. Teach, (ii) “Pind the names ofall ‘lasses that eithet meet in room R128 or have five or morerstudénts enrolled. (iii) ~ For all levels exéept JR, print thevlevel and rthe average age of students for that Jével. (iv) For each fffeulty member that has’ taught classes only in room R128, print the faculty member's name and the total number of classes she or he has taught. cmrit (v)__ Find'the names of students tot enrolled in any class. po . | What do understand by correlated’Nested Queries in SQL? Explain with suitable example. €. | Discuss the ACID properties Of'a database transaction. 06 | 12 | Cos » OR | Q.8 | a. | What are the views in SQL? Explain with examples. 04] 13 | COs b. | In SQL, write the usage of GROUP BY and HAVING clauses with suitable | 06 | L2 | CO3 examples. ¥ ©. | Discuss the typeof problems that may encounter with transactions that run | 10 | L2 | COS concurrently. zt e O28 Qs VW 204 W EQBD Liked by _shubha_guoda_79 and others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more m Q 6 @mohsin_alii_14 1d. FI Nw @ 56 Model Question Paper- II with effect from 2022 | @ 37% Follow Explain informal design guidelines for relational schema design. 4] 12] Cos What is Functional dependency? Explain the inference rules for functional 10 | L3 | CO4 ‘dependency with proof. OR (Consider two sets of functional dependency. F={A9C, ACD, EDAD, 10 | L3 | COs Q.6 |" E5H) E=(ADCD, E>AH). Are they Equivalent? Explain the types of update anomalies in SQL with an example. 10 | L2 | Coz Module - 4 Q7 |a | Demonstrate transaction states & additional operations. 10 | £3 | Cos Demonstrate working of Assertion & Triggers in database? Explain with an | 10 | L2 | CO3 example. OR Qs Demonstrate the System Log in database transaction. 6 | L2 | Coa Discuss the ACID properties of database transaction 4/12] cos Explain stored procedure language in SQL with an example. 10 | £2 | CO3 Module - 5 Qo Explain the Two phase locking protocol used for concurrency control. 8 | L3 | COs Define Schedule? Mlustrate with an example. 4 | L2| cos ., [Why Concurrency control is needed? Demonstrate with an example, 8 | L3 | COs OR Q.10| a | What is NOSQL? Explain the CAP theorem, 6 | L2/ COs ‘What are document based NOSQL systems? basic operations CRUD in 8 | L2 | Cos MongoDB. What is NOSQL Graph database? Explain Neod}, 6 | 12] Cos OQ 281 Q 9 VW 2934 @eP Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more a Q o WTIME: 03 Hours 1. Note: Answer any FIVE full questions, choosing at least ONE question from each MODULE mohsin_alii_14 1d. Model Question Paper- I with effect from 2022 acs SCHEME FI Nw @ 56 Fourth Semester B.E Degree Examination 2024-25 Database Management Systems (BCS403) 2. M: Marks, L: Bloom's level, C: Course outcomes. ‘Max Marks:100 | @ 37% Follow Module - 1 M/Lic Qa Explain the types of end users with examples. 8/12] Cor What are the advantages of using DBMS? Explain. 8 | 12] Cor Describe the characteristics of database 4/12] cor oR 02 xplain three schema architecture. Why mappings b/w schema levels are! 8 | L2 | COL 7 required? Explain the different types of attributes in ER model 8 | 12| Cor Explain the following, 4/12 | cor 1. Cardinality Ratio 2. Weal Entity Module - 2 Q3 Explain the different Relational Model constraints. 6 | 12 | coz Demonstrate the concepts of Generalization & Specialization with examples.| 6 | L2 | COZ Explain Entity Integrity Constraint & Referential Integrity Constraints? Why| 8 | L2 | COZ each of these is important in a database. oR OQ 281 Q 9 VW 2934 @eP Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more a Q o W¥i) NW © 56; I] 37% < s~Posts Follow mohsin_alii_14 1d. Model Question Paper- I with effect from 2022 @ Q4 ]a [Consider the Sailors-Boats-Reserves DB described 10] 13 (sid, sname, rating, age) b ¥ (sid, bid, date) |, bname, color) Write each of the following queries in SQL. 1. Find the colors of boats reserved by Alber. 2. Find all sailor ids of sailors who have a rating of at least 8 or reserved boat 103. 3. Find the names of sailors who have not reserved a boat whose name contains the string “storm”. Order the names in ascending order. 4. Find the sailor ids of sailors with age over 20 who have not reserved a boat whose name includes the string “thunder”, | Discuss the Equijoin & Natural Join with suitable example. 6 | 13 | Coz © Explain the relational algebra operation for set theory with examples. 4/12 | coz Module - 3 Q5 [a [Explain the Cursor & its properties in embedded SQL with an example. 6 | 12 | Co3 | What is a Normalization? Explain the INF, 2NF & 3NF with examples. | 10 | L2 | CO4 © [Explain informal design guidelines for relational schema design, 4/12 | Cos OR ‘a [What is Functional Dependency? Write algorithm to find minimal cover for | 10 | L2 | CO4 Q6 ‘et of Functional Dependency. Construct the minimal cover m for set of functional dependency, E={ B>A, DA, ABD} | Explain the types of update anomalies in SQL with an example. 10 | 14 | Cos Module - 4 Q7 | a [Demonstrate the Database Transaction wi 10 | 12 | Cos | Demonstrate working of Assertion & Triggers in SQL? Explain withan | 10 | L3 | CO3 example. OR QB [a [Demonstrate the System Log in database transaction, 6 | 2 | Cos | Demonstrate the ACID properties of database transaction. 4 | 12 | Cos [Explain stored procedure language in SQL with an example. 10 | 12 | Co3 OQ 281 Q 9 VW 2934 W @eP Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more m Q 6 @ AN O IIIFI Nw @ 56 | @ 37% < s~Posts Follow mohsin_alii_14 td : Model Question Paper- I with effect from 2022 Module - 5 Q9 [a [Demonstrate the Two phase locking protocol used for concurrency control. | 8 | L3 | COS b |Demonstrate the Concurrency control based on Timestamp ordering. 4/12) cos ¢. | Why Concurrency control is needed? Demonstrate with an example, 8 | 13 | Cos OR Q.10 [a | What is NOSQL? Explain the CAP theorem. 6 | 12 | Cos b | What are document based NOSQL systems? Explain basic operations 8 | 12 | Cos CRUD in MongoDB. | What is NOSQL Graph database? Explain Neodj. 6 | 12 | Cos OQ 281 Q 9 VW 2934 Ww @eP Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more m Q 6 @Bi WO 56 sl | 37% Follow mohsin_alii_ 14 1d. : UY YNISUIS L] mester B.E./B.Tech. Degree Examination, Dec.2024/Jan. Database Management System Max. Marks: 100 Answer any FIVE full questions, choosing ONE full question from each module. ‘M: Marks, L: Bloom’s level , C: Course outcomes. Module=1 MIL] Cc QI | a. | Define the following terms: 05 | L1 | Cor (i) Database (ii) Schema (iii) Entity | (iv) DDL (¥) Degree of a relationship . | Briefly explain characteristics of database approach. 05 [12 | Cor e. | List and explain advantages of using DBMS approae! 10/12 | COL OR Q2 | a. | Define the following terms: 05/11 | CO1 (i) Cardinality (ii) Weak entity (iii) Program data independence (iv) DML (¥) Value sets b. | Describe three-schema architecture. Why do we need mappings between | 05 | L2 | COT schema levels? ____A me c. | Explain different types of attributes in ER model with suitable example for | 10 | L2 | CO1 each. Module ~2 ai Q3 | a. | With suitable example, explain the entity integrity and referential integrity | 05] L2 | CO2 constraints. Why each is considered important? i b. | Discuss equijoin and natural join with suilable example using relational | 05 | L2 | CO2 algebra notation. _ _ ©. | Given the relational table ey 10| 13 | Co2 Employee: 7 Department: ] EID | Name | DepID | Salar DeptD | DeptName | 1 [Alice [10 [5000 {| 10 HR | |,6000 | 20 | IT | 6500 | 30 Sales DeptiD | 101 | Project Alpha | 10 102 | Project Beta 20 ma| 30 [103 | Project Gai | Write relational algebra expression for the following: | (i) Find the names and salaries of all employees in the (ii) Find the [D’s and names of employees who are in th and have a salary greater than 6000. (iii) Find the ID's and names of employees who are either in the ‘HR’ department or have a salary greater than 6000. (iv) Find the names of employees who are not in the “IT” department (v) Find the names of employees along with their department names. department. IT” department O28 Qs VW 204 Qed Liked. by _shubha_guwda_79 and. others W mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more a Q omohsin_alii_14 1d. Bi WY @ 56 all | 37% Follow OR Qa Explain any two operations that change the state of relation in a database. | 05 Provide suitable examples. Discuss the aggregation functions and grouping in relational algebra with | 05 suitable examples. ‘2 Given the relational tables: 10 Student: Project SID [Name | [PID | Project Name a | Alice | | p Alpha b | Bob | | q Beta} c_| Carol r Gamma | Language’ Enrollment: LID | Language Name | [ SID.| PID | x Python al Pp y Java aig z CH b | q elr Write relational algebra expression for the following: (i) Rename the student table to Learner and-display it. (ii) Find the students (learners) who are not enrolled in any project. (iii) Find the students who are enrolled in all projects. (iv) Find the students who are not enrolled in any project (v) Find the students who are enrolled in both the ‘Alpha’ and ‘Beta’ projects. 13 | Coz Module—3 - Explain Armstrong inference rules. 05 co4 What is the need for normalization? Explain INF, 2NF and 3NF with | 05 examples. S|5 co4 What is functional dependency? Write an algorithm to find minimal cover | 10 for set of functional dependencies. Construct minimal cover M for set of functional dependencies which are: E = {B > A, D> A, AB — D} L3 | CO4 OR Explain the types of update anomalies in SQL with an example. [05 L2 | CO4 Explain types of IBBC drivers. 05 L2 | COS elr|e ‘Consider the schema R = ABCD, subjected to FDs F = {A 9B, BC}, | 10 and the non-binary partition DI = (ACD, AB, BC}. State whether D1 is a lossless decomposition? [give all steps in detail). 13 | CO4 Module ~4 ss ACID properties. i 12 | Cos With a neat diagram, explain transition diagram of 05 12 | COs Demonstrate working of assertion and triggers in SQL with example. 10 13 | Cos _OR Explain cursor and its properties in embedded SQL with suitable example. | 05 12 | Cos Determine if the following schedule is serializable and explain your | 05 reasoning i) TL: ROQW(X)_T2: ROX)W(X) TI: COMMIT 2: COMMIT ii) TL: WOOR(Y) 72: ROQW(Y)_T1: COMMIT T2; COMMIT 12 | Cos OQ 281 Q 9 VW 2934 EQBD Liked by _shubha_guoda_79 and others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more a Q o AN O III WFN we © 56 all mohsin_alii_14 1d. o 37% Follow . | Consider the tables below: - 10] 13 | Cos Sailors (sid : integer, sname : string, rating : integer, age : real) Boats (bid : integer, bname : string, color : string); Reserves (sid : integer, bid : integer, day : date) Write SQL queries for the following: (i) Write create table statement for reserves. (ii) Find all information of sailors who have reserved boat number 101. | (ii) Find the names of sailors who have reserved at least one boat. (iv) Find the names of sailors who have reserved a red boat. (v) Find the average age of sailors for each rating level, Module ~ 5 [Q9 a. | Explain the CAP theorem. = Re 05 | 12 [ CO6 . | What is NOSQL graph database? Explain Neodj 05 | L2 | CO6 ‘. | Why concurrency control and recovery are needed in DBMS? Demonstrate | 10 | L3 | COS With suitable examples types of problems that may occur when two simple transactions run concurrently. OR CMRIT LIBRARY xplain basic operations CRUD in MongoDB. BANGALORE -ssoa7_] 05 | L2 | CO6 . | Explain deadlock prevention protocols. 05 | 12 | COs ¢. | Briefly discuss the two-phase looking techniques f concurreney control. | 10| 13 | COS OQ 281 Q 9 VW 2934 @eP Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more a Q o W10:04 @ Bi We © 56 al | 37% < Posts mohsin_alii_14 1d. June/July 20 Database Managenege System Fourth Semester B.E./B.Tech. Degree Suppl tary Examii & Time: 3 hrs. % Max. Marks: 100 Note: 1, Answer any FIVE full questions, choosing ONE full question fr module. 2.M: Marks, L: Bloom's level , C: Course outcomes. Module=1 Pa M Q.1 | a. | What is DBMS? List the characteristics of database approach, Bring out | 8 major advantages of the database approach Lic L2/ cor b. | Explain data independence Draw 3 schema architecture“and discuss the | 7 | L2| COl mapping. % Define following > i)? Database Administrator » il) Canned transaction [ 5 | L2 | COT iii) Weak entity“.iv) Metadata v) Database, Instance. ° aad oR > Q2 a Describe ‘components modules of DBMS and its interaction with neat] 8 12] cor diagram, 4 an Pa & b.| Draw ER diagram of library Galabase schema all entities. Aso | 8 | 13 eo: specify primary keys, structural constraints and ean > 4 tn 4 | | Briefly discuss different nypés of end users of Database. Saco »* 4 |= ‘ Module =2.~ Q.3 |. | Briefly expiaindifferent types of update operation on re latabase.| 10 | 12 | CO3 Show an example of violation of referential and entity integrity in each of | update operation. 5 ? 4 ,_ = > | b. | Consider following schema z= VY 10 | L3 | coz Suppliers (SID , SName , addre’s) ¥ Paris (PID , PName , Colour) - Catalog (Sid , PID , Price) - Write relational algebra expression for following queries : | i) Find the names Ofall red parts. Find all prices for parts that were réd or green. iii) Find the SID’s of all supplierSwito supply part that is red or green. iv) Fing-the SID's of all supplier'who supply part that is red and green. ¥ — § OR Q4 | a. | Describe the steps of ERS 16 — relational mapping with suitable examples | 10 | L2 | CO2 and schema for cach step.) ».| Explain with exginple : 7) Division operation i) Full outerjom } 10 | La} @or iii) Aggregate ‘function iv) Project operation y) "Cartesian product. zo | Tar QO 281 Q 9 V7 2934 W e@ Pp Liked by _shubha_gxwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more 6 @ AN O III10:04 @ Bi WO 56 al | 37% < Posts Follow mohsin_alii_14 1d. Fourth Semester B.E./B.Tech. Degree Supplementary Examination, June/July 2024 Database Management System Time: 3 hrs. Max. Marks: 100 Note: 1. Answer any FIVE full questions, chodsing ONE full question from each module. 2M: Marks ,L: Bloom’s level , C: Course outcomes. Mode - TM[L]c¢ Qi | a. | What is DBMS? List the characteristics of database approach Bring out | 8 | L2 | COI major advantages of the database approach. Explain data independence. 3 schema architecture and discuss the | 7 | L2| CO1 mapping Te. | Define following = i)’ Database Administrator ii) Canned transaction | § L2 | CO1 | ~ | ili) Weak entity’ {Hours} SSn — {Ename} Prumber — {Pname, Plocation}, Normalize above relation into 2NF mal design guidelines for relation schemes with | 10 | L2 | CO4 |} b.Tiustrate the examples. OR Write syntax with example IL for the DDL and DML SQL] 10 | L2 | Co3 statements. b. | Consider the schema forcollege database. Ye 10 13 | CO3 Student (USN , Snamte , Address , Phone , Gender) SemSec (SSID, Sem , Sec) Class (USN , SSID) Subject (Suibcode , Title , Sem , Credits) IAmarks (USN , Subcode , SSID , Testl?, Test2, Test3, Final 1A) Write SQL Query. 1) “List all the students studying in 4 sem °C” section. ii) Compute total number of mate students in each semester. iii) List Test! marks of all students in all subjects. Q:7 |e: | How are triggers and asiertion defined in SQhg Explain with example. ] 10 [12 | Co4 b. | Write the syntax and example of viewsin SQL. Explain efficient view | 10 L2 | CO4 implementation, x __ OR x oo Q.8 | a. | List the problems that occur daring concurrency control and also explain | 10 | L2 | COS then# with supporting transaction diagrams pb | Explain the various DBMS ~ Specific Buffer teplacement policies [10/12 [cos Es, | | 7 ~~ Module-$— — : Demonstrate with, example deadlock in transaction. Discuss deadiock | 10 |'L2 | COS prevention algorithm | What are Binary locks? Explain with Lock and unlock operations with | 10 | L2 | COS algorithm, oR Z Q.10 | Write a short note on 20 12 | CO4 i) Properties of NOSQL system ii) The CAP theorem iti) Document baséd’NO - SQL system iv) NOSQL Graph database. ‘ 2of2 e OQ 281 Q 9 VW 2934 W e@ Pp Liked. by _shubha_guwda_79 and. others mohsin_alii_14 BCS403 Vtu All Previous Year Papers And Model Papers... more 6 @