Database Design Courses

A relational database is a type of database that stores data that is organized in structures called tables and these tables are related to one another through defined relationships. Each table has columns and rows. Columns represent attributes and define a structure to the data. Each row is a record of information stored in the table. The relationships between tables are defined by assigning certain columns as foreign and primary keys. For example, a vehicle table might contain the VIN number as a primary key since that uniquely identifies each record of information about a car. There may be another table in the database called dealerships. The data can be structured in such a way that each car belongs to some dealership. The relationship between these 2 tables can be organized by having the dealership’s key in the vehicles table. So that every vehicle has a dealership associated with it representing where that vehicle belongs.