CARDINALITY RATIO

Question

Attributes of

TEACHER are as (t_no,name)

TEACHES are as (sub_id,sub_name) and

COURSES are as (c_no,duration)

Give answer as minimum number of table required for cardinality ratios

1:m & m:1 & 1:1 & m:m in

form of TABLES by taking some values as example 

Answer 1

For cardinality ratio 1:m..it means teacher to course is one to many , can be interpreted as one teacher teaches more than one subject ..
Now it is obvious that two tables should be there ..one for teacher entity and another for course..now we see  for relationship teaches , is there a need to have a table for this or not ?? Well u could make a extra table  for it , but as u r asking for minimum no. Tables then there is no need for it .. u could move the attributes of teaches relationship either towards teacher or course table ..but it is logical to move it towards 'm' side ...
For ex.
If a teacher let say X,  teaches two subjects maths and physics ..then these subjects will have different sub_id,sub_name , and if move these attributes towards teachers side then there would be redundancy in teacher's table ..amd if move the towards couse's table then no redundancy will be there and also it looks logical too..
Now the answers to all ur ques.
1:m--2 tables
m:1--2 tables
1:1-- 2 table (could move the attributes of relationship to either table teacher or course)
m:m-- 3 tables (1 extra table is required having primary taken to be the combination of primary key from eqch table )

Comments

It means if there would be no cardinality ratio given in this question then we will have minimum 3 table right!

My other doubt is see in below question how in part 5 question 1 table is possible even wrong explanation given

https://gateoverflow.in/77410/doubt

Please reply

---

Without cardinality there will be no relationship .. so each entity has their own table but there would be no relationship btwn them ..

Answer 2

1:M

STAT 1:Every course taught by exactly one teacher and a teacher can teach more than one course.

Minimum no of tables required=2

M:1

STAT 2:Every teacher teaches exactly one course and a course can be taught by many teacher.

Minimum no of tables required =2

M:N

STAT 2:Every teacher is supposed to teach at least one course and every course can be taught by atleast one course.

Minimum no of tables required=3

READ ALL THE STATEMENTS AND TRY TO GIVE VALUES IT WILL BE EASY NOW.

HOPE IT HELP!

Comments

Exactly !!! you are right I am also saying same thing you can always merge the table when you have total participation on both sides and no redundancy,so if in this case even if m:n given it will behave like 1:1(due to no redundancy)

If I am wrong please correct me

---

you can say M:N behave like 1:1 but technically it is not correct because meaning of "Every teacher is supposed to teach at least one course and every course can be taught by atleast one course" will change.

---

Yes I got it thanks sir thanks for your valuable reply