Critically compare a range of database modelling languages

Assignment Help Database Management System

Reference no: EM133605108

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 infomied 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 platfomi.

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 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 Garners 'where they build innovative digital gaming solutions to engage online garners. You have to produce a database solution for them to manage huge volume of garners 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: EM133605108

Questions Cloud

What is the reorder point and how many should be ordered : What is the reorder point? 2. How many should be ordered? They are open 365 days a year. The standard deviation is 5 cans per day. Order cost is $10 and holding

Diabetes and incident coronary heart disease : Gender may be an effect modifier in the relationship between diabetes and incident coronary heart disease.

Design process can use a great deal of natural resources : Design is important to sustainability because: The design process can use a great deal of natural resources and generate much waste through prototyping.

Severe dehydration secondary to diarrhea : The nurse is caring for a 57-year-old female who was admitted three days ago for severe dehydration secondary to diarrhea.

Critically compare a range of database modelling languages : Critically compare a range of Database Modelling languages and Critically evaluate different database management systems available in relation to open source

Inequities related to homelessness : Think about the inequities and identify the causative factors that lead to inequities, including the social determinants of health.

Discuss with patient facing life-threatening illness : List five issues that are appropriate to discuss with a patient facing a life-threatening illness.

What intrapartal complication is amal experiencing : She has a history of one uncomplicated vaginal delivery with her first pregnancy. What intrapartal complication is Amal experiencing?

Negative consequences on topic violence prevention : Discuss 5 negative consequences on the topic 'Violence Prevention'. must use a minimum of four references within five years to include a nursing journal article

User Account

All Pages