MySQL

profilewind9j72b
HW2_Problem1_DataSet-1.zip
Home>Computer Science homework help>MySQL

__MACOSX/._HW2_Problem1_DataSet

HW2_Problem1_DataSet/HW2_Q1_Song.csv

sid sname artistId language style duration releaseTime
1 Hold On 6 English Pop 2:51 2021-03-05
2 Pace 1 null Jazz 7:53 2020-08-21
3 The Message Continues 1 null Jazz 6:45 2020-08-21
4 Source 1 null Jazz 12:08 2020-08-21
5 Together Is a Beautiful Place to Be 1 null Jazz 7:36 2020-08-21
6 Stand with Each Other 1 null Jazz 3:39 2020-08-21
7 Inner Game 1 null Jazz 7:45 2020-08-21
8 La cumbia me est llamando 1 Spanish Jazz 4:15 2020-08-21
9 Before Us: In Demerara & Caura 1 null Jazz 8:01 2020-08-21
10 Boundless Beings 1 null Jazz 2:47 2020-08-21
11 One Time 6 English Pop 3:35 2009-11-07
12 Favorite Girl 6 English Pop 4:16 2009-11-07
13 Down to Earth 6 English Pop 4:05 2009-11-07
14 Bigger 6 English Pop 3:17 2009-11-07
15 One Less Lonely Girl 6 English Pop 3:49 2009-11-07
16 First Dance 6 English Pop 3:42 2009-11-07
17 Love Me 6 English Pop 3:12 2009-11-07
18 Eyes On Me 5 English Pop 5:36 1999-02-24
19 Long Maan Fung Bou 5 Cantonese R&B 3:57 1992-05-01
20 Miss You Night and Day 5 English R&B 5:35 1992-05-01
21 Vulnerable Woman 5 Cantonese R&B 4:22 1992-05-01
22 Blind Date 5 Cantonese R&B 4:42 1992-05-01
23 Put the Key in the Mailbox 5 Cantonese R&B 5:11 1992-05-01
24 These Those 5 Cantonese R&B 4:25 1992-05-01
25 Happy Tears 5 Cantonese R&B 4:25 1992-05-01
26 Rekindled Love 5 Cantonese R&B 3:48 1992-05-01
27 Round and Round 5 Cantonese R&B 5:15 1992-05-01
28 Kisses in the Wind 5 English R&B 4:05 1992-05-01
29 Blue Moon 2 English Jazz 2:49 2020-09-02
30 Here, There and Everywhere 2 English Jazz 2:56 2020-09-02
31 I want Us To Be Together 2 English Jazz 4:54 2020-09-02
32 When I Fall In Love 2 English Jazz 4:31 2020-09-02
33 Moon River 2 English Jazz 3:33 2020-09-02
34 Somewhere Along The Way 2 English Jazz 2:38 2020-09-02
35 Our Love Is Here to Stay 2 English Jazz 4:05 2020-09-02
36 Stormy Weather 2 English Jazz 3:45 2020-09-02
37 Over The Rainbow 2 English Jazz 4:07 2020-09-02
38 Big Deal 3 English Jazz 2:32 2020-08-12
39 Philosophy 3 English Jazz 4:30 2020-08-12
40 Turn the Page 3 English Jazz 3:16 2020-08-12
41 Les sources 7 French R&B 0:59 2018-11-16
42 Kiev 7 French R&B 3:52 2018-11-16
43 La plage 7 French R&B 4:07 2018-11-16
44 Ces mots simples 7 French R&B 2:55 2018-11-16
45 Coest dire 7 French R&B 4:44 2018-11-16
46 On oubliera 7 French R&B 4:23 2018-11-16
47 Mio Cuore 7 French R&B 3:00 2018-11-16
48 Ce que le vent nous souffle 7 French R&B 3:02 2018-11-16
49 Dans notre monde 7 French R&B 3:36 2018-11-16
50 Si loin si proche 7 French R&B 3:08 2018-11-16
51 A la hauteur de mes bas 7 French R&B 3:59 2018-11-16
52 Chzri 7 French R&B 4:26 2018-11-16
53 Out of Habit 8 English Folk 2:46 2019-05-09
54 The Whole Night 8 English Folk 3:09 2019-05-09
55 Names and Dates and Times 8 English Folk 4:17 2019-05-09
56 Anticipate 8 English Folk 3:33 2019-05-09
57 Gratitude 8 English Folk 3:06 2019-05-09
58 Every State Line 8 English Folk 2:58 2019-05-09
59 God's Country 8 English Folk 2:30 2019-05-09
60 If He Tries Anything 8 English Folk 3:30 2019-05-09
61 Not a Pretty Girl 8 English Folk 3:00 2019-05-09
62 Dilate 8 English Folk 4:44 2019-05-09
63 As Is 8 English Folk 4:28 2019-05-09
64 Swan Dive 8 English Folk 5:38 2019-05-09
65 Subdivision 8 English Folk 3:55 2019-05-09
66 To the Teeth 8 English Folk 5:13 2019-05-09
67 Grey 8 English Folk 5:13 2019-05-09
68 Paris 9 null Folk 3:03 2020-05-21
69 London 9 null Folk 2:10 2020-05-21
70 Inland Empire 9 null Folk 3:27 2020-05-21

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_Song.csv

