Describe what attributes represent in an ER model and provide examples of simple, composite, single-value, multi-value, and derived attributes.

What will be an ideal response?

An attribute represents a property of an entity or a relationship type (see Section 12.3).
Examples:
Simple: position or salary attribute of Staff
Composite: address attribute composed of street, city, and postcode attributes
Single-valued: branchNo attribute of Branch
Multi-valued: telNo attribute of Branch
Derived: duration attribute of Lease, calculated from rentStart and rentFinish

attributes.

Computer Science & Information Technology

You might also like to view...

The following loop would execute ___________________ times: Loop index from 0 up to (but not including) 10 times incrementing by 1

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

Computer Science & Information Technology

The figure above shows the ____.

A. List Properties dialog box B. HTML Lists inspector C. HTML Property inspector D. Semantic Web Property inspector

Computer Science & Information Technology