Unit 33 Data Analysis and Design

Unit 33 Data Analysis and Design Assignment Help - Hire UK based Tutors and Get Best Unit 33 Data Analysis and Design Assignment Help and UK Assessment Writng Service!
Previous << >> Next

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.

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

Lists of comments

Leave a comment