HW2_Problem1_DataSet/.DS_Store

__MACOSX/HW2_Problem1_DataSet/._.DS_Store

HW2_Problem1_DataSet/HW2_Q1_User.csv

uid uname profiletext
1 dorker Pick up music
2 sophronia I don not have to describe myself, do I?
3 twist I AM WHO I AM AND THAT IS JUST ENOUGH
4 wickham No space is no space
5 flora You cannot help but like me. You will see
6 yawler Get set to get your mind blown away
7 sweedlepipe Eating, sleeping, running, dancing, talking. I love many things.
8 snawley This bio will load in a few years
9 chuzzlewit Country lover
10 tippin The mind is unique. It is the key to whether you win or lose
11 chollop In the end, the love you take is equal to the love you make.
12 peps Awesome? That I am. Perfect? Not at all, but welcome to my space anyway
13 slum I am hoping you will realize how cool I have been to you someday
14 linkinwater Cool, funny, witty, wonderful. I am all that and more, just take a seat and grab a cookie
15 bunsby You do not have to like me; just enjoy the space

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_User.csv

HW2_Problem1_DataSet/HW2_Q1_PlayHistory.csv

uid sid startTime endTime
1 8 2020-7-27 05:44:28 2020-7-27 05:46:00
1 37 2020-7-19 05:13:26 2020-7-19 05:15:00
1 50 2020-10-18 16:42:00 2020-10-18 16:44:00
2 13 2020-8-29 16:17:08 2020-8-29 16:19:00
2 45 2020-5-1 22:06:00 2020-5-1 22:08:00
2 51 2020-11-23 21:09:00 2020-11-23 21:11:00
3 2 2020-12-16 07:00:56 2020-12-16 07:02:56
3 9 2020-9-3 21:00:57 2020-9-3 21:02:00
3 17 2020-4-28 20:52:50 2020-4-28 20:53:50
3 37 2020-4-17 00:30:41 2020-4-17 00:33:41
3 37 2020-5-6 06:25:26 2020-5-6 06:27:26
3 49 2020-7-26 12:34:00 2020-7-26 12:36:00
3 50 2020-9-1 13:37:00 2020-9-1 13:38:00
3 52 2020-12-2 03:11:00 2020-12-2 03:13:00
4 16 2020-8-8 12:02:57 2020-8-8 12:03:00
4 23 2020-3-20 18:33:54 2020-3-20 18:35:00
5 1 2020-3-12 20:17:30 2020-3-12 20:19:30
5 1 2020-7-9 15:09:01 2020-7-9 15:11:01
5 11 2020-4-30 15:47:01 2020-5-1 15:49:01
5 12 2020-8-13 07:00:14 2020-8-14 07:02:14
5 12 2020-10-29 14:32:55 2020-10-29 14:33:55
5 13 2020-12-18 02:05:11 2020-12-19 02:07:11
5 14 2020-5-27 19:51:29 2020-5-28 19:53:29
5 15 2020-5-2 14:11:30 2020-5-3 14:13:30
5 15 2021-1-29 10:03:17 2021-1-30 10:05:17
5 16 2020-12-6 21:36:24 2020-12-7 21:39:24
5 17 2020-6-19 17:34:50 2020-6-20 17:36:50
5 18 2021-1-19 09:38:51 2021-1-19 09:40:00
5 20 2020-1-5 01:12:57 2020-1-5 01:14:00
5 32 2020-10-27 05:46:14 2020-10-27 05:48:00
5 43 2020-12-16 07:00:00 2020-12-16 07:02:00
5 44 2020-11-12 02:34:00 2020-11-12 00:00:00
5 46 2020-4-28 20:52:00 2020-4-28 20:53:00
6 7 2020-11-29 18:48:05 2020-11-29 18:51:00
6 13 2020-12-2 03:11:26 2020-12-2 03:13:00
6 19 2020-9-27 02:26:06 2020-9-27 02:28:00
6 50 2020-9-19 12:45:00 2020-9-19 12:47:00
7 10 2020-1-17 22:33:49 2020-1-17 22:35:00
7 12 2020-9-8 14:11:52 2020-9-8 14:13:00
7 16 2020-6-26 21:58:01 2020-6-26 21:59:01
7 18 2020-10-29 03:19:42 2020-10-29 03:21:00
7 19 2020-9-22 22:33:01 2020-9-22 22:35:01
7 45 2020-11-29 18:48:00 2020-11-29 18:51:00
8 2 2020-11-12 02:34:28 2020-11-12 00:00:00
8 3 2020-3-18 06:45:40 2020-3-18 06:47:40
8 13 2020-1-9 08:43:33 2020-1-9 08:45:00
8 16 2020-4-12 04:13:57 2020-4-12 04:15:00
8 17 2020-7-23 11:32:27 2020-7-23 11:36:27
8 47 2020-1-17 22:33:00 2020-1-17 22:35:00
8 50 2020-10-5 18:13:00 2020-10-5 18:15:00
9 36 2020-6-14 16:48:37 2020-6-14 16:50:00
9 51 2020-5-3 17:47:00 2020-5-3 17:49:00
9 51 2020-10-29 14:32:00 2020-10-29 14:33:00
10 19 2020-10-5 18:13:30 2020-10-5 18:15:30
10 28 2020-9-29 20:54:15 2020-9-29 20:56:00
10 42 2020-8-29 16:17:00 2020-8-29 16:19:00
10 48 2020-9-22 22:33:00 2020-9-22 22:35:00
11 22 2021-2-23 18:57:21 2021-2-23 18:59:21
11 27 2020-11-23 21:09:10 2020-11-23 21:11:00
11 50 2020-12-6 00:03:00 2020-12-6 00:05:00
12 2 2020-10-18 16:42:53 2020-10-18 16:44:00
12 12 2020-5-3 17:47:34 2020-5-3 17:49:00
12 12 2020-12-6 00:03:25 2020-12-6 00:05:00
12 27 2020-9-1 13:37:27 2020-9-1 13:38:27
12 51 2020-7-19 05:13:00 2020-7-19 05:15:00
14 13 2021-3-6 19:51:24 2021-3-7 19:53:24
14 24 2020-2-23 20:33:13 2020-2-23 20:35:00
14 24 2020-7-26 12:34:39 2020-7-26 12:36:39
14 32 2020-8-27 22:03:26 2020-8-27 22:05:00
14 39 2020-6-7 15:15:34 2020-6-7 15:17:00
14 42 2020-7-23 11:32:00 2020-7-23 11:36:00
15 13 2020-11-5 09:40:18 2020-11-5 09:41:00
15 26 2020-9-19 12:45:52 2020-9-19 12:47:00
15 36 2020-5-1 22:06:05 2020-5-1 22:08:00
15 39 2020-3-31 01:15:57 2020-3-31 01:17:57

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_PlayHistory.csv

