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.

Consumer Rights Assignment Help

Financial Reporting Assignment Help

Award in Education and Training (A.E.T.) Level 3 Pearson BETC Qualification

Administrative Systems Assignment Help

Understanding Specific Need in HSC Assignment Help

Leading and Managing People Assignment Help

Building Management Systems Assignment Help

Discuss the environmental and sustainability factors

Data Analysis and Design Assignment Help

Business Decision Making Assignment Help

Research Methods for Strategic Managers Assignment Help

Analyze the sustainable supply chain management

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