B.Sc. (Computer Science) Sem 3 Database Management System 2014-15 Page 1 Question Paper - Mumbai University | munotes
Get access to whole semester resourcesSemester Pass
MU B.Sc. (Computer Science) student group
Free to join
Loading PDF...
Older exam
2014-15 - Page 2
Semester-end · Database Management System
→
Newer exam
2014-15
Semester-end · Database Management System
→
Questions asked in this paper
a) the disadvantages of file management system?
b) Explain Normalization with 3NF and BCNF
c) What do you mean by a Weak entity set?
d) Explain the terms
iii) Attributes
e) Explain cardinality constraint
f) short note on — Generalization
g) What do you mean by DBMS? What are its applications?
h) What do you mean by total participation and partial participation?
Q.2 Attempt any Four. [20]
a) Explain select and projection operators
b) Explain DDL statements used in SQL? Give example of each
What do you mean by constraints? What are different types of constraints used in SQL?
d) Explain domain relational calculus
What do you mean by correlated subquery? Explain with example
f) What do you mean by join? Explain Right join and Full Outer Join with suitable example
g) Explain any five string functions used in SQL
h) Consider following tables
b) Explain Normalization with 3NF and BCNF
c) What do you mean by a Weak entity set?
d) Explain the terms
iii) Attributes
e) Explain cardinality constraint
f) short note on — Generalization
g) What do you mean by DBMS? What are its applications?
h) What do you mean by total participation and partial participation?
Q.2 Attempt any Four. [20]
a) Explain select and projection operators
b) Explain DDL statements used in SQL? Give example of each
What do you mean by constraints? What are different types of constraints used in SQL?
d) Explain domain relational calculus
What do you mean by correlated subquery? Explain with example
f) What do you mean by join? Explain Right join and Full Outer Join with suitable example
g) Explain any five string functions used in SQL
h) Consider following tables
Read from the scan above, so a character or two may differ. The scan is the original.
Something wrong on this page? Report it and we will check it against the scan.
Quick Help
No. The full paper opens straight away, with no login and nothing to pay.
Related Resources
Something wrong with this paper? Report it.
Connected Papers
B.Sc. (Computer Science) / Sem 3 · 82 papers
Questions? Email contact@munotes.in
Done!