Create and maintain a database server

Assignment Help Database Management System
Reference no: EM132174013

Tasks Objectives:

1. Create and maintain a database server

2. Implementing Database security policies

Task # 1 Submit a work proposal for this assignment by the end of week 4th i.e. 3rd November, 2018 (11:59 pm) which must include:
- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 and task-3.
- Resources identified

The work proposal must be submitted in a word file through the Turnitin link available in Moodle.

Task # 2 The Muscat Bank is one of the largest banks in the Middle East region. It is operational since 2002 providing services to its customers round the clock. It offers many financial services including savings, deposits, loans, credit cards etc. It has a large customer base of around 1.5 million. One of the key requirements of the Muscat Bank is availability of data.
a) As a Database Administrator, suggest a relevant database management system (DBMS) for Muscat Bank. Your solution must include comparison of at least 3 relevant DBMS with valid examples.

Note: Solution must be written in your own words and should not exceed 3 pages.
b) As part of providing data security for Muscat Bank database, demonstrate practically the steps involved in user level/tablespace data backup and recovery.
* You must create a user as your first name (e.g. Ahmed), provide appropriate privileges for creating table(s) and insert records. Your solution must include brief explanation of all the parameters and SQL
commands and screenshots showing the steps.

Task # 3 a) The web link to the following research paper is given in the college Moodle web page:
Sapna Jain, M Afshar Alam, Comparative Study of Traditional Database and Cloud Computing Database, International Journal of Advanced Research in Computer Science.
Compare the traditional database environment with cloud databases. Solution should also include security concerns in a cloud databases. Note: The solution must be given in your own words with relevant examples not exceeding 2 pages. The given research paper is for your reference only and your answer should not be limited to this research paper only. You may refer various other resources and provided references for the same.

b) Create three users in a database e.g. user1, user2 and user3 and grant basic privileges to create tables and execute the code. Create any table (e.g. T1) by connecting to the database as user1. As a high privilege user e.g. System give the following permissions to user1 and user2:
- User1 should be able to insert and update records on table T1
- User2 can access the table T1 records for read only purpose.

- Both user1 and user2 should not be able to delete records from table T1.

Note: Your solution must include the necessary SQL commands (as screenshots) with brief explanation for each of the commands.

Reference no: EM132174013

Questions Cloud

Disintegration-reintegration process : Please Explain why development is considered a disintegration-reintegration process.
The target demographics in your marketing strategies : What are the target demographics in your marketing strategies? Where do you see overlap between your two different types of properties?
What amount will kate company report as depreciation expense : Kate Company purchased a tractor at a cost of $180,000. What amount will Kate Company report as depreciation expense
Diversity programs can lead to increases in business : Workforce diversity can lead to increase in business success. Diversity programs can lead to increases in business.
Create and maintain a database server : Database Administration - COMP 30021 - Create and maintain a database server - Implementing Database security policies
Pneumonia-diarrhea-malaria-measles or undernutrition : Do you know any children who have died from pneumonia, diarrhea, malaria, measles, or undernutrition?
Discuss your understanding of aggregate planning : Discuss your understanding of aggregate planning and its significance in the production planning process.
Why medical tourism is becoming popular among americans : From the e-Activity, examine the primary reasons why medical tourism is becoming popular among Americans, and determine whether or not the health care industry.
Are specifically responsible for assisting : Are specifically responsible for assisting and advising line manager in areas like recruiting, hiring and compensation.

Reviews

len2174013

11/22/2018 9:01:20 PM

Deliverables 0-7 8-17 18-25 Task 2b Incorrect steps / mostly incorrect steps Few steps are missing / no explanation / explanation is weak / fair Steps are mostly clear/ explanation is good / very good / excellent Deliverables Aspects 0-7 8-17 18-25 Marks Task 3a Compare traditional and Cloud computing database Implementing database security policies. Poor / weak analysis some concepts are clear / limited analysis Good / very good / excellent understanding of the concepts Deliverables 0-4 5-8 9-15 Task 3b Commands - Incorrect / mostly incorrect Commands – few correct / fairly correct with fair explanation Mostly commands are correct/ explanation is fair/clear

len2174013

11/22/2018 9:01:11 PM

Student Id. and Name: Deliverables Aspects 0-10 Marks Task 1 Submission of work proposal • Objectives of the Assignment clearly identified: poor/ fair / clear • Initial understanding of Task -2 and Task-3: poor/fair/clear • Resources identified: poor/fair/clear Deliverables Aspects 0-7 8-17 18-25 Marks Task 2a Relevant database management system Implement data backup and recovery Poor / weak / mostly incomplete analysis some concepts are clear / limited / fair anlaysis Good / very good / excellent understanding of the concepts

len2174013

11/22/2018 9:00:51 PM

? Assignment Name ? Section Name ? Student name ? Student ID Number ? Faculty Name ? The Table of Contents Should have, each deliverable task number, content, page number ? Assignment should be typed in your own words using Times New Roman font size 12. ? Heading should be with Font Size 14, Bold, Underline ? Feedback shall be given in Moodle within one week from the last date of submission of work proposal and within two weeks after submission of final assignment document.

len2174013

11/22/2018 9:00:43 PM

Guidelines Follow the guidelines mentioned below for your assignment: ? Code developed (Soft Copy) should be included. Assignment must be submitted through Moodle and it will undergo plagiarism detection test through turnitin (a plagiarism detection tool). ? Handwritten assignments / hard copy will not be accepted. ? Use Page Number & proper References. ? Assignment should have a Title Page. Title Page should contain the following information.

len2174013

11/22/2018 9:00:39 PM

There will be no marks without a viva. Viva will be used as a means to measure the originality of your work. You would be evaluated on the following: • Originality of answer, i.e. writing in your own words with some amount of referenced material. • Oral examination: Your Assignment marks are based on the VIVA which will be conducted upon submission of assignment. The VIVA will be based on the tasks given in the assignment. ZERO marks will be awarded to the student if she / he is absent for VIVA. • Correct information analysis and presentation in document form. • Adequate referencing and citation provided • Examples can be provided if needed

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