retagged by
1,104 views

2 Answers

0 votes
0 votes

Yes you are correct. As you mentioned for one to one relationships seperate table is not required. But column which is common can be added to etiher one of the two tables involved. 

Only for many-to-many relationships and multivalued attributes a seperate table is requied. Refer this video link. Everything is explained very clearly in that.

https://www.youtube.com/watch?v=R2zxPAoRm_8&index=30&list=PLx5CT0AzDJCnO9k98RsrPY9WGAXj8yeKL

0 votes
0 votes
Yes, you are right. We need to draw a table for multivalued attributes and many to many relationships.

Related questions

15 votes
15 votes
13 answers
1
targate2018 asked Aug 12, 2017
8,578 views
How many minimum relations required for given ER diagram ?
11 votes
11 votes
4 answers
2
targate2018 asked Aug 11, 2017
11,485 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.
1 votes
1 votes
6 answers
3
Abbas2131 asked Jul 30, 2018
2,234 views
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?
3 votes
3 votes
2 answers
4