Skip to main content

๐ŸŒด Entities, attributes and relationships

Something that you can store information about.

tip

Identifying the attributes for the entity

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 (member)
    • Name
    • DoB
    • Books borrowed
    • Length of membership
    • ID
    • Address
tip

๐Ÿ’ก Database is used to store data about entities. The entities have attributes. A set of attributes is identified as a record. Eg. Student: John Peters, 17, 12 Dalestreet, Dudley, DY8 2QP - Individual record