3 votes 3 votes Please Explain in detail i am weak in this topic Databases databases er-diagram + – Na462 asked May 12, 2018 Na462 1.6k views answer comment Share Follow See 1 comment See all 1 1 comment reply register_user_19 commented Nov 24, 2018 reply Follow Share similar question:- https://gateoverflow.in/229580/madeeasy-test-series-number-of-tables-required 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes Four tables are required Child(name,age,gender,ssn) Dept(Did,dname,address,ssn) Works(ssn,Did) Emp(ssn,Ename,rating) Prasun786 answered May 17, 2019 Prasun786 comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Three tables for three entities. For 1:N relationship no separate table is made. Below images might help. Any specific notation in your question that you don't understand? Akhilesh Singla answered May 12, 2018 Akhilesh Singla comment Share Follow See all 3 Comments See all 3 3 Comments reply Na462 commented May 12, 2018 reply Follow Share Sir here two relations are defined in between same entities:- Manages and Works one with many to one and one with many to many.And in many to many there are three relation to build and in many to one only two so how did u proceed. Sir can u tell me the approach to solve such question in deciding the number of relation for satisfying 1nf or 2nf. which critical points we need to keep in mind and how to tackle such problems. Its my weakest topic in dbms. I know the concept please see my comment in this question https://gateoverflow.in/216460/er-diagram-to-table-1 Only this much i know am i lacking up something please help me in this 0 votes 0 votes Akhilesh Singla commented May 12, 2018 reply Follow Share I considered Works relationship as 1:1 because it is shown as 1:1 in the ERD. I do agree Works relationship should be either many to many or many to one. 0 votes 0 votes Satbir commented Jul 27, 2019 reply Follow Share works relationship is m:n and it is correctly shown in ER diagram 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 4 tables are required suryaprakash answered Jul 27, 2019 suryaprakash comment Share Follow See all 0 reply Please log in or register to add a comment.