Database Implementation - SQL Implementation - Database Backup - Engineering Assignment Help

Assignment Task :

PART A. Database Implementation

1. Database Design 
Design the database using the 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. 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 with the commands you used.

 
PART B. Users and Privileges 
1. Create Users 
Create a sufficient number of users to demonstrate different sets of privileges. A ‘set’ of privileges (or views) are similar privileges (or views) applied to multiple users. For each set of privileges (or views), you need to demonstrate the SQL implementation for at least one user to whom the privileges apply.

2. Assign Table-level Privileges 
Assign at least 5 sets of privileges to the users, including the provided 3 sets below. For each set of privileges that you propose, you must explain what the privileges are: which group of users need to have what access to which (parts of) tables. Here are 3 sets of privileges as examples, which you need to include in your implementation:

• Admin staff managing enrollment can modify only enrollment information, and admin staff managing courses can modify only course information
• Both academic staff and students can see information about courses, but students cannot edit it.
• Academic staff can see the names and genders of the students but not their private information like birthdays or phone numbers.

3. Create Views and Related Privileges 

Create at least 5 sets of views with at least 2 sets involving joins of two or more tables. For each set of views, explain why and how you implement the views. Assign the views to appropriate users. Here are some 3 sets of views as examples, which you need to include in your implementation:

• Students should only see the grades that belong to themselves (and read only). 
• Academic staff can only see the enrolment of the courses they teach. 
• Academic staff can only modify grades of the course they teach.

This Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. 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.