Different types of database management systems

Assignment Help Database Management System

Reference no: EM133106265 , Length: word count:2500

Advanced Database Management Systems - OTHM Level 6 Diploma in Information Technology

Reference Number - D/617/3036

Unit Level - 6

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.

Case 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 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.

Attachment:- Advanced Database Management Systems.rar

Reference no: EM133106265

Questions Cloud

Legal constraints hr professionals : A number of businesses are now relying solely on data to make hiring decisions. What are some of the legal constraints HR professionals may be faced with by doi

What are some strengths and weaknesses of data : What are some strengths and weaknesses of data, findings, and current research on leadership, diversity and equity?

Develop a competitive advantage against its rivals : How could the four generic building blocks of competitive advantage (efficiency, quality, innovation, and responsiveness to customers) in Apple Inc. be used to

Effective performance appraisal system : Describe the elements and characteristics of an effective performance appraisal system.

Different types of database management systems : Understand different types of database management systems and apply data analysis and database design techniques

Definition of organized crime : Provide a definition of organized crime. discuss some examples of organized crime activities. Provide a summary for each case involving RICO that you found.

What other technique might work as well to select candidate : To work in diversity workforce, the scorecard before hiring an applicant can be the best way to interview a candidate.

Companies leadership development program : You are a candidate for an extended international assignment as part of your companies leadership development program. What types of support programs would you

Review the webinar from the score website : Please review the webinar from the SCORE website: HR 101 The Top HR Issues Business Owners Face - and How to Solve Them

User Account

All Pages