Student Grading System Implementation : Data Analysis Assignment

Internal Code:  IAH144 (U)

Student Grading System Implementation

scenario A pdf report detailing your work including (but not limited to):

• Explanations of your database design choices, and screenshots of your database structure and data
• Descriptions of user privileges (using access matrix) with explanations, and screenshots of the SQL commands you used
• Descriptions of your SQL injection test (in steps) with screenshots and explanations of your observations
• Descriptions of your backup strategies with clear justifications
• An ER diagram (pdf) for the database design
• An SQL script including all the commands for database implementation, user creation, and privilege granting

Question: 1. Which portions of the database should be backed up, and how often? 2. For each portion that is backed up, how many backups should be retained before the newest backup overwrites the oldest?