Answered You can hire a professional tutor to get the answer.
1. In regards to DBMS performance, a) Show a simple example where a table normalized into two tables takes up more space than the denormalized
1. In regards to DBMS performance,
a) 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.
b) Make up an example of two tables stored both separately and clustered.
2. 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
a) Recoverable - it can recover quickly from hardware/software or power failures.
b) 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.
3. Explore the web to find out about in-memory databases. Use at least three references, and list them.
a) Explain how they work and what advantages and disadvantages they bring.
b) Explain what software/hardware/OS technology is necessary for them to work.
c) Explain what they will change in DBMS technology.
