From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Understand entities and tables

Understand entities and tables

From the course: Learning Relational Databases

Start my 1-month free trial

Understand entities and tables

“

- [Narrator] Now that we have a pretty comprehensive list of data elements that we need to store, it's time to start organizing them into the structures that we'll need to go in the database. By doing so, we're going to start building what's called a data model. A data model is a graphical representation of the elements that make up the overall database's design. It's the construction blueprint that we've been working towards. The data model will also help us visualize the tables, fields, and the relationships that will allow the database to both store and retrieve information very efficiently. Tables represent the various types of entities that we want to keep track of in the database. And records or rows in those tables hold information about a single person, place, thing, or event. In order to discover the tables that we need to create. We need to take a close look at the field list that we generated in the last chapter and start organizing them into logical groupings of entities…

Contents