Different types of database management systems

Assignment Help Database Management System

Reference no: EM133566808 , Length: word count:3500

D/617/3036 Advanced Database Management Systems, OTHM Level 6 Diploma in Information Technology

Aim: The aim of this unit is to develop learners' knowledge and skills of advanced database systems and how these systems are managed within a business or corporate environment. Learners will be able to make informed choices between vendor and open source platforms for database management systems, and design and develop a relational DBMS for a client using an open source platform.

Learning Outcome 1: Understand different types of database management systems.

Learning Outcome 2. Be able to apply data analysis and database design techniques.

Learning Outcome 3. Be able to develop a secured and functional database to meet client and system requirements

Scenario

You have recently been appointed as database designer for MaxRos Group in London. MaxRos Group is one of UK's largest multi-player gaming platforms. MaxRos leverages their platform and technology capabilities across an extensive portfolio of businesses and brands to orchestrate the movement of people and the delivery of gaming experiences on a global scale. MaxRos Group's portfolio ticks off everything from RPG (Role-playing game) and Real-Time Strategy (RTS) through to Massively Multiplayer Online (MMO) with over 5,000 combinations to choose from.

You have joined as a senior database developer to manage MaxRos Group's growing portfolio.

Task 1 - Written Report

You line manager Emma Wilson wants to have a clear understanding of your knowledge of different types of database management systems. She has asked you to produce a written report which includes:

Instructions

a) Assess how relational database models and normalisation provide reliable and efficient databases.
b) Critically compare a range of Database Modelling languages.
c) Critically evaluate different database management systems available in relation to open source and vendor-specific platforms.

d) Apply data modelling techniques to refine logical data requirements and normalize.
e) Use a standard Unified Modelling Language (UML) notation to document
logical data requirements.

Task 2 Lab demonstration

You line manager Emma was happy with your report and decided to give you a task to produce a demo relational database for their new project, Ultimate Gamers where they build innovative digital gaming solutions to engage online gamers. You have to produce a database solution for them to manage huge volume of gamers data.

Instructions
a. Using a suitable software, design and build a database structure.
b. Demonstrate extracting data from the tables within your database.
c. Apply table and field-level security to the database.
d. Test the system for functionality and performance.
e. Evaluate security risks to the database.

Reference no: EM133566808

Questions Cloud

Why early attachment is not necessarily predictive : explain why early attachment is not necessarily predictive of your chosen relationship. Provide evidence from the literature to support your arguments.

Provide obvious starting point in screens upper left corner : Provide an obvious starting point in the screen's upper left corner. Provide adequate separation between screen elements through liberal use of white space.

What aspects of perception checking are challenging to you : What aspects of perception checking are challenging to you? What impact could improving your perception checking have on your perception of others when you do

Selection process on finding family to work : Describe your selection process on finding a family to work with for this assignment. What do you think will be challenging with this family?

Different types of database management systems : D/617/3036 Advanced Database Management Systems, OTHM Level 6 Diploma in Information Technology - Understand different types of database management systems

Explain how joint attention and intentionality relate : Explain how joint attention and intentionality relate to the ability to infer someone else's mental states?

How does implementation of telepsychiatry services : How does the implementation of telepsychiatry services compared to no access to telepsychiatry services increased access to therapy over 6 months?

What is child welfare and how has the understanding of child : What is child welfare and how has the understanding of child welfare changed over time? What kinds of supportive services are provided in child welfare?

Are there pieces of information that you did not know before : What did you learn about the video that was not mentioned in the textbook? Are there pieces of information that you did not know before ?

User Account

All Pages