written 5.6 years ago by
yashbeer
★ 11k
|
|
Computer Engineering (Semester 5)
Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Question No. 1 is compulsory
(2) Solve any three questions out of remaining questions
(3) Draw neat diagrams wherever necessary
1(a) Describe Data Independence.
(5 marks)
00
1(b) Compare File System and Database System.
(5 marks)
634
1(c) Explain ACID properties.
(5 marks)
654
1(d) Explain Aggregate Functions in SQL.
(5 marks)
648
2(a) Define Normalization. Discuss different Normalization Techniques with example.
(10 marks)
651
2(b) Describe the overall architecture of DBMS with suitable diagram.
(10 marks)
638
3(a) Explain types of integrity constraints with example.
(10 marks)
00
3(b) Draw an ER Diagram and convert it into relational model for a company, which has several Employees working on different types of Projects. Several Employees are working for one Department, every Department has a manager. Several Employees are supervised by one Employee.
(10 marks)
00
4(a) Discuss Data Definition and Manipulation Commands in SQL.
(10 marks)
653
4(b) Explain Security and Authorization in DBMS.
(10 marks)
00
5(a) Explain the following Relational Algebra Operations with example:
- (i) Cartesian product
- (ii) Project
- (iii) Natural Join
- (iv) Union
(10 marks)
00
5(b) Explain Log based recovery and shadow paging in detail.
(10 marks)
664
Q6) Write short notes on:
(20 marks)