COMP283 - Applied Database Management. 2017-18
Welcome to the homepage of COMP283.
The following materials are available:
Lecture Notes:
Lecture 1 - Intro
[
audio
]
Lecture 2 - DB Files and data types
[
audio
]
Lecture 3 - DB Storage (Disk types & RAID)
[
video
]
Lecture 4 - Authentication, Authorisation, Accounts and SQL Injection
[
video
]
Lecture 5 - Optimisation and Normalisation
[
Audio
]
Lecture 6 - Optimisation Data Integrity and Performance
[see lecture 5 for audio]
Lecture 7 - Server Maintenance, Redundancy & Mitigation
[
audio
]
Lecture 8 - High Availability, Redundancy & Distribution
[see lecture 7 for 1st part audio] [
2nd part audio
]
Lecture 9 - DB Linking & Migration
[see lecture 8 for audio]
Practical Sessions:
Week 1, No Practical Class
Week 2, Practical 1. Intro to MySQL Workbench
Week 3, Practical 2. MySQL Workbench vs mysql Command Line
Assignments:
General Preamble about Assignments
Assignment 1
(deadline Friday 9th March 12:30pm)
Assignment 2
(**updated deadline Wednesday 25th April 5:00pm**). Video presentations links to me at the same time please.
Assignment 3
(deadline Thursday 10th May 5:00pm). Video presentation links to me at the same time please.
Forms and Source Documents:
Peer Assessment and individual report form
(each team member should fill out and submit one of these per assignment).
Scenario 1 - The Cinema
Scenario 2 - The Cafe
Scenario 3 - The Volunteer Organisation
Scenario 4 - The Social Network
Scenario 5 - The Car Hire Company
Scenario 1 part 2 - The Cinema
Scenario 2 part 2 - The Cafe
Scenario 3 part 2 - The Volunteer Organisation
Scenario 4 part 2 - The Social Network
Scenario 5 part 2 - The Car Hire Company