User Account

All Pages

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

  Describe the original data warehouse designed

Q1: Describe the original data warehouse designed for Indiana University Health and its limitations. Please describe the new data warehouse and the differences between each?

  Explain two ways that organizations today use databases

In your own words, provide a definition of the term "database", and explain at least two ways that organizations today use databases. Next, describe one way that you could use Access in your personal or professional life.

  How does data leakage occur in an organization

How does data leakage occur in an organization? What are the common causes of this problem? How would use address this troublesome trend? Use your textbook, internet, and other publications to research this topic.

  Open source relational database management system

Imagine you are a part of a team that is tasked with writing a mobile application (app) that will allow users to send pictures to their friends. The manager does not want to waste time creating code modules.

  Use the contents of figure 1 to work problems 1-31write the

use the contents of figure 1 to work problems 1-3.1.write the business rules that govern the relationship between agent

  Explain typical situations when denormalizing a table

Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.Provide one (1) example that is relevant to a college environment that illustrates reasons for c..

  Implement a white box informal database security

Create a planning and preparation checklist common to all security tests as a whole - Identify any special planning and preparation needed for each test.

  Compute variable overhead spending variance

Order Up, Inc. provides order fulfillment services for e-commerce merchants. The company maintains warehouses that stock items carried by its clients.

  Relational algebra expressions for names of salespeople

Illustrate relational algebra expressions for names of all salespeople, names of all salespeople having ORDER row and names of salespeople not having ORDER row.

  Write a join query that for every order

Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the customer who placed the order.

  Design the database using the er approach

Design the database using the ER approach and then create the tables accordingly. Populate the tables

  Write down subquery to sort result in descending order

Write down your subquery MAX_CALC_SAL. Name columns in result JOB_TITLE and JOB_TOTAL, and sort result on JOB_TOTAL in descending order.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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