Database Systems and Design Tools and Development

Assignment Task

Scenario

IMPULSE Academy College holds an inter college sports fest called Summer Games in the end of semester comprising of numerous activities ranging from table/card games such as monopoly to hard physical field games such as basketball. Students will be able to show interest and participate in any activity of their choice.

The total number of events during the summer games is 5 namely Monopoly, Foosball, Basketball, Cricket and Badminton. Each event comprises of different number of participants depending upon the game. Records will be kept for each registered player including their names, age, school/college and place, participating events/activities, their achievements in such events and awards given. Records will also be kept for each event, participating registered players, participants' scores/activities to identify winners and present awards, and criteria/rules for participation.

The summer game requires a design of a database with the above specifications indicating necessary keys and relationships. 

Database design and design tools for a given problem.

1. Design a relational database system using appropriate design tools and techniques containing at least four interrelated tables, with clear statements of user and system requirements.

2. Produce a comprehensive design for a fully functional system which includes interface and output designs, data validations and data normalizations.

3. Evaluate the effectiveness of the design in relation to user and system requirements.  

Scenario

After the completion of the database design, you are asked to develop a relational database based on the existing user requirements. While designing, you have to take measures to ensure the security of the system as well.

Developing a fully functional relational database system.

1. Develop the database system with evidence of user interface, output and data validations and querying across multiple tables.

2. Implement a query language into the relational database system.

3. Implement a fully functional database system which includes system security and database maintenance.

4. Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information.

5. Evaluate the effectiveness of the database solution in relation to user and system requirements and suggest improvements.

Scenario

The relational database that you have designed is ready to be used. The contestants can now successfully enter their information and store their details in the database. After the successful entry of all the details, you have to test the system to make sure that all the user requirements are being satisfied and that the system is safe and secure for the future use.

Testing the systems against requirements.

1. Test the system against user and system requirements

2. Assess the effectiveness of the testing including an explanation of the choice of test data used.

Scenario

The system that you have designed is tested successfully. The college wants to keep the system for future use. The final assignment given to you is to document the entire designing process including technical documentation and user documentation. You have been asked to include diagrams to show the movement of data as well.

Technical and user documentation.

1. Produce technical and user documentation.

2. Produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system and flowcharts describing how the system works.

3. Evaluate the database in terms of improvements needed to ensure the continued effectiveness of the system

This IT Computer Science has been solved by our PhD Experts at My Uni Paper.