I have two tables, student and teacher. I have an email table because a student can have more than one email. But, so can a teacher. Should I include a foreign key of both student and teacher in my email table or create two separate tables, that is, a student_email table and a teacher_email table? Is there any difference which of these I do? Is there a more elegant solution?
dubiousandrew
0
Newbie Poster
Recommended Answers
Jump to PostThe main goal in designing a database is designing a database that works for your purpose. There are many situations where it is possible to make a database more properly normalized, but it may take too much time, money and effort to justify. For example, in a properly normalized database, …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.