Q1. Describe the fundamental issues in the design of an E-R database schema.
Q2. Describe the Relational Algebra with its basic operations.
Q3. Describe the pitfalls in the Relational-database design.
Q4. What do you mean by hashing? Describe the various Hashing methods in detail.
Q5. Describe the DDL, DML commands in SQL with appropriate illustrations.
Q6. Describe how arithmetic computations and aggregate functions are employed in the SQL queries with illustrations.
Q7. Describe the fundamental structure of SQL expression and describe how security can be accomplished in SQL.
Q8. Describe the overall system structure of DBMS with appropriate block diagram.
Q9. Illustrate the features of the DBMS? Compare and contrast it with the traditional file systems.