Identify and elaborate a suitable database architecture

Assignment Help Database Management System
Reference no: EM131465290

Tasks Objectives:

1. Undertake operations required of a Database Administrator
2. Manage client-server connections using RDBMS Net Services
3. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system.

Task # 1 Submit a work proposal which must include:

- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 to task-4.
- Resources identified
The work proposal must be submitted in a word file through the link available in Moodle.

Task # 2 FreshMart Co. is an upcoming hyper market chain in the gulf region. They are planning to launch several branches across the gulf countries. The various branches of FreshMart Co. would be spread across different cities of the gulf region and their head office would be located in Muscat city. These chains of hyper markets work round the clock. The management of this organization is also planning to provide online shopping facility for its customers.

Consider you are working as a DBA for developing a system for this organization.

Identify and elaborate a suitable database architecture for implementing the various business requirements of FreshMart Co.

Discuss the various challenges you may face as a DBA in establishing application and data security of FreshMart Co.

Task # 3 Reade the research article "DATABASE SECURITY - ATTACKS AND CONTROL METHODS" As a database administrator, summarize in your own words (not more than 1.5 pages) on the control methods for the database threats. List and discuss at least five methods.

The given article is for your reference only and your answer should not be specific for a certain database system but it should be a generic one. You may consult various other sources and need to provide the desired references appropriately.

Task # 4 Your database lab is a networked lab. Provide the details of parameters that need to be set at database server and client side for proper connectivity between them.

You may consider ORACLE DBMS software in the lab as back end. Create simple form using VB.NET or ASP.NET or JAVA API as front end tool. Explain the necessary steps with relevant commands to configure the database connectivity to the application.

Article - International Journal of Information Sciences and Techniques (IJIST) Vol.6, No.1/2, March 2016

DATABASE SECURITY - ATTACKS AND CONTROL METHODS by Mubina Malik and Trisha Patel

Verified Expert

The solution file is prepared in Msword with 1100 words including references. This report is discussed about the two tasks. Task 2 is explained about the implementation of the database architecture and data security and challenges faced by DBA which is based on case study. Task 3 is explained about the five methods of access control.

Reference no: EM131465290

Questions Cloud

What measures would you recommend be included in the study : What measures (e.g. Medicare patients only) would you recommend be included in the study (identify at least 3)? Where would you locate the data elements?
Describe the risks associated with excess body fat : Analyze and explain the associated health problems of the obesity epidemic and eating disorders such as anorexia nervosa, bulimia nervosa, and binge-eating.
Different types of knowledge : 1. Identify the different types of knowledge needed throughout the growth of the new venture.
Create a professional analysis of the data : Create a professional analysis of the data. If the data set is broad, you should focus on one area to provide a professional business presentation
Identify and elaborate a suitable database architecture : Advanced Database Administration (COMP 0343) Identify and elaborate a suitable database architecture for implementing the various business requirements of FreshMart Co - Discuss the various challenges you may face as a DBA in establishing application..
Describes the good apples group facility : In order to complete this project, please read the attached document Good Apples Group Case. This document describes the Good Apples Group facility.
Role of social media in employee staffing : The paper length should be a minimum of 10-12 pages and comply with all formatting and APA style standards.
Draw the required free-body diagrams for the two bodies : The cylinder in Figure has mass M and radius r and rolls without slipping on the horizontal plane. It is connected at A via a frictionless joint to a bar OA.
What could you do to test or confirm the credibility of them : Describe at least 3 criteria that would determine whether the manager is making good decisions.

Reviews

len1465290

4/17/2017 6:15:21 AM

Deliverables Aspects 0-10 11-20 21-30 Marks Task 3 Database administrat ors tasks Poor / weak analysis some concepts are clear / limited analysis Good / very good / excellent understanding of the concepts Deliverables Aspects 0-10 11-20 21-30 Marks Task 4 Manage client/serve r connection s Poor / weak analysis/ basic implementation and understanding Limited / fair analysis/ partial implementation and adequate knowledge Good / Very Good implementation/ Excellent knowledge.

len1465290

4/17/2017 6:15:12 AM

Deliverables Aspects 0-10 Marks Task 1 Submission of work proposal • Objectives of the Assignment clearly identified: poor/ fair / clear • Initial understanding of Tasks -2 to Task-4: poor/fair/clear • Resources identified: poor/fair/clear Deliverables Aspects 0-5 6-10 11-15 Marks Task 2a RDBMS Net Services Poor / weak analysis some concepts are clear / limited / fair analysis Good / very good / excellent understanding of the concepts Deliverables Aspects 0-5 6-10 11-15 Marks Task 2b Operations of a DBA. Poor / Weak analysis Limited / fair analysis Good / very good / excellent understanding of the concepts

len1465290

4/17/2017 6:14:53 AM

Guidelines Follow the guidelines mentioned below for your assignment: ? 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. ? 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

len1465290

4/17/2017 6:14:39 AM

Evaluation Criteria: 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

len1465290

4/17/2017 6:14:35 AM

I want this assignment. Please hire a professional tutor for this assignment. Only task 2 and task 3 should be done. Task 3... the article is attached below. Please check... and let me know how much? Objectives: 1. Undertake operations required of a Database Administrator 2. Manage client-server connections using RDBMS Net Services 3. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system.

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