Compare and contrast at least two types of database

Assignment Help Database Management System
Reference no: EM131311604 , Length: word count:500

Learning Outcomes

1. Manage user access and user profiles within a complex DBMS

2. Conduct database audits

3. Develop backup and recovery procedures

Read the given scenario and perform all tasks. You have to answer all questions with respect to Database Security concepts.

HomeForOrphans is a charity organization that organizes different events for the benefit of homeless children. An event will always have a sponsor and will be linked by different participants from different company team. An event will be hosted by one of the coordinators of HomeForOrphans. Currently, the HomeForOrphans records in all the events, sponsors, participants, coordinators, and company team manually, where all the staffs have access (adding new record, crossing-out incorrect details, updating incomplete details, etc). HomeForOrphans encountered some problems with the current manual system like coordinators were assigned to two different events at the same time; some participants details were missing or some participants were listed twice for some event that affects the availability of participant slot (the organization followed that the maximum number of participants in any event should be at most 100); some events were duplicated; unable to give a report on time; and in some occasion, the cost of the event is more than the allocated budget by the sponsor but as per the operation requirement of the organization, the cost of an event should not be more than 60% of the given budget. Due to these problems, the management of HomeForOrphans decided to change the current system to a database application. You have been hired as the DBA to analyze the data requirements, security and define back-up method to use. During data gathering, you have identified that HomeForOrphans has one CEO, one manager, six coordinators who are also responsible for creating different events and looking for sponsors. After several discussions with the management and staff of HomeForOrphans, you have designed the below given ER model.

2341_Figure.jpg

Task: Compare and contrast at least two types of database backup. Then suggest and justify which type of database backup would be more suitable to the organization.

Reference no: EM131311604

Questions Cloud

Explain the importance of encryption : Suppose an executive-level manager asked you to explain the importance of encryption. Detail the key points that you would use to justify the importance of using encryption during the overall security posture analysis of the executive-level manage..
Project evaluation and microsoft solutions framework : Analyze the relationship between a Feasibility Study and a Cost-Benefit Analysis. Investigate the main reasons why both of these evaluations must tie to the organizational strategic plan. Suggest two (2) issues that an organization may face if the..
Draw a diagram to show the variation in the investors profit : When will the option be exercised? Draw a diagram to show the variation in the investors profit and the share price at the maturity of the option.
What dimensions of information would you include : Consider the issue of timely information with respect to the businesses discussed in the case. Which of the businesses must have the most up-to-date information in its data warehouse?
Compare and contrast at least two types of database : Compare and contrast at least two types of database backup. Then suggest and justify which type of database backup would be more suitable to the organization.
How could monetary policy have ensured a faster return : How could monetary policy have ensured a faster return to the long-run equilibrium? Use the money market and LM curves to show this.
How is this experiment similar to the experiments : What was wrong with these arguments? How is this experiment similar to the experiments performed by Nazi doctors? What can we do to make sure such experiments are not carried out ever again
Effects of the use of information technology : The readings this week raise issues that are direct or indirect effects of the use of information technology:
Explain how does international trade affect market structure : Describe which market structure you would prefer for buying products.How does international trade affect each market structure?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd