Question: 1. Create a database with the following tables. Customer Customer ID Account Account Number . . Name Balance Address Phone Account Type Email Customer ID

1. Create a database with the following tables. Customer Customer ID Account Account Number . . Name Balance Address Phone Account Type Email Customer ID Establish the referential integrity among tables; Set up appropriate input mask column phone; For each foreign key column, set up a combo box to look up values from its corresponding primary key column; Set up domain validation for the field "Account type" such that it only allow values Checking or Savings; Set up domain validation for the field "Balance" such that it does not allow negative values
 1. Create a database with the following tables. Customer Customer ID

1. Create a database with the following tables: Account \begin{tabular}{|l|l|l|l|} \hline Account Number & Balance & Account Type & Customer ID \\ \hline \end{tabular} - Establish the referential integrity among tables; - Set up appropriate input mask column plione: - For cach foreign key columin, set up a combo box to look up values from its corresponding primary key columin: - Set up domain validation for the field "Account type" such that it only allow values Checking or Sovings: - Set up domain validation for the field "Balance" such that it does not allow negative values

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!