By Hanssen Hilman(2001586256) and Benny Victor(2001585316) Course: Database Systems

Overview:

The goal of the final project is to make a database program based on case study given by the lecturer. The case study implies that a private taxi company “FastCabs” in Scotland needs a solution for their database problem as their communication and information sharing is poor. The director of the company asks “us” programmers to create a database program as a solution.

Preparation:

First, my team planned using ER diagram, we used normalization for separating and creating tables. 10 tables are created as the result of normalization, and the ER diagram is as follows:

Creating database:

my team uses MySql as database. We created 10 tables according to the ER diagram and fill them with test data. We established relationships between tables as references.

Creating program:

The program is created using Visual Studio and it is in form of VB.net Windows Application Form. The requirement states that the program must use menu for their tables and the required queries. As addition, we included buttons for the tables, inserting data and sorting data.