HW2_Problem1_DataSet/HW2_Q1_Playlist.csv

playlistId playlistName uid createTime description
1 Classical Running 8 2020-12-21 20:50:02 Classical music for running
2 Summer Reading 13 2021-01-04 6:47:34 Soundtrack to your reading
3 Songs for Sleep 2 2020-10-03 15:48:25 Music for sleep. Sweet dreams

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_Playlist.csv

HW2_Problem1_DataSet/HW2_Q1_SongInAlbum.csv

sid albumId
2 3
3 3
4 3
5 3
6 3
7 3
8 3
9 3
10 3
11 1
12 1
13 1
14 1
15 1
16 1
17 1
19 4
20 4
21 4
22 4
23 4
24 4
25 4
26 4
27 4
28 4
29 5
30 5
31 5
32 5
33 5
34 5
35 5
36 5
37 5
38 2
39 2
40 2
41 6
42 6
43 6
44 6
45 6
46 6
47 6
48 6
49 6
50 6
51 6
52 6
53 7
54 7
55 7
56 7
57 7
58 7
59 7
60 7
61 7
62 7
63 7
64 7
65 7
66 7
67 7
68 8
69 8
70 8

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_SongInAlbum.csv

HW2_Problem1_DataSet/HW2_Q1_Album.csv

