Register

ER to Relational Mapping

288 views

1 Answer

Best answer
1 votes
1 votes
2 relations are required...there is 1:1 cardinality between customer and account....also it is partial on both sides due to"can"...so we will need two tables to represent the relationship...
• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
KISHALAY DAS asked Oct 19, 2016
1,555 views
ER to Relational mapping
How can trainer id be p.key of Parts??
How can trainer id be p.key of Parts??
User Avatar
0 votes
0 votes
2 answers
2
priyanshu710 asked Sep 15, 2021
816 views
ER Model to Relational Model Conversion
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side? Can i have just a single table with all attributes and (A1,B1) as a composite primary key?
What is the minimum number of relations required to represent a one-to-many relationship having total participation on the many side?Can i have just a single table with a...
User Avatar
0 votes
0 votes
1 answer
3
aditi19 asked May 28, 2019
1,437 views
Virtual Gate Test Series: Databases - ER to Relational Model
how many tables are required?
how many tables are required?
User Avatar
0 votes
0 votes
0 answers
4
Syeda97 asked Nov 11, 2018
512 views
er diagram to relational model conversion
In case of 1:1 relationships, when can we have a minimum of 1 table? when both the entities have total participation when atleast one entity have total participation
In case of 1:1 relationships, when can we have a minimum of 1 table?when both the entities have total participationwhen atleast one entity have total participation
User Avatar
Link Copied!