LinkedIn Insight BSc.-Database Systems-Mumbai-April 2017 - Grad Plus

BSc.-Database Systems-Mumbai-April 2017

MUMBAI UNIVERSITY

Subject: Database Systems

Semesters: 1

(Time: 2 ½ Hours)
[Total Marks: 75]
N.B. 1) All questions are compulsory.
2) Figures to the right indicate marks.
3) Illustrations, in-depth answers, and diagrams will be appreciated.
4) Mixing of sub-questions is not allowed.

____________________________________________________________________________________________________________________________

Q.1) Attempt All Questions. [15M]

A) Multiple Choice Questions

1) In the architecture of a database system external level is the

a) Physical level.
b) Logical level.
c) Conceptual level
d) View level.

ii) In the figure given below identify the multivalued attribute

a) Name
b) Student
c) DOB
d) Contact

iii) ………….. is a minimal set of attributes whose values uniquely identify an entity in the set.

a) Primary key
b) attribute
c) entity
d) foreign key

iv) What will be output of calling function ROUND(8.4999, 0)?

a) 8
b) 9
c) Both a and b
d) None of the above

v) Which of the following clause is mandatorily used in a sub-query?
a) SELECT
b) WHERE
c) ORDER BY
d) GROUP BY

B) Fill in the blanks

i) In an ERD diagram rectangle represent ______________

ii) If every non-key attribute is functionally depend on the primary key, the relation will be in ___________ Normal form.

iii) In relational algebra, to finds all the tuples that are present in r but not in s, we write it as _____________

iv) Syntax of creating view is _________________

v) Output of SELECT sqrt(25); is ________________

 

C) Short Answers.

i) What is Schema?

ii) What is mean by Logical Data Independence?

iii) Which symbol is used in relational Algebra for projection?

iv) State the syntax of selecting all column from table 1.

v) Write a query to retrieve month from the date “2016-10-06′.

 

Q. 2) Attempt the following (Any THREE) (15M)

a) Define DBMS. State and explain in brief advantages of DBMS.

b) Write a short note on entities vs attributes.

c) State and explain types of attributes with their notations.

d) Describe following in short with respect to Relational data model:

i) Domain
ii) Attributes

e) State and explain types of level of abstraction in Database management system.

f) Convert following ERD into its table form.

 

Q. 3) Attempt the following (Any THREE) [15M]

a) Write a short note on first normal form.

b) Explain select operation of relational Algebra.

c) Briefly explain with the help of example how Union and Intersection work in Relational Algebra.

d) Explain with proper illustration Between clause’ in MySQL.

e) Write a query to perform following operations:

i) Create a table Student with id as a primary key, name as unique key and marks column.
ii) Insert a record in it.
iii) Modify the existing table by adding a column course to the
given table.
iv) Add value for existing records for the newly inserted
column.
v) Delete the table.

f)  State and explain aggregate functions.

 

Q. 4 Attempt the following (Any THREE) [15M]

a) Explain the following functions with example.
i) lower
ii) replace
iii)abs
iv) pow
v) reverse

 

B) Write output for following functions:

i) SELECT CONCAT(‘Hello!, MY, ‘QL’);
ii) SELECT ‘ALL’ My’ STUDENTS’;
iii) SELECT RIGHT(‘HELLOALL’, 3);
iv) SELECT LEFT(‘HELLOALL’, 2);
v) SELECT mod(5,2);

c) Describe left outer join with suitable example.

d) Elaborate on different types of subqueries.

e) What is DBA stands for? Explain role of DBA in Database protection.

f) Write a MySQL query to create and drop user with and without privileges.

 

Q. 5) Attempt the following (Any THREE) [15M]

a) Explain Generalization using diagrammatic representation.

b) Briefly explain lossless join decomposition.

c) What are views? State advantages of using views.

d) Elaborate on characteristics of relations.

e) Write a short note on nested subqueries.

 

Scroll to Top