Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database theory (MUSIC DATABASE (The Primary Key is the "Track…
Database theory
Terminology
-
-
-
ENTITY: A subject, usually a noun, person etc which has lot of different attributes.
-
-
-
-
-
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
-
-