Manage database instances and database storage

Assignment Help Database Management System

Reference no: EM132609250

COMP 30021 Database Administration - Middle East College

Learning Outcome 1: Manage database network (client/ server) connections using Database Net Services

Learning Outcome 2: Manage database instances and database storage.

Learning Outcome 3: Working with Distributed Databases.

1) The Database Administrator (DBA) of a Client-Server environment needs to establish a connection between its clients and the database server. Consider the following sales event that happens in a hypermarket. "Customer picks up the items and reaches the sales counter to purchase the same". Discuss the steps involved with respect to the sequence of actions as per the architecture of client server environment. Note that the discussion expects a customized diagram of the client server architecture (not the generic architecture) that is relevant to the sales event. Also note that generic explanation will carry no marks. Carry out some simulation experiments in the database lab and write an illustrative and reflective summary on the process involved. The discussion can have appropriate screen shots to illustrate the successful connectivity; and reflection on the process should be of not less than 1000 words.

2) Assume that you are employed as a database administrator (DBA) of a reputed hyper market in Sultanate of Oman overseeing all the operations of the hyper market database. Demonstrate the mechanism of database replication process that is supported by the typical DBMS hosting the hyper market database. Please note that database replication involve providing backup of the database. The demonstration should include creation of some physical and logical database structures, and select appropriate backup mechanism to back up the created logical tables.

3) a. Al-Fajr polyclinic has different branches spread across multiple locations (like Ruwi, Al- Seeb, Sohar) in the Sultanate of Oman. Each branch has its own database. For effective utilization of all resources the management has decided to link all those independent databases to a Headquarter database simulating the distributed database concept. With the help of appropriate block diagrams, explain how you would view this in a homogeneous environment.

b. With appropriate snippets of SQL code, discuss the concept of Database link which is used to enable the access to other databases. Write SQL command to link the above mentioned poly clinic database of a branch to the headquarters.

Attachment:- Database Administration.rar

Reference no: EM132609250

Questions Cloud

What is the operating cash flow based on the indirect method : Accounts payable increased by $9,000. Assume other accounts remaining the same, what is the operating cash flow based on the indirect method

What is the labor rate variance : A restaurant has following information. Budget working hours: 3,900 and Actual hours worked: 4,000. What is the labor rate variance

Software engineering models and methods : Select two types of software engineering models. Explain how they are used to help engineers define, design, and develop software systems.

How covid affected : How Covid-19 affected the M2 and M3 and which monetry aggregates affected more by the recent pandemic. Explain in detail.

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

How balance sheet of centeral bank different from commercial : How balance sheet of centeral bank is different from commercial banks? How covid-19 may affects the financial statements of commercial banks

How you would turn a conflict into a positive interaction : Working as a group, write a 1-page role-play script in Microsoft Word depicting a conflict that may arise as you inform the CIO of the deficiencies and how you.

Calculate EBIT and EPS at breakeven point : Moses Company has a total asset of 400,000 of which 30% is debt with 12% interest and 70% is equity. Calculate EBIT and EPS at breakeven point

How much equity will pak budi give up to generate : If the agreement is made according to Pak Budi's projections, what is the compound rate of return each year that Pak Budi will get over a period of 5 years?

User Account

All Pages