Log In
1 vote

in Databases 537 views

2 Answers

4 votes
Here customer to account one to many relation so for each entity one table, total 2 tables.

Next account to statements one to many relation.and here statements is weak for statements one table has been created,where number attribute of account which is Pk,add with id of statements entity and formed candidate key of that new table.and for for account already one table has been created previously .

Next phones and customer in many to many relation ,so we already created a table for customer previously,now one table for relation has and one table for phones has been created. So 2 more new tables.

So total 5 tables will be needed.
1 vote

Here we have 3 strong entity and 1 weak entity(using number as foreign key for this table) so total 4 tables needs to be created.

Hi , please correct me .

But , weak entities do not have key attribute , right ?

But , here all entities have key , attribute.

what about owns & has tables ?


Hi Amsar Sokt,

here has relation is 1 to 1 with Customer entity.

so , we can remove the Phones entity.

We can directly add the number attribute of Phones to Customer .

Please correct , me if I am wrong.


 has   is  many to many..

Related questions

1 vote
1 answer
How to represent referential integrity constraint in ER model? pls explain with diagram
asked Jun 7, 2019 in Databases aditi19 469 views
0 votes
0 answers
1 vote
5 answers
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?
asked Jul 31, 2018 in Databases Abbas2131 454 views
0 votes
1 answer
Let E1 and E2 be two entities and R is a relation between E1 and E2, then what is the minimum no of tables required to represent E1, E2 and R if - E1 and E2 have 1:m cardinality(E1 on 1 side, E2 on m side); E1 has total participation and E2 has partial ... . E1 and E2 have m:n cardinality; both E1 and E2 have total participation. I am not able to find a single solution for this. Kindly help.
asked May 3, 2018 in Databases shuklas664 331 views