a) Explain database system with its purpose and advantages (8M)
b) Write a note on data models and explain any two data models (7M)
Or
c) Explain ER-Diagram with symbols and example (8M)
d) Write a note on keys in relational database with examples (7M)
a) Explain normalization and its types with examples (8M)
b) What is SQL? Explain any 4 SQL commands with syntax (7M)
Or
c) Explain transaction management with ACID properties (8M)
d) What is indexing? Explain its types and advantages (7M)
a) Explain relational database model with its characteristics (8M)
b) Write a note on database architecture and explain three-level architecture
(7M)
Or
c) Explain entity, attributes and relationships in ER-Model with examples
(8M)
d) What are integrity rules? Explain with examples (7M)
a) Explain functional dependencies with examples and Armstrong's axioms
(8M)
b) What are views in SQL? Explain with syntax and example (7M)
Or
c) Explain concurrency control techniques in database (8M)
d) What is query optimization? Explain its need and techniques (7M)
a) Explain business rules and their importance in database design (8M)
b) Write a note on Codd's rules for relational database (7M)
Or
c) Explain degrees of data abstraction with examples (8M)
d) What is relational schema? Explain with example (7M)
a) Explain hashing and its types in database indexing (8M)
b) What are triggers in SQL? Explain with syntax and example (7M)
Or
c) Explain database recovery techniques with examples (8M)
d) What is file structure in database? Explain its organization methods (7M)