University of Madras
Chepauk, Chennai - 600 005.
Chepauk, Chennai - 600 005.
B.Sc Computer Science
Subject Name: Database Management System
Month & Year: April 2008
Subject Code : PK5B
Year: Third
Semester: V
Time : Three Hours
Maximum : 75 marks
Month & Year: April 2008
Subject Code : PK5B
Year: Third
Semester: V
Time : Three Hours
Maximum : 75 marks
PART A - (10 * 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
1. What is database?
2. Write SQL command to retrieve all the data from table.
3. What is DCL?
4. What is join operation?
5. Define database privilege.
6. Who is a database administrator?
7. What do you mean by redundancy?
8. Mention any three table operations.
9. What is data aggregate?
10. Define class.
11. What is table?
12. What is primary key?
2. Write SQL command to retrieve all the data from table.
3. What is DCL?
4. What is join operation?
5. Define database privilege.
6. Who is a database administrator?
7. What do you mean by redundancy?
8. Mention any three table operations.
9. What is data aggregate?
10. Define class.
11. What is table?
12. What is primary key?
PART B - (5 * 6 = 30 marks)
Answer any FIVE questions.
Each answer should not exceed 200 words.
All questions carry equal marks.
Answer any FIVE questions.
Each answer should not exceed 200 words.
All questions carry equal marks.
13. What is meant by data independence? Explain the two types of data independence.
14. Explain the relational approach in detail.
15. Explain the domains and attributes with suitable example.
16. Write any six advantages of SQL DML when compared with lower level DML's.
17. What is union? Explain with an example.
18. Explain in detail about clustering and data partitioning.
19. What are the characteristics of data in database? Explain.
14. Explain the relational approach in detail.
15. Explain the domains and attributes with suitable example.
16. Write any six advantages of SQL DML when compared with lower level DML's.
17. What is union? Explain with an example.
18. Explain in detail about clustering and data partitioning.
19. What are the characteristics of data in database? Explain.
PART C - (3 * 10 = 30 marks)
Answer any THREE questions.
Each answer should not exceed 500 words.
All questions carry equal marks.
Answer any THREE questions.
Each answer should not exceed 500 words.
All questions carry equal marks.
20.What is normalization? Explain the normalization using functional dependencies.
21.What are the major objectives of a database system? Explain.
22.Discuss the duties and responsibilities of database administrator.
23.Discuss USER interface features.
24.Write a short notes on:
(a)Embedded SQL
(b)Nested subquries
25.Discuss on client-server database.
21.What are the major objectives of a database system? Explain.
22.Discuss the duties and responsibilities of database administrator.
23.Discuss USER interface features.
24.Write a short notes on:
(a)Embedded SQL
(b)Nested subquries
25.Discuss on client-server database.
Subject Name: Database Management System
Month & Year: November & 2012
Subject Code : SAZ5A
Year: Third
Semester: V
Time : Three Hours
Maximum : 75 marks
Month & Year: November & 2012
Subject Code : SAZ5A
Year: Third
Semester: V
Time : Three Hours
Maximum : 75 marks
PART A - (10 * 2 = 20 marks)
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
1. What are the Basic Components of a DBMS?
2. What is meant by First Normal Form?
3. Define: Data Dictionary.
4. What is SQL?
5. What is a subquery and in what situations it is useful?
6. What is the purpose of subforms?
7. What are the main reports types?
8. Define: Procedural Language.
9. What is the purpose of form events?
10.Define: Cluster Analysis.
11.Who is DBA?
12.Distinguish between Physical Security and Logical Security.
2. What is meant by First Normal Form?
3. Define: Data Dictionary.
4. What is SQL?
5. What is a subquery and in what situations it is useful?
6. What is the purpose of subforms?
7. What are the main reports types?
8. Define: Procedural Language.
9. What is the purpose of form events?
10.Define: Cluster Analysis.
11.Who is DBA?
12.Distinguish between Physical Security and Logical Security.
PART B - (5 * 5 = 25 marks)
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
13.Write Short Notes on: Data Types.
14.Discuss on Converting Class Diagrams to Normalized Tables, with examples.
15.Write Short Notes on: DDL Statements.
16.Discuss briefly on Form Layouts.
17.Write Short Notes on: Table Operations
18.Discuss in detail, Data Partitioning.
19.Write about Database Tasks by Development Stages.
14.Discuss on Converting Class Diagrams to Normalized Tables, with examples.
15.Write Short Notes on: DDL Statements.
16.Discuss briefly on Form Layouts.
17.Write Short Notes on: Table Operations
18.Discuss in detail, Data Partitioning.
19.Write about Database Tasks by Development Stages.
PART C - (3 * 10 = 30 marks)
Answer any THREE questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
Answer any THREE questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
20. What are the Advantages of a DBMS? Explain them.
21. Explain the computation using queries with suitable examples.
22. Explain creating forms with examples.
23. Explain the User Interface Features.
24. Describe in detail, Distributed Databases
21. Explain the computation using queries with suitable examples.
22. Explain creating forms with examples.
23. Explain the User Interface Features.
24. Describe in detail, Distributed Databases
Title of the Paper: Database Management System
Month & Year of Examination: November - 2011
Subject Code: PK5B
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
Month & Year of Examination: November - 2011
Subject Code: PK5B
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART A - (10 * 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
1. Define: DBMS.
2. What is second normal form?
3. Define: Data dictionary.
4. What is SQL?
5. What is the purpose of Group by Command?
6. Write a note on: Update command.
7. What are forms?
8. Define: Tabular reports.
9. What is meant by procedural language?
10. Define: Transaction.
11. What are distributed databases?
12. Define: objects.
2. What is second normal form?
3. Define: Data dictionary.
4. What is SQL?
5. What is the purpose of Group by Command?
6. Write a note on: Update command.
7. What are forms?
8. Define: Tabular reports.
9. What is meant by procedural language?
10. Define: Transaction.
11. What are distributed databases?
12. Define: objects.
PART B - (5 * 6 = 30 marks)
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
13. What are the advantages of DBMS? Discuss briefly.
14. Write short notes on: class diagrams.
15. What is the basic structure of Select command? Explain with example.
16. Write short notes on: Data Definition Commands.
17. What are the primary sections of reports? Discuss briefly.
18. Write short notes on: Custom reports.
19. Discuss briefly about client/server databases.
14. Write short notes on: class diagrams.
15. What is the basic structure of Select command? Explain with example.
16. Write short notes on: Data Definition Commands.
17. What are the primary sections of reports? Discuss briefly.
18. Write short notes on: Custom reports.
19. Discuss briefly about client/server databases.
PART C - (4 * 10 = 40 marks)
Answer any FOUR questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
Answer any FOUR questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
20.Explain the various components of a DBMS.
21.Discuss about third and Boyee-Codd Normal forms with examples.
22.Explain about queries with multiple tables with examples.
23.Discuss in detail, effective design of reports and forms.
24.Explain about user interface features.
25.Describe in detail, security and privacy.
21.Discuss about third and Boyee-Codd Normal forms with examples.
22.Explain about queries with multiple tables with examples.
23.Discuss in detail, effective design of reports and forms.
24.Explain about user interface features.
25.Describe in detail, security and privacy.
Title of the Paper: Database Management System
Month & Year of Examination: November - 2005
Subject Code:
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
Month & Year of Examination: November - 2005
Subject Code:
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART A - (10 x 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
1.Write a note on Query processor.
2.What are Events?
3.Write a note on Data Dictionary.
4.What is the use of ORDER BY clause? Give an example.
5. Write a note on CREATE VIEW command.
6.Write about UNION operator in SQL.
7.What are the basic types of forms?
8.What are the common uses for Report Layout Elements?
9.What are Tool bars?
10.Write a note on Data clustering.
11.List down the role of Database Administrator.
12.Write a note on OLE.
2.What are Events?
3.Write a note on Data Dictionary.
4.What is the use of ORDER BY clause? Give an example.
5. Write a note on CREATE VIEW command.
6.Write about UNION operator in SQL.
7.What are the basic types of forms?
8.What are the common uses for Report Layout Elements?
9.What are Tool bars?
10.Write a note on Data clustering.
11.List down the role of Database Administrator.
12.Write a note on OLE.
PART B - (5 x 6 ~ 30 marks)
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
13.Write short notes on class diagrams.
14.Discuss the common comparisons used in the WHERE clause of SELECT statement.
15.What are SQL Data Manipulation Commands? Discuss briefly with examples.
16.Write short notes on procedural languages.
17.Distinguish between Horizontal and Vertical Partitioning.
18.Write short notes on object oriented databases.
19.Discuss briefly about Microsoft COM and CORBA.
14.Discuss the common comparisons used in the WHERE clause of SELECT statement.
15.What are SQL Data Manipulation Commands? Discuss briefly with examples.
16.Write short notes on procedural languages.
17.Distinguish between Horizontal and Vertical Partitioning.
18.Write short notes on object oriented databases.
19.Discuss briefly about Microsoft COM and CORBA.
PART C - (4 x 10 = 40 marks)
Answer any FOUR questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
Answer any FOUR questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
20.Explain about various Database Components with a neat diagram.
21.Describe in detail, queries with Multiple Tables with examples.
22.Explain about effective design of Reports and Forms.
23.Describe in detail, Basic Report types with examples.
24.Explain about Data Storage Methods.
25.Describe in detail, Database Security and Privacy.
21.Describe in detail, queries with Multiple Tables with examples.
22.Explain about effective design of Reports and Forms.
23.Describe in detail, Basic Report types with examples.
24.Explain about Data Storage Methods.
25.Describe in detail, Database Security and Privacy.
Title of the Paper: Database Management System
Month & Year of Examination: April - 2009
Subject Code: PK5B
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART A - (10 * 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
1. Define Database Engine.
2. What is meant by Data Independense?
3. Define Composite Keys.
4. What is First Normal Form?
5. Define DDL.
6. Write a note on JOIN Operation.
7. What is the purpose of ALL Operator in SQL? Give an exampl
8. List the basic human factor design elements.
9. What are Switchboard Forms?
10. Define Cluster Analysis.
11. Define Database Administration.
12. Distinguish between Physical and Logical Security.
PART B - (5 * 6 = 30 marks)
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
13. Write short notes on Data Dictionary and Query Processor.
14. Discuss briefly about Associations and Relationships.
15. Write about Data types in Oracle database system.
16. What is Domain-Key Normal Form? Explain with an example
17. Explain about sub queries in SQL with suitable examples.
18. Write short notes on Basic Report Types.
19. Distinguish between Client\Server and File Server.
PART C - (4 * 10 = 40 marks)
Answer any FOUR questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
20. Explain about Feasibility Study.
21. Explain about computation using Queries with example.
22. Describe in detail, Creating Forms.
23. What are the issues involved in designing reports? Explain
24. Explain about Data Storage Methods.
25. Describe in detail, Object Oriented Databases.
Month & Year of Examination: April - 2009
Subject Code: PK5B
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART A - (10 * 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
Each answer should not exceed 50 words.
1. Define Database Engine.
2. What is meant by Data Independense?
3. Define Composite Keys.
4. What is First Normal Form?
5. Define DDL.
6. Write a note on JOIN Operation.
7. What is the purpose of ALL Operator in SQL? Give an exampl
8. List the basic human factor design elements.
9. What are Switchboard Forms?
10. Define Cluster Analysis.
11. Define Database Administration.
12. Distinguish between Physical and Logical Security.
PART B - (5 * 6 = 30 marks)
Answer any FIVE questions.
All questions carry equal marks.
Each answer should not exceed 200 words.
13. Write short notes on Data Dictionary and Query Processor.
14. Discuss briefly about Associations and Relationships.
15. Write about Data types in Oracle database system.
16. What is Domain-Key Normal Form? Explain with an example
17. Explain about sub queries in SQL with suitable examples.
18. Write short notes on Basic Report Types.
19. Distinguish between Client\Server and File Server.
PART C - (4 * 10 = 40 marks)
Answer any FOUR questions.
All questions carry equal marks.
Each answer should not exceed 500 words.
20. Explain about Feasibility Study.
21. Explain about computation using Queries with example.
22. Describe in detail, Creating Forms.
23. What are the issues involved in designing reports? Explain
24. Explain about Data Storage Methods.
25. Describe in detail, Object Oriented Databases.
Title of the Paper: Database Management System
Month & Year of Examination: November - 2009
Subject Code: PK5B
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART A - (10 * 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
1. List down the advantages of DBMS.
2. What are Class Diagrams?
3. Define First Normal Form.
4. Write the basic structure of SQL SELECT Statement.
5. What is meant by DDL?
6. What are Tabular Reports?
7. Define procedural language.
8. What is the use of "On-Error" statement? Give an example.
9. What are Table Operations?
10. Define Horizontal Partitioning.
11. What are Distributed Databases?
12. Define physical and logical security.
PART B - (5 * 6 = 30 marks)
Answer any FIVE questions.
All questions carry equal marks.
13. Discuss about Report Writer and Forms Generator modules of DBMS.
14. Explain about common Data types with examples.
15. Discuss briefly about GROUP BY clause with example.
16. Write short notes on Data On Forms.
17. Discuss about Custom Reports with example.
18. Write short notes on Sequential Storage.
19. Discuss briefly about Backup and Recovery.
PART C - (4 * 10 = 40 marks)
Answer any FOUR questions.
All questions carry equal marks.
20. Explain with examples, converting class diagrams to normalized tables.
21. Explain about Third and Boyee-Codd Normal Forms with examples.
22. Describe in detail, sub queries and joins with suitable examples.
23. Explain about basic human factors design elements.
24. Discuss in detail about Application Structure.
25. Explain about Client/Server Databases.
Month & Year of Examination: November - 2009
Subject Code: PK5B
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART A - (10 * 3 = 30 marks)
Answer any TEN questions.
All questions carry equal marks.
1. List down the advantages of DBMS.
2. What are Class Diagrams?
3. Define First Normal Form.
4. Write the basic structure of SQL SELECT Statement.
5. What is meant by DDL?
6. What are Tabular Reports?
7. Define procedural language.
8. What is the use of "On-Error" statement? Give an example.
9. What are Table Operations?
10. Define Horizontal Partitioning.
11. What are Distributed Databases?
12. Define physical and logical security.
PART B - (5 * 6 = 30 marks)
Answer any FIVE questions.
All questions carry equal marks.
13. Discuss about Report Writer and Forms Generator modules of DBMS.
14. Explain about common Data types with examples.
15. Discuss briefly about GROUP BY clause with example.
16. Write short notes on Data On Forms.
17. Discuss about Custom Reports with example.
18. Write short notes on Sequential Storage.
19. Discuss briefly about Backup and Recovery.
PART C - (4 * 10 = 40 marks)
Answer any FOUR questions.
All questions carry equal marks.
20. Explain with examples, converting class diagrams to normalized tables.
21. Explain about Third and Boyee-Codd Normal Forms with examples.
22. Describe in detail, sub queries and joins with suitable examples.
23. Explain about basic human factors design elements.
24. Discuss in detail about Application Structure.
25. Explain about Client/Server Databases.
Subject Name: Database Management System
Month & Year of Examination: November - 2007
Section A (15 x 2 = 30)
Answer all Questions
1. What do you mean by Data Inconsistency?
2. Give the expansion of E-R model and XML.
3. Define Mapping Cardinalities.
4. What is a primary key?
5. What is an assignment operation in relational algebra?
6. Define a view.
7. What is a Tuple?
8. What is dynamic SQL?
9. Define group by clause.
10. Mention some integrity constraints.
11. What is alteration authorization?
12. What is the usage of grant?
13. Define distributed system.
14. List out the various process in transaction server.
15. What is data caching?
Section B (6 x 5 = 30)
Answer any Six Questions
16. Explain any three disadvantages of file system.
17. What are the applications of a database system?
18. Write short notes on a) Super Key b) Primary Key
19. Briefly explain the Domain Relational Calculus.
20. Briefly explain the basic structure of SQL.
21. Explain packages briefly.
22. What are domain constraints? Explain with suitable examples.
23. When is a relation said to be in the Boyce-Codd normal form?
24. Briefly describe centralized systems.
Section C (4 x 10 = 40)
Answer any Four Questions
25. Write short notes on a) Entity b) Entity Set c) Attribute d) Relationship e) Relationship Set.
26. Explain the operations used in the Modification of Database in Relational Algebra.
27. Explain all the commands under Data Manipulation Language.
28. Explain in detail the embedded and Dynamic SQL
29. What is normalization? Explain in detail.
30. Describe the network types in detail
Month & Year of Examination: November - 2007
Section A (15 x 2 = 30)
Answer all Questions
1. What do you mean by Data Inconsistency?
2. Give the expansion of E-R model and XML.
3. Define Mapping Cardinalities.
4. What is a primary key?
5. What is an assignment operation in relational algebra?
6. Define a view.
7. What is a Tuple?
8. What is dynamic SQL?
9. Define group by clause.
10. Mention some integrity constraints.
11. What is alteration authorization?
12. What is the usage of grant?
13. Define distributed system.
14. List out the various process in transaction server.
15. What is data caching?
Section B (6 x 5 = 30)
Answer any Six Questions
16. Explain any three disadvantages of file system.
17. What are the applications of a database system?
18. Write short notes on a) Super Key b) Primary Key
19. Briefly explain the Domain Relational Calculus.
20. Briefly explain the basic structure of SQL.
21. Explain packages briefly.
22. What are domain constraints? Explain with suitable examples.
23. When is a relation said to be in the Boyce-Codd normal form?
24. Briefly describe centralized systems.
Section C (4 x 10 = 40)
Answer any Four Questions
25. Write short notes on a) Entity b) Entity Set c) Attribute d) Relationship e) Relationship Set.
26. Explain the operations used in the Modification of Database in Relational Algebra.
27. Explain all the commands under Data Manipulation Language.
28. Explain in detail the embedded and Dynamic SQL
29. What is normalization? Explain in detail.
30. Describe the network types in detail
Title of the Paper: Database Management System
Month & Year of Examination: 2006
Subject Code:
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART B - [10 x 2 = Marks 20]
Answer ALL questions.
All questions carry equal marks.
1. What is Database Management System?
2. What is canonical schema?
3. List down the area characteristics of DDL.
4. What is Data Independence?
5. Define:
(a) Paging
(b) Staging.
6. What are homogeneous and heterogeneous trees?
7. Mention the objectives of storing the relationships separately from data.
8. What are triad queries?
9. How do you measure the hit rate?
10. Name the four levels of storage hierarchy.
PART B - [5 x 7 = Marks 35]
Answer ALL questions.
All questions carry equal marks.
11. (a) Explain the four major components of a database system.
(Or)
(b) What is functional dependency? Explain with examples.
12. (a) With an example explain how can a plex structure be normalized.
(Or)
(b) What are the various types of entries in which a schema is written in the CODASYL DD.
13. (a) Distinguish between the logical and physical organization of data.
(Or)
(b) What are pointers? Explain its advantages and disadvantages.
14. (a) Write short notes on multiple key retrieval.
(Or)
(b) Describe indexed sequential access method with suitable examples.
15. (a) What is data compactness? How is it achieved?
(Or)
(b) Explain any three memory replacement algorithms.
PART C - [3 x 15 = Marks 45]
Answer any THREE questions.
All questions carry equal marks.
16. What is a binary tree? Explain how a binary tree can be represented as an array.
17. List and explain the primary objectives of a Database Management System.
18. Define 3 NF. Give an example of a relation which is not in 3 NF and show how it is converted into 3 NF.
19. What is addressing? Explain any five addressing techniques.
20. Write short notes on:
(a) Virtual memory.
(b) Database security
Month & Year of Examination: 2006
Subject Code:
Semester: V
Year: Third Year
Time: Three hours
Maximum: 100 marks
PART B - [10 x 2 = Marks 20]
Answer ALL questions.
All questions carry equal marks.
1. What is Database Management System?
2. What is canonical schema?
3. List down the area characteristics of DDL.
4. What is Data Independence?
5. Define:
(a) Paging
(b) Staging.
6. What are homogeneous and heterogeneous trees?
7. Mention the objectives of storing the relationships separately from data.
8. What are triad queries?
9. How do you measure the hit rate?
10. Name the four levels of storage hierarchy.
PART B - [5 x 7 = Marks 35]
Answer ALL questions.
All questions carry equal marks.
11. (a) Explain the four major components of a database system.
(Or)
(b) What is functional dependency? Explain with examples.
12. (a) With an example explain how can a plex structure be normalized.
(Or)
(b) What are the various types of entries in which a schema is written in the CODASYL DD.
13. (a) Distinguish between the logical and physical organization of data.
(Or)
(b) What are pointers? Explain its advantages and disadvantages.
14. (a) Write short notes on multiple key retrieval.
(Or)
(b) Describe indexed sequential access method with suitable examples.
15. (a) What is data compactness? How is it achieved?
(Or)
(b) Explain any three memory replacement algorithms.
PART C - [3 x 15 = Marks 45]
Answer any THREE questions.
All questions carry equal marks.
16. What is a binary tree? Explain how a binary tree can be represented as an array.
17. List and explain the primary objectives of a Database Management System.
18. Define 3 NF. Give an example of a relation which is not in 3 NF and show how it is converted into 3 NF.
19. What is addressing? Explain any five addressing techniques.
20. Write short notes on:
(a) Virtual memory.
(b) Database security