Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

Designing MySQL database

Course Queries Syllabus Queries

Max. 2000 characters
Replies

usr_profile.png

User

( 4 months ago )

I have three tables,

student, studentclass , class

student have sid as primary key, class have cid as primary key.

studentclass ties student and class together and has two columns, sid,cid (no special keys).

Is it possible to get rid of studentclass table and use student and class tables only, without creating duplicate entries in student or in class tables?

(class can have multiple students and student can attend multiple classes)

Thanks.

usr_profile.png

User

( 4 months ago )

If the business logic states that, one student can attend multiple classes then it is good to have a linking table, StudentClass.

You can think of this as a Many to Many relationship where one student can attend multiple classes and one class can have multiple students.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif