The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
59 views

Please Explain in detail i am weak in this topic

asked in Databases by Loyal (8.7k points) | 59 views
0

2 Answers

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?

 

answered by Loyal (5.2k points)
0

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
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

Four tables are required

Child(name,age,gender,ssn)

Dept(Did,dname,address,ssn)

Works(ssn,Did)

Emp(ssn,Ename,rating)

answered ago by (11 points)

Related questions

0 votes
0 answers
1
0 votes
0 answers
6
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
49,434 questions
53,630 answers
186,007 comments
70,899 users