albumId albumName releaseTime
1 My World 2009-11-17
2 Big Deal 2020-08-12
3 Source 2020-08-12
4 Coming Home 1992-08-13
5 Laura Goes East 2020-09-04
6 Les sources 2018-11-16
7 No Walls Mixtape 2019-05-09
8 Paris 2020-05-21

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_Album.csv

HW2_Problem1_DataSet/HW2_Q1_Artist.csv

artistId artistName nationality
1 Nubya Garcia United Kingdom
2 Laura Fygi Dutch
3 Mark Poirier United States
4 Ludwig van Beethoven Germany
5 Faye Wong China
6 Justin Bieber Canada
7 Vanessa Paradis France
8 Ani DiFranco United States
9 Ben Harper United States

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_Artist.csv

HW2_Problem1_DataSet/HW2_Q1_SongInPlaylist.csv

sid playlistId addTime
26 1 2021-01-31 16:05:28
12 1 2021-01-25 07:30:17
20 1 2021-02-09 06:10:17
50 1 2021-01-10 08:26:02
26 2 2021-02-22 04:34:11
5 1 2021-03-08 00:07:31
24 1 2021-01-22 07:14:03
8 1 2021-01-25 22:31:34
21 1 2021-03-02 14:35:28
52 1 2021-01-07 11:33:35
52 2 2021-02-28 04:52:53
47 1 2021-02-21 11:35:30
33 1 2021-01-28 19:18:18
29 2 2021-02-23 14:41:06
47 2 2021-02-18 13:05:47
29 3 2021-02-24 06:21:14
1 1 2021-03-04 03:26:50
1 2 2021-02-02 14:12:02
33 2 2021-01-06 12:03:19
11 2 2021-02-09 04:01:11
34 2 2021-01-30 05:43:19
19 2 2021-01-23 06:16:00
52 3 2021-02-05 15:23:59
22 2 2021-01-06 19:40:58
14 2 2021-01-12 06:59:12
45 3 2021-03-04 15:45:41
14 3 2021-01-12 03:19:55
45 2 2021-01-22 20:59:04
13 3 2021-03-04 12:35:13
7 3 2021-01-17 23:39:30

__MACOSX/HW2_Problem1_DataSet/._HW2_Q1_SongInPlaylist.csv