Final answer:
Composite attributes in the ER model do make it easier to facilitate detailed queries by allowing attributes to be broken down into their component parts.
Step-by-step explanation:
Composite attribute: A composite attribute is made up of more than one simple attribute. For example, student's address will contain, house no., street name, pincode etc. 2. Derived attribute: These are the attributes which are not present in the whole database management system, but are derived using other attributes.
In the Entity-Relationship (ER) model, composite attributes are those that can be divided into smaller sub-parts, which represent more basic attributes with independent meanings. For example, a 'Name' composite attribute can be broken down into 'First Name' and 'Last Name'. The statement that composite attributes make it easier to facilitate detailed queries is true.
This is because composite attributes allow for greater precision in queries. For instance, if a database has a composite attribute for an address, broken down into street, city, and zip code, one can easily query for all individuals within a specific zip code or city. This level of detail would be more challenging to achieve if the complete address were stored as a single, indivisible attribute.