Relational databases
ProjectDatabase

Project Database


Project Database Tables
person
id_personfirstnamelastnamecitybirthyearsalary
201JimMorrisonTURKU198544
202JimSmithTURKU198839
203LiisaRiverHELSINKI199139
204AnnJonesTURKU197944
205LisaSimpsonHELSINKI198536
206MattDanielsTAMPERE199134
project
id_projectpnameplace
101BookkeepingTURKU
102BillingHELSINKI
103StoreHELSINKI
104SellingTURKU
105CustomersKUOPIO
106Statistics
hour
id_hourid_projectid_personwork_hour
1101201300
2101202200
3101203200
4101204100
5101205100
6101206400
7102201300
8102203400
9103203200
10104202300
11104203200
12104205400



Toggle Menu