Assignment 4

Week 2 grade and advice from instructor: Grade: 144 / 180

Thomas,

I'm looking over your database - it isn't very optimized and has a lot of redundancy. For instance, why have a Late id and an Id - you can use the Id as the primary key - then it is linked to another table when it is used as a reference key.

You can also do the same thing with the admin table - it would be adminID is the primary key and Id is a reference key linking to whichever employee has risen to the ranks.

That way it is a simple process to upgrade or downgrade anyone's privileges by simply adding or deleting them from the admin table only instead of trying to trace back to which employee it is without any links.

Also, as an aside, what would your employer think about RFID tags to clock in and out - with RFID scanners that identify when an employee leaves the building and enters? Just a thought.

Sincerely,

Dee Dee Rich

Dee Dee Rich, Jul 17 at 8:46am

Weeks 3 grade and instructors advice Grade: 224 / 280

Thomas,

Have you thought about the possibility of using your database and web front end - to locate where the individual is at when they clock out and deduct either when they were supposed to clock out (if it has been several hours) or the travel time taken to get there.

That might alleviate some of the problems they have been having.

I have to say, I am not seeing how the database and web site correlate in the paper. Or how your solution fixes their problem. Can you elaborate in the final paper for week 4 please? Also please don't fill your paper up with any more processes on how to find a solution - I want to know how and why your solution is superior and solves their issue. I know you can do it!

Sincerely,

Dee Dee Rich

Dee Dee Rich , Jul 17 at 10:30am