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
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
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.
Recently Asked Questions
- 1. Complete the following table. Class A Class B Class C Number of bits in the network part Number of bits in the host part Subnet mask Number of usable PCs in
- A student course grade is based on one midterm that counts as 15% of his final grade, one class project counts as 15% of his final grade, a set of homework
- How would you describe Patagonia’s supply chain and innovation strategy? What are the pros and cons of such a strategy? 2. What are the tensions for