What is an association relationship and how does it differ from an N:M relationship?
What will be an ideal response?
An association relationship is very similar to an N:M relationship except that the intersection table has attributes of its own. This means that in addition to the foreign key fields linking to the two strong entities, there is at least one additional field in what would otherwise be called the intersection table but is now an association table. For example, intersection table ENROLLMENT for STUDENT and CLASS showing student enrollment in each class would normally have two columns: StudentID and ClassID. However, we can turn this intersection table into an association table by adding the column Grade, which records each student's grade in each class.
You might also like to view...
Historically, the average proportion of defective bars has been 0.015. Samples will be of 100 bars each. Construct a p-chart using z = 3. What is the value of UCL?
A) less than or equal to 0.050 B) greater than 0.050 but less than or equal to 0.060 C) greater than 0.060 but less than or equal to 0.070 D) greater than 0.070
A short position reflects the expectation of price increases
Indicate whether the statement is true or false
Garnishment is one form of prejudgment remedy
Indicate whether the statement is true or false
The most popular database in the last 30 years has been the relational database
Indicate whether the statement is true or false