Compare and contrast the different types of database models such as ER, relational, hierarchical, network, OO: Database Management Systems Assignment, ICL, UK

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.

Task 1:

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.
2. Assess how relational database models and the process of normalization can provide reliable and efficient data structures.

Task 2:

1. 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?
2. Create your DBMS using MySQL and a front-end application. Ensure you implement effective features to handle concurrency, security, user authorizations, and data recovery.
3. Test the system for functionality and performance.
4. Critically evaluate the effectiveness of the design and development against client and system requirements.

Task 3:

1. Demonstrate the tools available in the system to monitor and optimize system performance, and examine the audit logs.
2. Demonstrate the tools available in the system to manage security and authorizations.
3. Assess the effectiveness of the system administration and management tools available on the platform identifying any shortcomings of the tools.

Answer

Request Answer of this Assignment