Give an example of two database tables that would contain a one-to-many relationship. Describe the relationship
What will be an ideal response?
A bank customer is entered into a Customers table once. The same customer could set up multiple accounts that would be contained in the Accounts table (i.e., checking, savings, and money market accounts). The CustomerID would appear once in the Customers table and three times in the Accounts table. Therefore, the relationship between Customers and Accounts would be described as one-to-many.
You might also like to view...
Which of the following choices is not one of the twelve activities carried out by at least thirty-two of the organizations studied by the BSIMM?
A. Provide awareness training B. Gather attack intelligence C. Create security standards D. Use third party security testing
What are some advantages to writing programs in a high-level language instead of machine code?
What will be an ideal response?