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 includes everything from RPG (Role-playing game), 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 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 in which you:
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.
Delivery and Submission
● 1x Word file (circa 2500 words excluding TOC, diagrams, references and appendices)
Task 2 of 2 Lab demonstration
You line manager Emma was happy with your report and decided to give you a task to produceNa 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.
Delivery and submission
● 5x Lab demonstration files
● Your Lab instructor will sign FIVE witness statements for each of the 5 activities above outlining whether each one was successfully demonstrated.
● Design documents are needed be submitted as well. *
* Additional files such as pictures during demonstration, video clips on demonstration can be provided on the centre’s discretion.
Unlock Answer