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 |
MPOM7103 Assignment: Strategic Decision-Making and Operational Resilience in Petronas Amid Energy Transition
Read MoreMPIB7103 Assignment: Critical Perspectives on International Business Strategies and Regional Integration
Read MoreMPHR7113 Assignment: Strategic HR Analysis of Golden Heritage Café (HRM)
Read MoreTHEA1013 assignment: Theatrical Storytelling: Exploring the Unique Power of the Stage
Read MoreBusiness Strategy Assignment: Strategic Expansion: A Business Outlook
Read MoreGSGM7324 Assignment: Organisational Development and Change Management
Read MorePHY098 LOD 2, C4 Assignment: Mitigating Damage to Electrical Appliances from Lightning Strikes
Read MoreBM070 Business Research Assignment: Business Report Framework for Corporate Development
Read MoreHBET1203 Assignment: Comparing Pronunciation of Selected Words in Text and Reading to Standard British English
Read MoreIdentify key technological challenges affecting e-invoicing adoption in Malaysia.
Read More