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_personworkhour
1101201300
2102201300
3101202200
4104202300
5101203200
6102203400
7103203200
8104203200
9101204100
10101205100
11104205400
12101206400



Toggle Menu