BSc CS Sem 1 BSc CS Semester 1 (2019 2020) Nov 2020 DATABASE SYSTEMS Question Paper - Mumbai University | munotes

Questions asked in this paper

• 2) Figures to the right indicate marks

1. Q3 Illustrations, in-depth answers and diagrams will be appreciated
2. Q4 Mixing of sub-questions is not allowed,
3. Q5 Assume suitable data if necessary and state it clearly
4. Q1 Attempt All 1)Weak Entity Sets are represented by
   • A) double ellipse
   • B) dashed ellipse
   • C) double rectangle
   • D) double diamond
5. Q2 Which of the following is the syntax for views where v is view name ?
   • A)Create view v as “query name”;
   • B) Create “query expression” as view;
6. Q3 clause is used to restrict number of records returned by the SELECT
   • A) RESTRICT
   • B) LIMI
   • C) REFER
   • D) STOP 4)Architecture of the database can be viewed as
   • A) two levels
   • B) four levels
   • C) three levels
   • D)one level 5)Grant and revoke are statements,
   • A) DDL
   • B) DML
   • C) DCL
   • (b)Fill in the blanks. [use following answer pool to fill the correct answer
7. Q1 The number of times an entity of an entity set participates in a relation in relationship set is known as
8. Q2 DBMS manages the interaction between and database,
9. Q3 ALTER command is
10. Q4 Tuple is equivalent to
11. Q5 function is used to calculate absolute value
    • (c) Answer in one line
    • a) Define Super Key
    • b) Describe the use of Physical Level
    • c) Give the command for truncating table
    • d) Define subquery
    • e) Give one example of composite attribute
12. Q2 Attempt the following. (Any THREE) [15 M]
    • a) What do you mean by Weak Entity Sets? Explain with example
    • b) Write short note on Generalization
    • c) Construct an E-R diagram for a Hotel management System. Customer bouks the room Customer pay amount. Customer uses restaurant for breakfast, and dinner. After checkout, customer leaves the room [Assume suitable data and mapping cardinalities exists. ]
    • d) Explain Hierarchical Model in detail Draw and Explain all notations used in E-R Model
    • f) What do you mean by Binary Relationship and Ternary Relationship? Explain with
13. Q3 Attempt the following. (Any THREE) [15 M]
    • a) Explain the concept of Relational Algebra. List all basic operations supported by it Explain any one operator with query example
    • b) What do you mean by Normalization? Explain Third Normal Form
    • c) How do you Backup and Restore Database in MySQL?
    • d) Explain the following with proper example —
    • i) IN clause
    • ii) BETWEEN clause
    • iii) ORDER BY clause Explain all Aggregate Functions used in MySQL
    • f) Consider following table. Underline fields are key fields
    • i) Create above table with bookid as Primary Key. ‘
    • ii) Insert one record in it Find out Book titles starts with ‘D’
    • iv) Add a column ‘Year’ with data type INT in Book table
    • v) Find out Books with price in the range of Rs. 500 to Rs. 1000
14. Q4 Attempt the following(Any THREE) [1SM]
    • a) What are Joins? List types of Joins. Explain any one of them
    • b) Explain any 5 Math functions used in MySQL with example
    • c) What are views? How to create and update views?
    • d) What do you mean by privileges with respect to databases? How to grant and revoke Write short note on nested subqueries. Illustrate with example
    • f) Consider following tables:
    • i) Display details of suppliers who have taken the orders
    • ii) Create a view showing number of suppliers living in each City
    • iii) Get the details of suppliers who have not taken any order. (Solve with subquery)
15. Q5 Attempt tie following (Any THREE) [15 M]
    • a)Convert below ER diagram into corresponding tables
    • b) Explain the following with suitable example —
    • i) Default constraint
    • c) What are the different threats to the databases?
    • d) How to create and drop a user in MySQL?
    • e) Explain the role of Data Base Administrator

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