- NCFE CACHE Level 3: Safeguarding and protection, children and young people in residential care and supporting children: Safeguarding, Assignment, UK
- 5HR03: focuses on how internal and external business factors influence reward strategies and policies, the financial drivers of the organisation: Reward for performance and contribution, CIPD level 7, UK
- LAW4007: English Legal System and Skills, Assignment, AU, UK
- 2021 saw the continuation of a decade of growth in the UK organic market. What’s the future of organic food in the UK? Use specific reasons and examples to support your answer, Assignment UK
- Level 6 NVQ: Promote a Positive Health and Safety Culture: Diploma in Occupational Health and Safety Practice, Assignment, UK
- EEE6015: Power World Simulation- Power Flow Analysis- Power Systems and Smart Grids, Assignment, UOB, UK
- SFM202407- Strategic Financial Management, Assignment, OTHM Level 7, EBIC, UK
- 3CO01: Business, culture and change in context, Assignment, CIPD Level 3, UK
- Academic Study Skills, S1. Individual Report, UK
- HSC Level 3 Unit 1 – Structure and Overview of the Health and Social Care Sector, Assignment, UK
- Qualifi Level 5 Business Models and Growing Organisations, Assignment, UK
- CIPD Level 3 3CO03: Core behaviours for people professionals, Assignment 1, UK
- Civil CEP: Numerical Analysis, Assignment, UOB, UK
- UNIT CMI 321: Managing Own Personal and Professional Development, Assignment, UK
- UNIT CMI 304: Channels and types of communication used in the workplace: Principles of Communication in the Workplace, Assignment, UK
- Features Of Partnership Working In Health And Social Care, Assignment, UP, UK
- OTHM level 3: Person-centred Approaches in Health and Social Care Settings: foundation Diploma in Health and Social Care, Assignment, LCPS, UK
- OTHM level 3: Health, Safety and Wellbeing in Health and Social Care Settings: foundation Diploma in Health and Social Care, Assignment, LCPS, UK
- OTHM level 3: Effective Handling of Information in Health and Social Care Settings: foundation Diploma in Health and Social Care, Assignment, LCPS, UK
- OTHM level 3: Effective Communication in Health and Social Care Practice: foundation Diploma in Health and Social Care, Assignment, LCPS, UK
Unit 04: Centralized Database for MadZoo Digital-MadZoo Digital is a start-up company which was established in 2020: Database Design & Development, Assignment, BTEC Level 5, UK
Subject | BTEC Level 5 Unit 04 Database Design & Development |
General Guidelines
- A cover page or title page should be attached to your assignment. Use page 1 of this assignment brief as your cover page and make sure all details are accurately filled.
- The entire assignment brief should be attached as the first section of your assignment.
- The assignment should be prepared using a word processing software.
- The assignment should be word processing in an A4 sized paper.
- Allow 1” margin on top, bottom and right sides of the paper and 1.25” on the left side (for binding).
INTRODUCTION:
MadZoo Digital is a start-up company which was established in 2020. They operate on varieties of software developments & network solutions. The company’s vision is to transform ideas into experiences and help brands reach aspirational & affluent audiences through data, creative & technology. The company is expanding their business since rate of requirements are high. They have planned to establish new departments for the company such as Research & Development, Project management office, Information Security, Customer Service & etc.
TASK GUIDANCE:
An entertainment tournament hosted by MadZoo Digital introduces football matches. Every employee is welcome to participate if they are willing.
You have been assigned as a Back end developer to centralise the tournament data and keep track of soccer teams, the games they play, and the Players in each team. In the design, we want to capture the following:
- We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs.
- Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DOB, start year, and shirt number that he uses.
- Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team.
- For each match we need to keep track of the following:
- The date on which the game is played
- The final result of the match
- The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card.
- During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place.
- Each match has exactly three referees. For each referee we have an ID (unique identifier), name, DOB, years of experience. One referee is the main referee and the other two are assistant referee.
The following competition requires a design of a database with the above specifications indicating necessary keys and relationships.
TASK 1:
An Entity Relationship Diagram needs to be drawn for the entities along with their attributes for the above given scenario.
It is important to show the different components of the case study data that illustrates the logical structure of the tables that makes up the database. In this view, you are required to illustrate the data structures and relationship of the tables extracted by designing the Entity Relational Diagram. Your implementation should illustrate at least four (4) inter-related tables resolving “many to many” relationships if there are any. It is necessary to explain any assumptions made for the user and system requirements.
From the tables extracted, ensure to list all the attributes. The aim of normalization is to reduce duplications. You are to produce a well normalized database up the third Normal Form following your listing specifically identifying the primary and foreign keys. The effectiveness of database design is usually assessed through testing. Assess your database design in relation to the user and system requirements.
Buy Answer of This Assessment & Raise Your Grades
TASK 2:
After a successful database design, the next step is to develop the database using the structured query language. Using your design as a guide, develop your database by all the tables using Structured Query Language with necessary attributes and declare primary and foreign keys where necessary. Ensure your implementation is justified to meet user requirements. The tables created must be populated with records of at least five (5) entries for each table to enhance querying your database.
There are different tools or applications or platforms that helps in developing and querying the database e.g. Ms SQL Server. You are required to use Ms SQL Server to demonstrate the extraction of meaningful data through the implementation of query languages and also you are required to design Interfaces through an IDE in order to provide evidence.
To justify the use of SQL, it is important to include screenshots of the SQL and the query outcome. To enhance your understanding, ensure to evaluate each of the queries in answering the transactions. These transactions are itemized as below:
- a) List all the available match details in the competition.
- b) List all the players’ names, DOB, Shirt number and Start year.
- c) List all the events that participant Neymar Jr is registered for in ascending order by date.
- d) Update a referee’s experience from 1 year to 3 years
Note that it is mandatory to provide the SQL statement and show the output from the query in the form of screenshots.
Due to the data-specific nature of databases, it is important that they are secured and maintained. To reflect your understanding of database security and maintenance, you are required to assess the effectiveness of how these are ensured in your implementation of the fully functional database system in accordance with users and system’s requirements.
Do You Need Assignment of This Question
TASK 3:
It is necessary to test database and in the process of successfully carrying out testing, a test plan suffice. In your report, outline how the system has been tested against users and system’s requirements. This test plan preferably to be in a table format illustrating at least six (6) records tested. Ensure to have “Test Description”, “Expected Outcome”, “Actual Outcome” as headings. The “Actual Outcome” heading should include a visual representation such as screenshots of results and annotations.
From the test plan created, you are to explain the different database testing techniques and assess with evidence, one of the testing techniques implemented on your database development. In your report, include recommendations on how you can improve your database development.
TASK 4:
Documentation helps in understanding the concept of database development. To reflect your understanding of technical and user documentation, you are required to produce a fully technical and user documentation for your designed database for the college. Your documentation should include DFD diagram showing movement of data through the system, and flowcharts describing how the system works.
Enhancing database development is paramount in completing the development cycle. You are required to assess any future improvements that may be required to ensure the continued effectiveness of the database system.
Unit Learning Outcomes
LO1 Use an appropriate design tool to design a relational database system for a substantial problem
LO2 Develop a fully functional relational database system, based on an existing system design
LO3 Test the system against user and system requirements
LO4 Produce technical and user documentation
Are You Looking for Answer of This Assignment or Essay
Unlock top grades with our online assignment writing help for BTEC Level 5 Unit 04: Database Design & Development. We deliver customized BTEC Level 5 assignment answers for UK students, covering all aspects of database design and development. Need expert BTEC Assignment support? Pay our professionals to boost your performance and succeed in your course with ease!