Database

API is the abbreviation for Application Programming Interface, which enables data transmission between multiple software intermediaries. This blog is to extract data through Star Wars API in the Python environment.

This blog is to create a SQLite3 schema to store Spotify dataset following the requirement of database normalization 1NF, 2NF and 3NF. The normalization design will reduce data redundancy and prevent inconsistencies on insertion, update and deletion.