Advanced Database Management Systems Assessment
- Country :
Australia
Unit Aims
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.
Scenario
You have recently been appointed as database designer for MaxRos Group in London. MaxRos Group is one of UKs 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 Groups 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 Groups growing portfolio.
Task 1 of 2 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
- Assess how relational database models and normalisation provide reliable and efficient databases.
- Critically compare a range of Database Modelling languages.
- Critically evaluate different database management systems available in relation to open source and vendor-specific platforms.
(LO1, AC1.1, 1.2, 1.3) - Apply data modelling techniques to refine logical data requirements and normalize.
- Use a standard Unified Modelling Language (UML) notation to document logical data requirements.
(LO2, AC 2.1, 2.2)
Task 2 of 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
- Using a suitable software, design and build a database structure.
- Demonstrate extracting data from the tables within your database.
- Apply table and field-level security to the database.
- Test the system for functionality and performance.
- Evaluate security risks to the database.
(LO3, AC3.1, 3.2, 3.3, 3.4, 3.5)
Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.
Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.
To connect with expert and ask your query click here Exam Question Bank
