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

Please Explain in detail i am weak in this topic

in Databases by Loyal (6.6k points) | 76 views
0

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

 

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
works relationship is m:n and it is correctly shown in ER diagram
0 votes

Four tables are required

Child(name,age,gender,ssn)

Dept(Did,dname,address,ssn)

Works(ssn,Did)

Emp(ssn,Ename,rating)

by (25 points)
0 votes
4 tables are required
by Junior (785 points)

Related questions

0 votes
1 answer
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,807 questions
54,727 answers
189,302 comments
79,845 users