BSc CS Sem 2 BSc CS Semester 2 (2021 2022) May 2022 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. 40 marks
   • a) Multiple Choice Questions 1A represents association among two or more entities
   • a) Entity b) Attribute
   • c) Relationship d) Metadata
5. Q2 Relational algebra is a
6. Q3 The number of times an entity of an entity set participates in a relation in relationship set is
   • a) Cardinality b) Relationship
7. Q4 In ER Diagram, Identifying Relationships are represented by
   • c) Diamond d) Rectangle
8. Q5 is a bottom-up approach
   • a) Specialization b) Join
   • c) Aggregation d) Generalization
9. Q6 generally refers to the suppression of details of data organisation and highlighting the essential features for improved understanding of data clause arranges records selected in certain order
   • a) with order b) order by
   • c) in order d) sort by
10. Q8 Attributes that are not divisible in subparts of values are called attributes
    • a) Strong b) Complex
    • c) Simple d) Single
11. Q9 _ normal form is based on the concept of transitive dependency
12. Q10 A database language used for defining the database structure and schema is
    • a) DCL b) DTL
    • c) DML d) DDL \
13. Q11 The operation, denoted by —, allows us to find tuples that are in one relation but are not in another
    • a) Union b) Difference
14. Q12 Which aggregate function is used to count number of rows in a table?
    • a) ALL () b) COUNT ()
    • c) SUM () d) TOTAL ()
15. Q13 Which operation is used to select rows from a relation?
    • a) SELECTION b) JOIN
    • c) PROJECTION d) UNION
16. Q14 return all rows from the right table and matching rows from the left table or null ifno matching rows found in the left table
17. Q15 Which of the following is used to denote the selection operation in relational algebra’?
    • a) Pi b) Lambda
    • c) Sigma d) Omega
18. Q16 What is the correct syntax for creating a view?
    • a) CREATE VIEW <VIEWNAME> AS TABLENAME;
    • b) CREATE <QUERY EXPRESSION> AS VIEW;
    • c) CREATE VIEW <VIEWNAME> AS QUERY EXPRESSION;
19. Q17 function returns the current date and time at which the statement executed
    • a) NOW b) DATE
    • c) DAY d) DATETIME
20. Q18 command is used to combine the records from one or more tables
    • a) CROSS b) PROJECT
    • c) JOIN ' d) PRODUCT 19, is a virtual table created by a query by joining one or more tables
    • a) Subquery ‘ b) Function
    • c) View d) Procedure
21. Q20 is to test whether a value is NULL or not
    • c) NOT NULL d) IS NULL
22. Q2 Attempt the following. (Solve any TWO) 10 marks
    • 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 books the room Customer pay amount. Customer uses restaurant for breakfast, lunch and dinner checkout, customer leaves the room [Assume suitable data and mapping cardinalities exists
    • d) Explain Hierarchical Model in detail
23. Q3 Attempt the following. (Solve any TWO) 10 marks
    • a) Explain the concept of Relational Algebra. List all basic operations supported by it Explain any one operator with query example
    • b) Consider following table. Underline fields are key fields
    • i) Create above table with bookid as Primary Key
24. Q11 Insert one record in it
    • iii) 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 Explain any 5 Math functions used in MySQL with example
    • d) What are Joins? List types of Joins. Explain any one of them
25. Q4 Attempt the following. (Solve any TWO) 10 marks
    • a) What are views? How to create and update views?
    • b) What do you mean by Normalization? Explain Third Normal Form What do you mean by privileges with respect to databases? How to grant and revoke
    • d) Write short note on nested subqueries. Illustrate with example
26. Q5 Attempt the following. (Solve any ONE) 5 marks
    • a) Convert below ER diagram into corresponding tables
    • b) Explain all Aggregate Functions used in MySQL
    • c) Explain the role of Data Base Administrator

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