419 views

2 Answers

1 votes
1 votes

Ans : 2  in case of 1NF

1 For E1
1 For E2 &R   (Because in 1NF values should be atomic & no multivalued entry should be allowed.)

Ans : 3  in Case of 3NF

1 for E1
1 for E2
1 for R ( because its m:n relationship)
So 3

edited by

Related questions

0 votes
0 votes
0 answers
1
Ashutosh_17 asked Apr 13, 2023
424 views
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...
1 votes
1 votes
1 answer
3
aditi19 asked Jun 7, 2019
1,849 views
How to represent referential integrity constraint in ER model?pls explain with diagram
1 votes
1 votes
0 answers
4
bts1jimin asked Aug 30, 2018
1,275 views