Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations
A one-to-one association means that for every occurrence in record type X, either zero or one occurrence exists of record type Y. An example would be that for every student, only one social security number exists.
A one-to-many association means that for every occurrence in record type X, either zero, one, or many occurrences exist of record type Y. An example would be buyers of assigned seating at concerts. Each potential buyer would leave the sales box office with zero, one, or many seats.
A many-to-many association is a two-way relationship. For each occurrence of record types X and Y, zero, one, or many occurrences exist of record type Y and X, respectively. An example would be a student-professor relationship. Each student has multiple professors each semester, and each professor has multiple students each semester.
You might also like to view...
______________________________ systems use the Internet to automate and manage purchases and the vendors from which these purchases are made
Fill in the blank(s) with correct word
Normal expenditures for repairs and maintenance to plant and equipment are accounted for by
a. debiting Equipment and crediting Cash and Supplies Inventory. b. debiting Repairs Expense and crediting Cash and Supplies Inventory. c. debiting Cash and Supplies Inventory and crediting Repairs Expense. d. debiting Cash and Supplies Inventory and crediting Equipment.
When introducing an audience to new or unfamiliar information, use this type of verbal support
A) comparison B) testimony C) statistic D) story
Ownership of data in traditional legacy systems often leads to data redundancy. This in turn leads to several data management problems. What are they? How does the database approach solve them?