Information and Security Management IT Assignment Help

Assignment Task

PART A. Database Implementation
1. Database Design
Design the database using the ERD and sample data provided in the Appendix as a starting point. Note that the sample data do not reflect the final design.The sample data do not reflect the table structure in the database, and you will need to revise the structure of the tables based on the ERD. You need to describe and explain your design choices.The sample data are not complete either. For example, they do not describe the teaching and managing relationships: academic staff teach courses and admin staff manage courses and enrolments. You need to create those data if required.
2. SQL Implementation
Create the tables and insert the data using a SQL script, including proper datatypes and integrity constraints. The data must include but not limited to the sample data provided in the Appendix.
3. Database Backup
Suppose frequent backup of the whole database is expensive, which tables of the database should be backed up more frequently than others? Implement the backup and recovery using mysqldump (for the whole database and for those tables requiring more frequent backup). Describe how you made the backup and recovery.

This IT Assignment has been solved by our IT Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
    
Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.