Describe how Database Management System is helpful over the traditional database.
[7 marks]Define Data and information. Explain how raw data is transformed into meaningful information.Elaborate with real life examples.
[7 marks]Explain database languages with their uses.
[7 marks]Compare and contrast different data models are used in DBMS.
[7 marks]Discuss data independence and data abstraction.
[7 marks]Define entity,attribute and relationship with example in detail.
[7 marks]State and explain various features of the ER model.
[7 marks]What is the ER model, and why is it used in database design? How does it help in representing real-world entities and their relationships?
[7 marks]What is generalization? How is it different from specialization?
[7 marks]What are the conditions required for a relation to be in 2NF, 3NF and BCNF explained with examples.
[7 marks]Explain about Integrity Constraints over relations in detail?
[7 marks]What are functional dependencies? How it works in DBMS.
[7 marks]Explain SQL language with their functions.
[7 marks]What is a sub query?Also, explain scenarios where sub queries are preferred with an example of a student database.
[7 marks]How to create ,update, and delete view in SQL, Explained with an example.
[7 marks]Page 1 of
[2 marks]Explain the purpose of the GROUP BY clause in SQL. How does it work? Provide an examples that demonstrate grouping on one and multiple columns.
[7 marks]Explain SUM(), AVG(), COUNT(), MAX(), and MIN() function.Provide an example of each functions with select statement. Page 2 of
[2 marks]