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.

Level 7 Diploma in Strategic Management and Leadership (QCF)

Advanced Diploma of Business Assignment Help

Management Accounting Assignment Help

Undergraduate Course

Examine the health, care and support services

Engineering Project Assignment Help

Biological Molecules and Metabolic Pathways Assignment Help

Examine appropriate research methodologies and approaches

BTEC Level 2 Extended Certificate in Health and Social Care

Internet Server Management Assignment Help - Level 5 BTEC HND in Computing and Systems Development

Leadership and Management in International Business

Human Resource Management Decision-Making Assignment Help

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