Tameside Theme Park (TTP) is a theme park opening in Ashton that has been successful since it opened. You have been approached to design and develop the hotel booking system. You must design a sound database system using MySQL with a suitable interface that contains no errors using relevant tools and techniques.Strategic Leadership Assignment
Task 1:
- Compare and contrast the different types of database models such as ER, relational, hierarchical, network, OO, and object-relational. Critically evaluate different DBMS available in relation to open source and vendor-specific platforms, justifying the criteria used in the evaluation.
- Assess how relational database models and the process of normalization can provide reliable and efficient data structures.
Task 2:
- Produce a requirements specification for the theme park booking system. Based on the specification, create design documentation for the DBMS and the user interface. How will the design optimize system performance?
- Create your DBMS using MySQL and a front-end application. Ensure you implement effective features to handle concurrency, security, user authorizations, and data recovery.
- Test the system for functionality and performance.
- Critically evaluate the effectiveness of the design and development against client and system requirements.
Task 3:
- Demonstrate the tools available in the system to monitor and optimize system performance, and examine the audit logs.
- Demonstrate the tools available in the system to manage security and authorizations.
- Assess the effectiveness of the system administration and management tools available on the platform identifying any shortcomings of the tools.