Entities+and+attributes

Introduction
An entity represents a person or an object, or something abstract. Each entity has a set of attributes that describe examples or instances of that entity.

The entity name should be written in capital letters, and in singular. The attributes should follow in a bracketed list.

Below are some examples of each type of entity:


 * Person**
 * a customer
 * a pupil
 * an employee

In the above example, the entity is PUPIL and the attributes are Pupil ID, Forename, Surname and DOB

The entity and attributes are written as PUPIL(Pupil ID, Forename, Surname, DOB)

There are 3 instances of the entity PUPIL in the above table


 * Object**
 * a CD
 * a film
 * a course or subject



In the above example, the entity is CD and the attributes are CD Reference, CD Title, No Tracks and Year of Release

The entity and attributes are written as CD(CD Reference, CD Title, No Tracks and,Year of Release)

There are 3 instances of the entity CD in the above table


 * Abstract**
 * a booking
 * a holiday
 * a rental



In the above example, the entity is BOOKING and the attributes are Booking Code, Date, Time and Duration

The entity and attributes are written as BOOKING(Booking Code, Date, Time and Duration)

There are 3 instances of the entity BOOKING in the above table

Scholar Link: [|Data, entities and relationships]

Task
Pets R Us sell a range of animals to the public. For each pet they sell they have to log its details.

Write down 8 possible attributes for the entity PET