Manage database network connections

Assignment Help Database Management System

Reference no: EM132869074

COMP 30021.1 Database Administration - Middle East College

Learning Outcome 1: Manage database instances and database storage
Learning Outcome 2: Work with Distributed Databases
Learning Outcome 3: Manage database network (client/ server) connections using Database Net Services

Assignment Objective
The objective is to enable the student to work on a relational database server and involve in creating, securing and maintaining of objects needed for databases. Hence, student's ability to think and engage with the topic is tested.

Assignment Tasks

1) Task 1 - Submit a work proposal for this assignment on or before 03/05/2020 (23:59) which must include:
• An Understanding of deliverables - a detail description of deliverables.
• A General overview of proposed plan.
• References and resources needed for completion of the given tasks.
The work proposal must be submitted in a word file through the link available in Moodle.

2) Task 2 - SQL/XML is an extension to the SQL standard that specifies SQL-based extensions for using XML in conjunction with SQL,

a. Explore XMLElement() to Generate Nested XML Document with appropriate code and explanation.

b. Explore XMLElement() to Generate XML document containing an elements with its attribute on some specific condition with appropriate code and explanation.

Note:
• Please ensure that the names of all table, elements, attributes must have your student ID at the end like Order_17F1234.

3) Task 3- Write a detailed reflection on "Comparison of NoSQL and SQL Databases in the Cloud". You can include some more resources for building up your reflection. The web link to a research paper "Comparison of NoSQL and SQL Databases in the Cloud" is given in the college Moodle web page

4) Task 4 - "A flashback query is used to retrieve the committed data as it was at a past point in time". Demonstrate this feature with proper code and explanation in your own words not exceeding 500 words.

Attachment:- Database Administration.rar

Reference no: EM132869074

Questions Cloud

Discuss the overall positive and negative implications : Discuss the overall positive and negative implications of upgrading the organizational Web site for the Woodworker Cabinets company.

What is the amount of income : What is the amount of income (expense) that DEF would record as a result of the above facts for the year ended December 31, 2020

Lot of confusion about data vs. information vs. knowledge : After the first meeting there was a lot of confusion about data vs. information vs. knowledge.

What is the size of each payment : You wish to make payments once every two weeks for 25 years to pay off the mortgage, with the first payment two weeks from now. What is the size of each payment

Manage database network connections : Manage database network (client/ server) connections using Database Net Services and Manage database instances and database storage

How corporations and individuals in positions of power : Examples of how corporations and individuals in positions of power and authority have acted unethically either by their actions or inactions.

What skills do the individuals need to improve : What skills do the individuals need to improve? What is the mode of training? For example, will you use role plays, videos, job shadowing

Why should an organization implement an erm application : What are some key challenges and solutions to Implementing an ERM? Why should an organization Implement an ERM application?

Regarding the manufacturing process : What are two items regarding the manufacturing process related to the organization that the team finds unique or interesting?

User Account

All Pages