Advanced Database Management Systems

Advanced Database Management
Systems

Table of Contents
Introduction......................................................................................................................................1
LO 1.................................................................................................................................................1
1.1 Evaluate ways in which RDBMS & normalisation renders efficient as well as reliable
databases.................................................................................................................................1
1.2. Compare different database modelling languages...........................................................3
1.3. Evaluation of various DBMS with respect to open source & vendor specific platforms.4
LO2..................................................................................................................................................5
2.1. Apply data modelling techniques for refining logical data requirements along with
normalisation..........................................................................................................................5
2.2 Usage of UML notation for documentation of logical data needs...................................8
LO3..................................................................................................................................................9
3.1 Design as well as building of database structure..............................................................9
3.2 Extraction of data from tables........................................................................................11
3.3 Apply table & field-level security to database...............................................................11
3.4 Testing of a system for functionality as well as performance........................................12
3.5 Evaluation of security risks to database.........................................................................12
Conclusion.....................................................................................................................................13
References......................................................................................................................................14

Introduction
Database denotes the aggregation of related data which illustrates crucial aspects related
with real world scenario. Basically, it involves generic data for end-user in a defined as well as
global view. Database is utilised by firms for storage, management as well as retrieval of
information (Aponso and et. Al, 2017). This serves as a interface among application programs or
end users and database for ensuring that data is being organised consistently and can be accessed
whenever it is being required by individuals. It is responsible for providing programmers as well
as users with an systematic method for creation, retrieval, updation and management of data. The
advance database management system involves stream processing systems, advanced analytics
along with memory data processing (Bradford, 2015).
This report is based on MaxRos Group within London and it deals within multi-player
gaming platforms. They render their technologies as well as platform capabilities around
extended portfolio of brands as well as businesses for delivering gaming experiences within a
global scale. They render their customers with real time strategies and role playing games
through MMO (Massively multiplayer online). A report has been prepared for Emma Wilson

within task 1 that contains ways in which database models & normalisation renders efficient and
reliable databases along with comparison in between database modelling languages and DBMS
available with respect to open source as well as vendor specific platforms. This also comprises of
data modelling techniques for refining logical data needs and normalise along with this UML is
being utilised for their documentation.
LO 1
1.1 Evaluate ways in which RDBMS & normalisation renders efficient as well as reliable
databases.
The aggregation of programs along with capabilities which enables IT teams and others
for creation, update, administration as well as interaction with database is referred to relational
database management system. This utilises structure which allows identification as well as
accessing data with respect to other piece of data that is being organised in tables (Connolly and
Begg, 2015). It comprises of database that is liable for storing data within structured format
through the usage of rows & columns. For having accurate as well as efficient transactions
within RDBMS ACID can be utilised. Transactions denotes a smaller unit of program which
comprises of low levels of tasks. It has been mentioned below:
 Atomicity: This denotes that entire transaction occurs at same time or it do not takes
place at all. There is no partial transaction, it is executed towards its completion or do
not occurs. For this, two operations exist, they are, abort (alterations cannot be seen
within a database) and commit (modifications can be seen).
 Consistency: It denotes that constraints related with integrity must be maintained before
as well as after transaction takes place. This denotes that if database is in consistent state
before transactions have been carried out then even after it the state will remain same
(Coronel and Morris, 2016).
 Isolation: It ensures that MaxRos Group can have various transactions simultaneously
without any kind of inconsistencies which prevails within state of database. Transactions
must take place independently without any kind of interventions. Alterations which will
take place should not be seen by others until it occurs in the memory. Basically,
transactions will be carried out in such a way that it looks like it is only transaction
which is taking place.