Register

DBMS-10

360 views
0 votes
0 votes

User Avatar

1 Answer

0 votes
0 votes
1 for customer and 1 for account

Relation account 'owned by' customer is one-to-one. So, accountId can be used as foreign key in customer table. Alternatively, customerId can be used as foreign key in account table.

=> Min 2 relations/tables needed
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
3
akash.dinkar12 asked Apr 1, 2019
1,415 views
DBMS Korth Edition 4 Exercise 15 Question 10 (Page No. 589)
Consider the precedence graph of Figure 15.18. Is the corresponding schedule conflict serializable ? Explain your answer.
Consider the precedence graph of Figure 15.18. Is the corresponding schedule conflict serializable ? Explain your answer.
User Avatar
0 votes
0 votes
1 answer
4
akash.dinkar12 asked Apr 1, 2019
1,107 views
DBMS Korth Edition 4 Exercise 12 Question 10 (Page No. 491)
Explain the distinction between closed and open hashing. Discuss the relative merits of each technique in database applications.
Explain the distinction between closed and open hashing. Discuss the relative merits of each technique in database applications.
User Avatar
Link Copied!