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

Create a table with headers

In the lookup workbook, create a table: with headers: Region, Metro, University, Employment, Enrollments 2. Build the table using direct sourcing from the appropriate ta

Create microsoft access database

Create a Microsoft Access database. Create the tables, fi elds, data types, and primary key(s) for the database. Create the relationship(s) needed between the tables.

Create an entity relationship diagram

For your final project you will create an Entity Relationship Diagram (ERD), create tables in your own database, and import data into these tables. For Part 1 of the Project

Write one sql statement to implement

Write ONE SQL statement to implement each of the tasks. Please do not hardcode to skip joins (your code need to work regardless of rows in the tables) - write an anonymous P

Explain how data mining be used to imporve customer service.

Please explain how a databses management system (DBMS) and data mining can help a motor vehicle maintenance center improve its services, and what tables would be needed in s

Discuss about the data warehousing design

Create a database schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for t

Write a program that will open a blastn

Write a program that will open a BLASTN nucleotide to nucleotide search output file, parse out specific information, and produce formatted output that will be written to STD

Describe the client-server architecture

Describe the client/server architecture. Explain the client role. Explain the server role. Give an example. Explain business logic and describe how it relates to a relational

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

 
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