From the course: Learning Relational Databases
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Understand entities and tables
From the course: Learning Relational Databases
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.