write my assignment 12358

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.