Explain the difference between simple and composite attributes Provide at least one example of each?

Answer 1

Composite attributes can be divided into smaller subparts, which represent more basic attributes with independent meanings. For Eg: the address attribute of the employee entity can be subdivided into street add, city, state and zip. They can also form hierarchy like the street ass can be further subdivided into three simple attributes i.e. no street and apartment no. its value is the concatenation of the values of its constituent simple attributes. Attributes that are not divisible are called simple or atomic attributes.