Into the data: Day 8

Into the data: Day 8

On Day 8, I learned about relational databases and I learned about primary keys, foreign keys and composite key. A primary key is something that has unique value and can only appear once in that particular column.

As for a foreign key, it is that same primary key that appears in a different column where it is not the primary key and finally for the composite key, it is a mix of primary keys resulting in a unique key.

Road to dev

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Descriptive Statistics in Data Science

How I preprocessed text data using Regular Expressions for my Text classification task (CNN)

Best Ways To Learn Data Science

What the Fashion Industry is using Data Science

5 Categorical Encoding Tricks you need to know today as a data scientist

Let’s Talk About Ancient Empires And Their History

Interpreting an LSTM through LIME

Adapting in Data Science

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Chanak Karki

Chanak Karki

Road to dev

More from Medium

Data Cleaning with Pandas

Dynamic SQL and Embedded SQL

Applying for Data Science Masters in the UK?

Increasing Demand for ‘ Hadoop and NoSQL Skills