Module 2
1. Explain in detail entity relationship model?
2. Explain conceptual data model?
3. What is attributes and domain constraints?
4. Differentiate weak entity and strong entity?
5. Draw an ER diagram based on a loan?
6. Differentiate relational calculus and domain calculus?
7. What is relational algebra?
8. Write a short note on tuples and key?
9. Explain the concepts of EER?
Module 3
1. Explain relational database design?
2. Explain database anomalies in a database?
3. What is normalisation?
4. Explain functional dependencies?
5. Explain in first normal form?
6. Explain in detail second normal form?
7. Explain in detail third normal form?
8. Explain boyce code normal form?
9. Explain fourth and fifth normal form?
[Link] join dependencies?
Module 4
1. Explain the concepts of sql?
2. Compare the languages ddl and dml?
3. How can a table can create ,modify and delete ?
4. Explain in detail about constraints?
5. Brifly explain foreign key with examble?
6. What are the building functions in sql?
7. Explain the set operations?
8. How can we create and rename a view?
9. Explain group by and join by?
[Link] to use have clause and join clause?
Module 5
1. Explain transaction management?
2. Explain transaction properties?
3. Briefly explain the states of transaction?
4. What is concurrency control lost update problem?
5. Explain about the control structures?
6. Explain about the loops?
7. Write a short note on query lock?
8. Explain in detail about grant and revoke a function?
9. Explain triggers?
[Link] errors are handling in triggers?