Q4Database Management System
Question
4 marks
What are the various types of attributes in E-R model?
Answer
Simple, Composite, Single-valued, Multi-valued, Derived.
- Simple vs Composite: Simple cannot be divided (e.g. Roll No), Composite can (e.g. Name -> First, Last).
- Single vs Multi-valued: Single has one value, Multi-valued can have many (e.g. Phone numbers).
- Derived: Calculated from other attributes (e.g. Age from DOB).