1,700 views

2 Answers

4 votes
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 entity.so 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 votes
1 votes

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.

Related questions

0 votes
0 votes
0 answers
1
Ashutosh_17 asked Apr 13, 2023
424 views
Consider the following relation (capitalized letters are attributes and lower letters are values).X:From the given FDs find the dependencies that seems to apply on X and ...
1 votes
1 votes
1 answer
3
aditi19 asked Jun 7, 2019
1,851 views
How to represent referential integrity constraint in ER model?pls explain with diagram
1 votes
1 votes
0 answers
4
bts1jimin asked Aug 30, 2018
1,275 views