Unit 33 Data Analysis and Design

Unit 33 Data Analysis and Design

TASK 3: Be able to use manipulation and querying tools

3.1- Explain the benefits of using manipulation and query tools in a relational database system.

3.2 – Produce, document, demonstrate  following SQL Queries:

List the managers of each team.

Output the full name of the top scorer in the league with the number of goals scored.

Output the average number of goals per game of all games played.

List all of the games that were played in a particular ‘city’.

List all players who have played a game that was refereed by a particular referee (choose any referee).

Create a database viewfor your system to produce a list of fixtures yet to be played along with the date of each game.

3.3 - Critically evaluate the validity of the data extracted using the above queries and comment on the design process followed to ensure that meaningful data is extracted through the use of query tools.

TASK 4: Be able to test and document relational database systems

4.1 - Critically review and test the relational database system designed for the given scenario and thus provide a documentation to support the implementation and testing of the relational database system developed.

4.2 - Create brief user documentation for the relational database system developed.

4.3 - By giving a tabular V&V document, explain how verification and validation has been addressed.

4.4 - Explain control mechanisms and show how these techniques have been used in developing your system.

Games Design Theory Assignment Help

Business Law Assignment Help

Computer Programing Assignment Help

Applied Science and Technology - BTEC Level 1

Legislative Analysis - Identify proposed bills that effect business, industry or commerce

Art & Design BTEC Level 3

Pearson BTEC Diploma in Management and Leadership - Level 4

Operations and Project Management Assignment Help

Set Up A Small Business From An Entrepreneurial Mind-Set Assignment Help

Level 3 Certificate in Teaching Assistant - Wellbeing of Children and Young People

Unit 35 - Further Analytical Methods - J/601/1465, QCF Level 5

Games Development Assignment Help

Want to Excel in Course? Hire Trusted Writers for Help! —> https://miracleskills.com/