Re: Student Database Design
Posted by: Josh Lee
Date: July 10, 2008 08:31PM

I can help you out here.

Table: Students
student_id (pk)
...

Table: Years
year_id (pk)
year (e.g. ff, js)

Table: OverallMarks
mark_id (pk)
student_id (fk)
year_id(fk)
mark (perhaps a fk to a table containing different marks, e.g. "Honours, High Hounours" etc.)

And then your other tables. Does this make sense?

Options: ReplyQuote


Subject
Written By
Posted
x y
February 27, 2008 06:41AM
February 29, 2008 12:38PM
Re: Student Database Design
July 10, 2008 08:31PM
February 22, 2009 09:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.