Question: What is the answer for the following excel question? How can you initially improve the relationship to achieve the most functional outcome from the database?
What is the answer for the following excel question?
How can you initially improve the relationship to achieve the most functional outcome from the database? Bank Database Demo: Database (Access 20 Home Create External Data Database Tools Design Hide Table Direct Relationships X Clear Layout Edit Relationship Report Show Table 3 All Relationships Tools All Access Objects Account Customer Tables Customer ID First Name Last Name Address City State Post Code Phone Number Customer ID Branch ID Balance Branch Customer Branch Branch ID Start Date Phone Number Branch Type By deleting the Customer Table By checking that enforcing referential integrity box is selected in the Customer and Account Table By running a query on the Branch and Account Table By creating a relationship with the primary key Customer ID in theCustomer table to the foreign key Customer ID in the Account Table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
