BSc IT Sem III 2018 2019 Oct 2019 DATABASE MANAGEMENT SYSTEM Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any three of the following: 15 marks
   • a. What is the role of DBMS? What are its advantages over file system?
   • b. Explain storage system and query processor components of database structure
   • c. What is a business rule? What is its purpose in data modeling?
   • d. Write comparison between hierarchical, network & relational model
   • e. List and explain Codd’s rules in detail
   • f. Explain ER diagram and its components. Give the distinction between disjoint, overlapping, total and partial constraints. Draw E-R diagram for the following situations that correctly models this domain and its constraints A small racing league want a database to keep track of teams, drivers, races and scores in the league. The league is run for teams, which are identified by their names. Each team has one or more drivers signed up, and each driver is registered with the league and has a unique league licence number. First and last names of the drivers should also be included. A driver may only participate for a single team throughout the season. Races are identified simply by the dates when they are run. For each race, the league also wants to store the venue where it took place. Drivers participate in races, and for each participating driver the database should store the total race time for that driver, and the league score they got from that race
2. Q2 Attempt any three of the following: 15 marks
   • a. Why are entity integrity and referential integrity important in a database? Explain in detail
   • b. Explain why normalization is necessary in database system & also explain database anomalies in detail You are given the following set of functional dependencies for a relation R(A,B,C,D,E,F),
   • a. What are the keys of this relation?
   • b. Is this relation in BCNF? If not, explain why by showing one violation
   • c. Is the decomposition (A, B, C, D) (B, C, D, E, F) a dependency preserving decomposition? If not, explain briefly Write short note on Cartesian product with its syntax and example
   • d. Explain SET operators in relational algebra with example
   • e. Explain formal definitions with safety of expressions of tuples relational calculus State the difference between relational algebra and calculus
3. Q3 Attempt any three of the following: 15 marks
   • a. What are constraints? What are the different types of constraints? Explain
   • b. can a view be updated? Explain the syntax of updating a view. Also state the difference between views and table c Consider the relations : Write the SQL queries for the following:
   • a. Write An SQL Query To Print The FIRST_NAME And LAST_NAME From Worker Table Into A Single Column COMPLETE_NAME. A Space Char Should
   • b. Write An SQL Query That Fetches The Unique Values Of DEPARTMENT From Worker Table And Prints Its Length
   • c. Write An SQL Query To Print First Three Characters Of From
   • d. Write An SQL Query To Fetch Worker Names With Salaries >= 50000 And <=
   • e. Write An SQL Query To Fetch The No. Of Workers for Each Department in the d Write in brief about SQL with its advantages and also explain NULL value concept. How NULL values are different from EMPTY values? e Join and List its type and explain any two in details. Consider the following relation and solve the below query:
4. Q1 Write a query in SQL to display the first name, last name, department number, and department name for each employee Differentiate between ANY and ALL operators with example & also explain hierarchical
5. Q4 Attempt any three of the following: 15 marks
   • a. List the ACID properties. Explain the usefulness of each
   • b. Explain the concept of serializability and explain in detail view serializability
   • c. What are concurrent transaction? Explain in detail the main features of concurrent
   • d. are the disadvantages of time stamping methods for concurrency control? Eplain
   • e. What benefit does rigorous two-phase locking provide? How does it compare with other forms of two-phase locking?
   • f. If deadlock is avoided by deadlock-avoidance schemes, is starvation still possible? Explain
   • Q.P.Code: 53634
6. Q5 Attempt any three of the following: 15 marks
   • a. What is the use of % TYPE attributes and how it is beneficial while declaring the
   • b. the attributes of implicit cursor with examples
   • c. Explain the function Raise_Application_Error () with example
   • d. List & explain the various features of PL/SQL & also differentiate between anonymous blocks and subprograms
   • e. What are packages in PL/SQL? List and explain the various advantages of packages Create a package to display the employee name and salary
   • f. What are triggers? Explain the syntax for creating a trigger in PL/SQL. List the benefits of creating trigger in PL/SQL

Read from the scan above, so a character or two may differ. The scan is the original.