This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Composite attribute Derined attribute Write an entire diagram which explains the whole database. Spring 2010 (Jan-June) Master of Business Administration- MBA Semester 3 MI0025 – Database Management System -2 Credits (Book ID :B1016) Assignment Set- 2 (30 Marks) Note: Each question carries 10 Marks. Answer all the questions. Q1. Explain relationships with an example. Also show degree of relationship for that example Q2 . Explain the different operations of relational algebra with an example each Q3 . a. Write SQL query for the following i. To find the student who scored more than ‘Rashmi’ in computer Science subject. ii. List all the students who belongs to class II b. Define locks. Write a binary lock function....
View Full Document
- Spring '10