blob: b46aa88db1fc8ca47ba5619f235703ced7db45b1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- Could have saved two table here. But having them avoids redundancy as well as
-- make it possible for future enhancements.
CREATE TABLE artist (
name varchar(200) NOT NULL,
PRIMARY KEY(name)
);
CREATE TABLE song (
title varchar(200) NOT NULL,
album varchar(200),
artistname varchar(200),
genrename varchar(200),
year int,
PRIMARY KEY(title, artistname, year)
);
CREATE TABLE genre (
name varchar(200) NOT NULL,
PRIMARY KEY(name)
)
|
