Relational databases
ProjectDatabase

Library Database


Library Database Tables
book
id_booknameauthorisbn
1Everything You Ever Wanted to KnowUpton082305649x
2PhotographyVilppu205711499
3Drawing Manual VilppuZelanshi1892053039
4TBAZelanshi0534613932
5Shaping SpaceSpeight0534613934
6Art Since 1940Speight0131839780
7Make it in ClayStokstad0076417011
8Art History Vol II & ala carte labStokstad205795617
9Accounting ConceptsAlbrecht1111287856
10Intermediate Accounting Stice0538479736
11Management Info SystemsMarakas9780073376813
12ManagementWilliams9780757524028
13Leadership Wisdom of JesusManz9781609940041
14Business Law TodayMiller9780324786156
15Management Info SystemsMarakas9780073376813
borrower
id_borrowerfirstnamelastnamephonestreetaddresspostalcode
1KayNaquin050-555Kotkantie 290100
2LeonardRowden050-123Uusikatu 490101
3TerryKinney050-333Isokatu 690102
4CarlaStclair041-444Torikatu 790103
5DeloresIsom041-888Tapulikuja 990104
6RalphShane040-999Tuulentie 3390100
7NormanYarborough040-222Kotkantie 290101
8ToddPastore040-555Uusikatu 6690102
9NormaWeatherspoon050-559Isokatu 7790103
10JaniceMatthew050-129Torikatu 3390104
11ThomasLarry050-339Tapulikuja 1290100
12CurtisFitzpatrick041-442Tuulentie 1190101
13LyndaStrauss041-880Isokatu 290102
14MatthewKlug040-993Uusikatu 3390103
15LarryThoma040-224Kotkantie 690104
16ArthurDowdy040-557Uusikatu 490100
17ViolaWillis042-111Isokatu 6690101
18AnnetteWilks042-222Torikatu 2490102
19HaroldBibb042-333Tapulikuja 790103
20MarvinHeflin042-444Tuulentie 490104
borrow
NOTE! The dates depends on the time when you have inserted the data
id_borrowid_bookid_borrowerborrow_datereturn_date
1162017-11-052017-11-26
2322017-11-052017-11-26
3412017-10-132017-11-03
4622017-10-232017-11-13
5822017-11-022017-11-23
610202017-11-122017-12-03
712202017-11-122017-12-03
814202017-11-162017-12-07
915202017-11-162017-12-07



Toggle Menu