Newbie - Need help with database design
Posted by:
Will Smith
Date: October 31, 2004 02:48PM
I'm new to database design. Hope someone may able to help me.
I'm try to design a database where students can take class, and teachers teach classes. The tables are: users, enroll ( to connect users table and class table), class, course, and roles (to determine the privilege of the user whether is a student or teacher).
Because of the security reason, I would like to seperate the Roles from within the Users table, but then I run into trouble when designing the "roles" table.
Users table: User_ID (PK), User_Name, etc...
Roles table: User_ID (PK), Roles_Teacher, Role_Student
1st question: How can I link these two tables together?
2nd question: Is it better to seperate students into Students table and teachers into Teachers table, or just put all of them into Users table to simplify the design?
Thank you very much for any help,
Subject
Written By
Posted
Newbie - Need help with database design
October 31, 2004 02:48PM
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.