What do you mean by data? How is it different from information? explain with the help of example.
[7 marks]What is DBMS? What are the advantages and disadvantages offered by such systems as compared to file processing system? Explain.
[7 marks]Explain Physical & Logical Database models in detail.
[7 marks]What is SQL? Explain the purpose and use of SQL in RDBMS. Also discuss the basic structure of an SQL expression.
[7 marks]Describe the architecture of a database system. Why is a database desired to be an integrated one?
[7 marks]Explain what is meant by normalization and its advantages. Explain and define 1NF, 2NF, 3NF & BCNF giving suitable examples for each.
[7 marks]The relational model is hardware-dependent and software-independent. Do you agree? Explain.
[7 marks]Compare & Contrast Database relationships, Hierarchical model, Network Model, Relational Model.
[7 marks]“Non-loss decomposition is an aid to relational databases”. Is it true? If yes, then justify it through an example.
[7 marks]Explain the Components of an E-R Model.
[7 marks]Consider the following table. Describe, and illustrate, the process of normalization up to BCNF. State and make assumptions, if any. Page 1 of
[2 marks]Differentiate between DDL and DML.
[7 marks]Which are the most popular RDBMS. Explain them.
[7 marks]Write a note on contemporary database trends & applications.
[7 marks]Explain why it is not always possible to perform SQL UPDATE/DELETE/INSERT statements on top of a view.
[7 marks]Discuss scenarios where a view can be helpful in a database management system.
[7 marks]Consider the following relations given as relationship model-person (Name, City, AccNo), deposit (AccNo, Balance). Considering at least five dummy records the database given above, show how this relational model can be converted into network model and hierarchical model. Page 2 of
[2 marks]