The toy planet database design concepts consider the skills required to perform effectively as a Database design and development employee. To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as well as the practical skills to translate that understanding into the database design and creation of complex databases.
An online toy store ToyPlanet needs to have a database designed for it to be able to cater to its customers. It has approached DataSol Ltd to develop a database for the same. Davalos did requirements gathering phase and identified the following key requirements:
You as an employee of DataSol Ltd are required to provide the design and implement the same design to produce a fully functional database system to help ToyPlanet carry out its tasks efficiently.
Learning outcome |
AC |
In this assessment you will have the opportunity to present evidence that shows you are able to: |
LO1-Understand databases and data management systems
|
1.1
|
Analyse the key issues and application of databases within organizational environments |
1.2 |
Critically evaluate the features and advantages of database management systems. |
|
LO2- Understand database design techniques |
2.1 |
Analyse a database developmental methodology |
2.2 |
Discuss entity-relationship modeling and normalization |
|
LO3 -Be able to design, create and document databases |
3.1 |
Apply the database developmental cycle to a given data set |
3.2 |
Design a fully functional database (containing at least four inter-relational tables) including user interface |
|
3.3 |
Evaluate the effectiveness of the database solution and suggest methods of improvement |
|
|
3.4 |
Provide supporting user and technical documentation |
BEN02 Planning and Presenting a Micro-Enterprise Idea BTEC Level 1/2
Read MoreBTEC Unit 35: Engineering Services Delivery Plan for Sector-Specific Organizations | HND Level 5 Assignment 2
Read MoreTQUK Level 3 Administering Medication and Monitoring Effects in Adult Care Assignment
Read MoreUnit 10: 3D Modelling and Assembly Drawing for Vice – Engineering Design Portfolio BTEC Level 3
Read MoreWhy is it important that you correlate the appropriate information of the patient when they arrive for their appointment?
Read MoreNCFE Level 3 Roles and Responsibilities in Health And Social Care
Read MoreMP3395 Turbocharger Performance Evaluation and System Analysis CW2 Assessment, AY2024-25
Read MoreKey Research Policies and Funding Models at University of Strathclyde
Read MoreCIPD Level 5 Associate Diploma Key Assessment Questions
Read MoreLaw Assignment Questions Critical Legal Analysis & Solutions
Read More