DBMS Tutorial Questions

DBMS

TUTORIAL QUESTIONS

TUTORIAL - 1

1. Explain basic Concepts of Data and Information with example.

2. Explain Information Systems and File organization.

3. What is DBMS?. Explain architecture of DBMS.

4. Difference between DBMS and traditional file storage system.

5. What is data model?. Explain types of data models.

6. Explain Components of DBMS Data Independence.

7. What is project operation?. Explain types of attributes Entity types.

8. Difference between Relationship and Cardinalities.

TUTORIAL - 2

1. Explain domains, tuples, attributes.

2. What is keys? Explain types of keys.

3. Explain about the following relational algebra operators by giving suitable example Union ,division,rename,difference.

4. Consider the following Employee database :  Employee (Emp-name,street,City)  Work (Emp_name, company name_Salery)  Company (Company_name, city)  Manages (Emp_name ,managers_name) Write expression in SQL and QUEL for the following queries :  1. Find all employees who live in the city where the company for which they work is located.  2. Find all employees who live in the same city and on the same street as their managers.  3. Find all employees in the database who do not work for ABC corporation.  4. Find all employee names who earn more than every than every employee of ABC corporation.  5. Find all company names located in every city in which ABC corporation is located.

5. Discuss entity and referential integrity constraints. Why each is considered important.

6. Consider the following database primary key underlined :  Employee (ENO. DOB, ADDRESS, SEX, SALARY, NAME, DNOSUPER END)  Department (DNO, D Name, MGRENO, MGR start date )  Dept-location (DNO,Diocation)  Project (PNAME, PNO, Placation, DNO)  Works (ENO, PNO, hours)  Department (ENO, dep-name, Sex, bate, relationship) For each of the following quires given expression in SQL and relation algebra :  1. Retrieve the names if all employees in department  2. List the name of all employee who have no dependents  3. Retrieve the name of all employee who do not work on any project  4. Retrieve the average salary of all female employees.  5. Find the names of all employee who work on at lest one project locted in Hyderabad. Write SQL statements for the above database

7. Differentiate between intension and extension.

TUTORIAL - 3

1. Explain database methodologies with example.

2. Difference between relation schema and functional dependencies.

3. Discuss basic concepts of normal forms. Explain 1NF and 2NF.

4. Difference between 3NF and BCNF with example.

5. Difference between dependency preservation and Query processing.

6. Explain Project & join operation of relational algebra.

TUTORIAL - 4

1. What is transaction processing.

2. Explain transaction properties and transaction states.

3. What is serializability?. Explain types of types of serializability.

4. What is Concurrency Control?. Explain types of locks.

5. Explain shadow paging and check points.

6. Explain storage structure.

7. Explain hashing techniques.

TUTORIAL - 5

1. QUESTION

2 . QUESTION

3 . QUESTION

4. QUESTION

5 . QUESTION