Database Development Skills to a Real World - IT Assignment Help

Assignment Task:

Task:

Database Modelling & Design
Your task for this assignment is to design a database.
This assignment requires you to apply your knowledge of conceptual database design, logical database design, and table implementation in the SQL Server.

Objective: apply your database development skills to a real world application to get a database for the application.

Requirements Definition of the Application
Welcome Adventurer, this extremely well thought out document contains all the pieces of the puzzle you will need to create a relational database for a new online adventure game. The game is massive in size, so your task will be scaled down in content. You are tasked with creating a functional database for a few main features of the game. These are the core components that will objects in the game to interact with each other. I hope you aren’t feeling overwhelmed yet because the fun hasn’t even started.

Creatures: In our game there are two main types of creatures: player characters and non-playable characters (NPCs). Each of these has a race, gender, and a combat level. What makes each unique are a few attributes, players have usernames, quest points, prayer points and an energy level. Because the game will be free to play, there are different account types that a player character can have, some being a paid subscription while others are free loaders (playing our game for free, costing us money – disgusting). NPCs however only have attack and defence statistics as well as a way of finding out whether they are attackable characters or not. This will allow our game engine to determine whether a player can kill them or not. NPCs can drop items when they die, see items below for more details on them, these drops have a pre-set percentage and quantity of that item dropped.

Items: No adventure game would be complete without some form of accessories that a player can use. These will be known in our game as items. All items have similar attributes however, some can be worn as an item of clothing, which have a certain armour slot they can be placed into. Items do share similarities though, regardless of what slot they can go into, they have a selling price, weight and whether they can be stacked in a single item slot or not. What an item slot you may ask? Please refer to the Inventory and Banking section below. When it comes to putting items into slots however, they are only able to equip 11 onto their character. Why may you ask?

Design Requirements
In order to achieve the desired level of flexibility in data collection, the design will be expected to accommodate the following features:

1. Draw a traditional UML diagram i.e. ER diagram for the application to show entity classes and relationships, indicate CKs and multiplicities whenever appropriate. This diagram is critical and if it does not capture all the requirements and constraints of the application, the final database designed will not be complete.
2. Convert the UML Class Diagram i.e. ER diagram into a relational database schema; primary keys and foreign keys have to be clearly identified.
3. Create these tables in the SQL Server. Make sure that the constraints obtained from Step (2) are all implemented.

This  IT  Assignment has been solved by our IT  experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.