🌴 Entities, attributes and relationships

entity

Something that you can store information about.
You identify attributes for the entity.

Examples

Entities

Student
- Age
- Gender
- Name (first)
- Name (last)
- DoB

Car
- Manufacturer
- Age
- Mileage
- Colour
- Model

Book
- Name
- Pages
- Author
- Category
- Title
- Publisher details

Rental
- Value
- Rental owner
- Rental time

Member
- Name
- DoB
- Books borrowed
- Length of membership
- ID
- Address

description

A database is used to store data about entities.
The entities have attributes - A set of attributes is identifies as a record.
E.g: Student: John Peters, 17, 12 Dalestreet, Dudlet, DY8 2QP - This would be an individual record.