
September 5th, 2005, 06:02 AM
|
|
Registered User
|
|
Join Date: Sep 2005
Posts: 13
Time spent in forums: 3 h 25 m 5 sec
Reputation Power: 0
|
|
|
Access 2002, Normalisation Relationship
Hi Guys,
Im creating a relational database for a weekend school to help out with the administration side of things. Initially, they wanted a simple spreadsheet database with the students, teachers etc, but i convinced them to have a proper relational database.
I am not an expert with databases (just have basic knowledge) but I have normalised the data to the best of my understanding, thus I have the following tables:
*Student (StudentID, First Name, Last Name, Address etc)
*Grade (StudentID, ClassID, Grade)
*Class (ClassID, Subject, Notes)
*Teacher (TeacherID, ClassID, First Name, Phone etc)
Does this structure look okay and will this structure be okay when they start populating with data? Also, how can I produce a user friendly webpage that will let the administrator enter data, and view the data\quries etc?
I know a bit of php, and asp. Your help and advice will e greatly appreciated....
Many Thanks,
|