In regards to DBMS performance,
Show a simple example where a table normalized into two tables takes up more space than the denormalized original table,
despite a demonstrated reduction in redundancy.
Make up an example of two tables stored both separately and clustered.
Make up a checklist for database dependability checking. Imagine you are the DBA, and list the things you would
need to look at to ensure the database is
Recoverable - it can recover quickly from hardware/software or power failures.
Restorable - the system could somehow be brought up again relatively quickly after a disaster where the building burned down.
Some items might be features of the DBMS; others might be hardware or other software, or business arrangements and practices.
Explore the web to find out about in-memory databases. Use at least three references, and list them. Do not copy and
paste!
Explain how they work and what advantages and disadvantages they bring.
Explain what software/hardware/OS technology is necessary for them to work.
Explain what they will change in DBMS technology.