Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database theory
Database theory
MUSIC DATABASE
The Primary Key is the "Track ID". This makes every entity unique, even if they had the same name and attributes.
Artist, Album title, Track number etc are all attributes . They hold information about each individual song.
-
-
A record consists of an entity and it's attributes, forming a row with information about a specific thing.
A secondary key is a search index, for example the Artist and Album title.
-
Data types
-
-
-
-
-
Logical. Boolean (True/False), Yes/No
-
Terminology
-
-
-
ENTITY: A subject, usually a noun, person etc which has lot of different attributes.
-
-
-
-
-
-
-
