Reference no: EM132270289

Learning Outcomes

1. Create and maintain a Database System
2. Design an enterprise data model that incorporates all of the data used by an organization's business processes
3. Devise and implement database security policies

Analyze the following SCENARIO and answer the following questions:

Assume that, we have the following application that simulate soccer teams, the games they play, and the players in each team. In the design, we want to reflect the following:

- We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs.
- Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses.
- Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team.

For each match we need to keep track of the following:

- The date on which the game is played.
- The final result of the match.
- The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card.
- During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place.

Each match has exactly three referees. For each referee we have an ID (unique identifier), Name, DoB, years of experience. One referee is the main referee and the other two are Assistant referee.

Task 1

Work Proposal:

Submit a work proposal for this assignment which must include:

- Understanding of deliverables - a detail description of deliverables

- General overview of task 2 - initial understanding of solution to tasks 2, 3 and 4.

The work proposal must be submitted in a word file through the link available in Moodle.

Task 2:

Discuss about the architecture of ORACLE Transaction processing Server System.

[Your research must covers Architecture of TPS, TPS in distributed system, Model of TPS Transaction Manager etc....]

Task 3:

As a database administrator perform the following tasks for the scenario given above:

i. Create separate physical structures for the new schema as per OFA guidelines [Create and rename the table space]

ii. Create a Schema with appropriate privileges.

iii. Identify the tables from above scenario and create database tables with correct relationships and constraints.

iv. Create two indexes for any two tables you created above.

v. Create two sequences and the use it for insert data into any two different tables.

Task 4:

"Information security, privacy, and protection of corporate assets and data are of critical importance to every business""

In the view of above statement choose an organization in Sultanate of Oman where customer data is critical for them and ensuring secure data transactions.

You answer should cover the following:

a) Write the introduction and business of the organization.

b) Access controls on tables, views, Synonyms or rows, Administering user privileges, roles, profiles and limitations of resources.

c) Secure External Password Store.

You are required to use appropriate literature review and use of many library resources to complete this assignment. You will achieve maximum marks for using correct Citation and CU-Harvard Referencing Style in your assignment.

Attachment:- DATABASE SYSTEMS ADMINISTRATION.rar