View the step-by-step solution to:

Spring 2010 (Jan-June) Master of Business Administration- MBA Semester III MI0025 - Database Management System -2 Credits (Book ID :B1016) Assignment...

.
Q1. a. Explain the various procedure carried on in a DBMS for a student database in which the fields are student id, student name, student class, marks
b. Write the difference between traditional file systems Vs modern database environment
Q2
a. Explain the following:
i. Physical data independence Vs logical data independence
ii. DDL Vs DML
b. Explain criterion for Database classifical
Q3. Draw an E.R diagram a school database which should describe the following
 Weal entity
 Identifying relationship
 Composite attribute
 Derined attribute
Write an entire diagram which explains the whole database.
Spring 2010 (Jan-June)


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.
Spring 2010 (Jan-June) Master of Business Administration- MBA Semester III MI0025 – Database Management System -2 Credits (Book ID :B1016) Assignment Set- 1 (30 Marks) Note: Each question carries 10 Marks. Answer all the questions. Q1. a. Explain the various procedure carried on in a DBMS for a student database in which the fields are student id, student name, student class, marks b. Write the difference between traditional file systems Vs modern database environment Q2 a. Explain the following: i. Physical data independence Vs logical data independence ii. DDL Vs DML b. Explain criterion for Database classifical Q3. Draw an E.R diagram a school database which should describe the following Weal entity Identifying relationship Composite attribute Derined attribute Write an entire diagram which explains the whole database.
Background image of page 1
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.
Background image of page 2

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question