Day 1
On day 1, I and my teammates work together to create the ER diagram for the final project. At first my teammates came up with a solution for the ER diagram. But, at some point I noticed that something is missing. So, I created my own ER diagram and show it to my teammates. My ER diagram solve the problem that the first diagram have and because of that I and my teammates decided to use the ER diagram that I created.
Day 2
On day 2, I try to make the table and the attributes for the table. According to the diagram I should make 8 tables, and those tables are staff, office, taxiowner, car, driver, manager, clients, and jobs.
Day 3
On day 3, I made the query question from A to Z and implemented it on a program using Visual Basic. some of the query were tricky but I managed to do the query and answer all the question.
Day 4
On the last day, I and my teammates discussed about the things that should be improved and after that I add a little features on the program.