Database design for a school' sports day

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 397,599 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,773 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser:

Database design for a school' sports day

•

Join Date: Mar 2008

Posts: 7

Reputation: Neke is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Neke

Offline

Newbie Poster

Database design for a school' sports day

Mar 27th, 2008

Hello all,
I'm new in this group and with designing databases. I would like to design a databse for managing data about the sports day for a school.

I have been able to create the following tables: Pupil(differnt class and age group), Event(hockey, rugby, swimming,relay race), Staff, Equipment(used for the event).
I don't know if i have the ritght classes for the tables and could you kindly tell me how my ER/EER model would be used to answer some of their needs like drawing up with a list of events and start time, count all events participated by each group.
Thanks.