Week 3 – Database Operations and Data Recovery

Resources:

  • Completed Week One Individual Assignment titled, “DreamHome Case Study”
  • Completed Week Two Individual Assignment titled, “Object Oriented Data Model and SQL Query Definition”
  • Appendix A, “User Requirements Specification for DreamHome Case Study” of Database Systems: A Practical Approach to Design, Implementation and Management(6th edition).

Consider instructor feedback from your Week 2 Individual assignment, “Object Oriented Data Model and SQL Query Definition” as you complete this assignment.

Define the maintenance and security components necessary for the data models created in the following Individual assignments:

  • Week One “DreamHome Case Study”
  • Week Two “Object Oriented Data Model and SQL Query Definition”

Include the following in your definition:

  • How data replication will be used in the system
  • An effective and efficient recovery strategy

Document your components as follows:

  • A 2- to 3-page Microsoft® Word document for your definition of maintenance and security components
  • Revised diagrams in Microsoft® Visio® from previous assignments with annotations identifying the maintenance and security components

Note: The results of this assignment will be used in future DreamHome-related Individual Assignments in Weeks Four and Five.

Submit the assignment.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp