Search results

Could someone please check the relationships between these entities? I think I've forgot to include a primary key in the reservations table. I think the primary key should be guest ID. Also, do I need a composite key? Thanks

Hi How do I automatically copy data from one table to another? I have a table with player information and want to put the membership number into the fixture table automatically to avoid entering all the player ID numbers again.

Hi Would fixtures for a sports league be a feasable database? I could have table players, table league fixtures, table game scores and then make a report of results/performance including outstanding matches. Does this sound workable or is it better done in Excel? Thanks

Hi I'm trying to design a database for a sports league, but am having difficulty working out how i would keep weekly data and archive it in some way in order to input the following week's data. Any help appreciated.