DBMS LAQ FOR MBA SYSTEM 1. With a neat diagram, explain the structure of a DBMS. 2. What is data integrity? Explain the types of integrity constraints. 3. Explain 1NF, 2NF, 3NF and BCNF with suitable example. 4. What are the pitfalls in relational database design? With a suitable example, explain the role of functional dependency in the process of normalization. 5. Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. State any assumptions you make. 6. Discuss Join Dependencies and Fifth Normal Form, and explain why 5NF? 7. What is a view? How can it be created? Explain with an example. 8. Write short notes on the following:...