Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.
2. Searching for something specific? See our text overview of all tests. Scroll right for levels, and lists.

Student and Teacher User Guides |   Schemes of Work |   Real Teacher use Videos |

Join 30000+ teachers and students using TTIO.

Data Modeling

Data modeling is a technique to document a software system using diagrams and symbols. It is used to represent communication of data. The highest level of abstraction for the data model is called the Entity Relationship Diagram (ERD). It is a graphical representation of data requirements for a database.

Entities can be thought of as nouns. Examples: an arrist, a computer, an employee, a song, a mathematical theorem, etc.

Two related entities

A relationship captures how entities are related to one another. Relationships can be thought of as verbs, linking two or more nouns. Examples: an owns relationship between a company and a computer, a supervises relationship between an employee and a department, a performs relationship between an artist and a song, a proves relationship between a mathematician and a conjecture, etc.

An entity with an attribute

Suggested Video

Entity Relationship Diagram

The main value of carefully constructing an ERD is that it can readily be converted into a database structure.

There are three components in ERD.

  • Entities: Number of tables you need for your database.
  • Attributes: Information such as property, facts you need to describe each table.
  • Relationships: How tables are linked together.

.CPT-Databases-Exercise-PlayerAnswerQuestion.svg

www.teachyourselfpython.com