PostgreSQL: What Is A Relationship/Foreign Keys | Course | 2019

preview_player
Показать описание
PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems. Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

In this video you will learn what relationships and foreign keys are.

PS

Thanks for watching…
Рекомендации по теме
Комментарии
Автор

what if i want a person to have multple cars. no need to use unique. but I am having unique constraint errors. any help?

josephnarteyopey
Автор

How would you set up more than one foreign key? Like in a star schema for a fact and dimension tables.

orr
Автор

i live the way you explain. would you mind sharing your email for other clarification on the same please

reubenmwangikibara
Автор

if i have relation That say a car can have many peson and Can be belong by many persone it mean 1.n 1.n How i did it ??

jeoab
Автор

The main question is What is the benefit to have data like that in different tables?
A transaction will search through 2 table indexes instead of one to get car data

evgenylevchenya