Answer the following question. i. Define term: Composite attribute ii. What is Database? iii. What is Meta data? iv. What is the difference between DROP and DELETE command? v. What is Rollback? vi. What is Prime attribute? vii. Define term: Data Redundancy. II.
[7 marks]What is database? Explain database structure with diagram.
[7 marks]What do you mean by concurrency control? Explain the types of problems encounter in Concurrency.
[7 marks]Draw the ER diagram for College Management System.
[7 marks]What are the responsibilities of the DBA and the database designers? Explain it in detail.
[7 marks]Explain the three tier architecture for web application.
[7 marks]What is Relationship ? Explain it’s types with example?
[7 marks]What is Functional Dependency? Explain Functional Dependency in detail with proper example.
[7 marks]Explain the use of Group by & having clause with example.
[7 marks]What is recovery? Explain different types of failure.
[7 marks]Explain ACID properties in details.
[7 marks]Write a short note on: system log & commit point.
[7 marks]Discuss First Normal Form (1NF) and Second Normal Form(2NF).
[7 marks]What do you mean by constraint? Explain the various constraints available with SQL.
[7 marks]Explain DDL & DML commands with example.
[7 marks]Explain Single value sub-query and multi value sub-query.
[7 marks]Explain Set operations in sql.
[7 marks]