From the course: Data Engineering Foundations

Unlock the full course today

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

Understanding database schema

Understanding database schema

From the course: Data Engineering Foundations

Start my 1-month free trial

Understanding database schema

- [Instructor] The next step is to understand how to design and develop databases. To do that, we need to learn about database schema. To reiterate, a database schema describes the structure and relationships between tables of a database. Here, you can see a database schema on the right hand side. This is a very simple example of a restaurant ordering system. We have one thing we call customer and the other called order. You have defined properties of each table, where ID in each table is the primary key which is the unique identifier of each instance of that particular table. The field called customer ID in the order table connects orders with customers. We call this kind of column or field a foreign key, as it refers to another table. Let's see how we can create such a schema in a database using SQL. If you want to get a SQL primary, you can refer to courses in our library that can help you master SQL. The SQL…

Contents