For questions requiring an explanation, answer in your own words (you’ll get a mark of 0 for copying and pasting from another source) and list your sources. In regards to DBMS performance, Show a simple example where a table normalized into two tables tak
For questions requiring an explanation, answer in your own words (you’ll get a mark of 0 for copying and pasting from another source) and list your sources. 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 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. Explore the web to find out about in-memory databases. Use at least three references, and list them. Do not copy and paste! 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.
