Question
Download Solution PDFThe purpose of analysing an N-Ary association in databases is :
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe correct answer is option 3: To deal with relationships that involve more than two tables
Key Points
- An N-ary association in a database refers to a relationship that involves N entities (or tables), where N ≥ 3.
- It is used when the relationship cannot be accurately or efficiently represented using just binary (2-table) associations.
- Commonly modeled using a relationship table that includes foreign keys referencing each of the N participating entities.
Additional Information
- Option 1: Parent-child relationships are typically represented using recursive relationships or 1:N binary associations.
- Option 2: One-to-many is a 2-entity (binary) relationship, not N-ary.
- Option 4: Inheritance is represented using generalization/specialization hierarchies, not N-ary associations.
Hence, the correct answer is: option 3: To deal with relationships that involve more than two tables
Last updated on Jun 12, 2025
-> NIELIT Scientific Assistant city intimation slip 2025 has been released at the official website.
-> NIELIT Scientific Assistant exam 2025 is scheduled to be conducted on June 28.
-> A total number of 113 revised vacancies have been announced for the post of Scientific Assistant in Computer Science (CS), Information Technology (IT), and Electronics & Communication (EC) streams.
-> Online application form, last date has been extended up to from 17th April 2025.
->The NIELT has revised the Essential Qualifications for the post of Scientific Assistant. Candidates must possess (M.Sc.)/ (MS)/ (MCA) / (B.E.)/ (B.Tech) in relevant disciplines.
-> The NIELIT Scientific Assistant 2025 Notification has been released by the National Institute of Electronics and Information Technology (NIELIT).