Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations.

What will be an ideal response?


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.

PTS: 1

Computer Science & Information Technology

You might also like to view...

A constructor is a method named __________ found inside the class.

a. New b. Constructor c. Finalizer d. the same as the class name

Computer Science & Information Technology

Chrome is the browser used on a Chromebook

Indicate whether the statement is true or false

Computer Science & Information Technology

Which of the following are not included in themes?

A) Fonts B) Effects C) Colors D) Formulas

Computer Science & Information Technology

Leading or trailing white space can be removed from submitted data using the ____________________ function.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology