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.

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?

User Account

All Pages