From the course: SQL for Non-Programmers
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Database structuring through normalization - SQL Tutorial
From the course: SQL for Non-Programmers
Database structuring through normalization
Relational databases are not designed in the way that you might think of as a flat table or a spreadsheet with rows and columns. Although they do use the same idea of tables, rows, and columns, they are structured in a way that attempts to minimize redundancies and allow for maximized efficiency when storing information. Relational databases are built using a process called normalization. Normalization aims to organize data in a database so that each piece of information is only stored in one place. This helps to prevent data duplication and inconsistencies in the data, making it easier to manage and ensuring that the database is more efficient and accurate. Let's use an example to demonstrate how this works. Using our library example, you see here a table that looks like something you would see in an Excel file. The table is called library books and it contains information about books in a specific library. Each row represents a book and includes the book ID, the book name, author…
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.