Question: = (15 Points] Consider the following two tables in a banking database application. Account {AccNumber, Type, Balance} Customer={CustID, FirstName, LastName, Address, AccNumber} An account type
![= (15 Points] Consider the following two tables in a banking](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f2ffef45e91_26266f2ffeeae940.jpg)
= (15 Points] Consider the following two tables in a banking database application. Account {AccNumber, Type, Balance} Customer={CustID, FirstName, LastName, Address, AccNumber} An account type could be saving or checking. The meaning of the other attributes used should be clear. (a). Identify a suitable domain for each attribute. (b). For each relation, give a possible instance with at least 3 tuples. (c). Identify at least 3 problems with the design of this database and propose an equivalent database schema (i.e., having the same information content) but does not suffer from these problems. Describe your new design using the E/R notation
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
