| blob | ba002af947dde0bbfe3b28f81b4efc1ca8cc79f1 |
1 DROP TABLE ALBUM;
2 DROP TABLE ARTIST;
3 DROP TABLE LABEL;
5 DROP SEQUENCE SQ_ARTIST;
6 DROP SEQUENCE SQ_ALBUM;
7 DROP SEQUENCE SQ_LABEL;
10 CREATE TABLE ARTIST (
11 AID NUMBER NOT NULL,
12 NAME VARCHAR2(200) NOT NULL,
13 COUNTRY VARCHAR2(200),
14 INFO VARCHAR2(2000),
15 CONSTRAINT ARTIST_PK PRIMARY KEY (AID)
16 );
18 CREATE TABLE LABEL (
19 LID NUMBER NOT NULL,
20 MAJOR NUMBER,
21 NAME VARCHAR2(200) NOT NULL,
22 LOGO VARCHAR2(200),
23 INFO VARCHAR2(2000),
24 CONSTRAINT LABEL_PK PRIMARY KEY (LID),
25 CONSTRAINT LABEL_LABEL_FK FOREIGN KEY (MAJOR) REFERENCES LABEL (LID) ON DELETE CASCADE
26 );
29 CREATE TABLE ALBUM (
30 ALID NUMBER NOT NULL,
31 NAME VARCHAR2(200) NOT NULL,
32 TYPE VARCHAR2(100) NOT NULL,
33 RELEASE DATE NOT NULL,
34 GENRE VARCHAR2(500),
35 COVER VARCHAR2(200),
36 REVIEW VARCHAR2(2000),
37 ART NUMBER,
38 LBL NUMBER,
39 CONSTRAINT ALBUM_PK PRIMARY KEY (ALID),
40 CONSTRAINT ALBUM_ARTIST_FK FOREIGN KEY (ART) REFERENCES ARTIST (AID),
41 CONSTRAINT ALBUM_LABEL_FK FOREIGN KEY (LBL) REFERENCES LABEL (LID)
42 );
44 CREATE SEQUENCE SQ_ARTIST
45 MINVALUE 1
46 MAXVALUE 10000
47 START WITH 1
48 INCREMENT BY 1;
50 CREATE SEQUENCE SQ_ALBUM
51 MINVALUE 1
52 MAXVALUE 10000
53 START WITH 1
54 INCREMENT BY 1;
56 CREATE SEQUENCE SQ_LABEL
57 MINVALUE 1
58 MAXVALUE 10000
59 START WITH 1
60 INCREMENT BY 1;
62 INSERT INTO ARTIST VALUES(SQ_ARTIST.nextval, 'Arctic Monkeys', 'England', 'Arctic Monkeys are an English indie rock band from High Green, a suburb of Sheffield, England. Formed in 2002, the band currently consists of Alex Turner, Jamie Cook, Nick O''Malley, Matt Helders and John Ashton.');
63 INSERT INTO ARTIST VALUES(SQ_ARTIST.nextval, 'Razorlight', 'England', 'Razorlight is an English-Swedish indie rock band formed in 2002. They are primarily known in their home countries, having topped the charts with the 2006 single "America" and its parent self-titled album, their second. The band consists of lead singer and rhythmic guitarist Johnny Borrell, guitarist Björn Ågren, bass guitarist Carl Gustaf Dalemo and drummer David Sullivan-Kaplan.');
64 INSERT INTO ARTIST VALUES(SQ_ARTIST.nextval, 'The Kooks', 'England', 'The Kooks are an English indie rock band formed in Brighton, East Sussex, in 2004.[1] Formed by Luke Pritchard (vocals/guitar), Hugh Harris (lead guitar), Paul Garred (drums), and Max Rafferty (bass guitar), the lineup of the band remained constant until 2008 and the departure of Rafferty. Dan Logan was drafted in as a temporary replacement, until Peter Denton joined the band on a permanent basis in October 2008.');
65 INSERT INTO ARTIST VALUES(SQ_ARTIST.nextval, 'The Fratellis', 'Scotland', 'The Fratellis are a Scottish alternative rock band from Glasgow, Scotland. The band consists of lead vocalist and guitarist Jon Fratelli (born John Lawler), bass guitarist Barry Fratelli (born Barry Wallace), and drummer, backing vocalist, occasional guitarist and banjo player Mince Fratelli (born Gordon McRory). During live shows, they are assisted by pianist/rhythm guitarist, Will Foster.');
66 INSERT INTO ARTIST VALUES(SQ_ARTIST.nextval, 'Muse', 'England', 'Muse are an English rock band from Teignmouth, Devon. Since their inception, the band has been composed of Matthew Bellamy (lead vocals, guitar, piano), Christopher Wolstenholme (bass, backing vocals), and Dominic Howard (drums and percussion). Muse are known for their energetic and extravagant live performances and their fusion of many music genres, including progressive rock, classical music, heavy metal and electronica.');
67 INSERT INTO ARTIST VALUES(SQ_ARTIST.nextval, 'Franz Ferdinand', 'Scotland', 'Franz Ferdinand are a Scottish rock band that formed in Glasgow, Scotland, in 2002. The band is composed of Alex Kapranos (lead vocals and guitar), Bob Hardy (bass guitar), Nick McCarthy (rhythm guitar, keyboards and backing vocals) and Paul Thomson (drums, percussion and backing vocals).');
69 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, NULL, 'Sony Music Entertainment', 'sony','Sony BMG Music Entertainment was a global recorded music company, which was a 50–50 joint venture between the Sony Corporation of America and Bertelsmann AG. The venture’s successor, the again-active Sony Music Entertainment, is 100% owned by the Sony Corporation of America.');
70 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, NULL, 'EMI', 'emi','The EMI Group (Electric Musical Industries Ltd.) is a British music company. It is the fourth-largest business group and family of record labels in the recording industry, making it one of the "big four" record companies and a member of the RIAA. EMI Group also has a major publishing arm - EMI Music Publishing - based in New York City. The company was once a constituent of the FTSE 100 Index but is now wholly owned by Terra Firma Capital Partners.');
71 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, NULL, 'Warner Music Group', 'warner','Warner Music Group is the third-largest business group and family of record labels in the recording industry, making it one of the big four record companies. The current incarnation of the company was formed in 2004 when it was spun off from Time Warner, and as a result, Time Warner no longer retains any ownership. Warner Music Group also has a music publishing arm called Warner/Chappell Music, which is currently one of the worlds largest music-publishing companies.');
72 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, NULL, 'Universal Music Group', 'universal','Universal Music Group (UMG) is the largest business group and family of record labels in the recording industry. It is the largest of the "big four" record companies by its commanding market share and its multitude of global operations. Universal Music Group is a wholly owned subsidiary of international french media conglomerate Vivendi.Universal Music Group owns a music publisher, Universal Music Publishing Group, which became the worlds largest following the acquisition of BMG Music Publishing in May 2007.');
73 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, NULL, 'Indie labels', 'indie','indielabel');
74 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, 1, 'Columbia/Epic Label Group', 'columbia','Universal Music Group (UMG) is the largest business group and family of record labels in the recording industry. It is the largest of the "big four" record companies by its commanding market share and its multitude of global operations. Universal Music Group is a wholly owned subsidiary of international french media conglomerate Vivendi.Universal Music Group owns a music publisher, Universal Music Publishing Group, which became the worlds largest following the acquisition of BMG Music Publishing in May 2007.');
75 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, 1, 'RCA/Jive Label Group', 'rca','RCA Records (originally The Victor Talking Machine Company, then RCA Victor) is one of the flagship labels of Sony Music Entertainment. The RCA initials stand for Radio Corporation of America (later renamed RCA Corporation), which was the parent corporation from 1929[1] to 1983 and a partner from 1983 to 1986.');
76 INSERT INTO LABEL VALUES (SQ_LABEL.nextval, 5, 'Domino Records', 'domino','Domino Recording Company, generally known as Domino Records, is an independent record label based in London. There is also a wing of the label based in United States, releasing Domino artists music from the labels Brooklyn offices and run by Kris Gillespie. In addition, Stephen Pastel presides over the subsidiary label Geographic Music, which releases more unusual British and World music.');
78 INSERT INTO ALBUM VALUES (SQ_ALBUM.nextval, 'Hamburg', 'cd', TO_DATE('24/08/2009','dd/mm/yyyy'),'rock','am_hamburg','Critical response to the album was extremely positive with a Metacritic rating of 82 and featuring highly in many year-end lists and being hailed as a modern classic. Many critics and figures in the British Media hyped the Arctic Monkeys and their rapid rise to acclaim through unconventional means and some even cited the Arctic Monkeys as revolutionising the way people find music as they built a fanbase on the basis of a few demos shared by fans through the internet. NME declared them Our Generations Most Important Band and Alex Turners lyrics and depiction of Sheffield and the night lives of teenagers in particular praised with him being labelled as a master of observation and USA Today claiming you probably wont hear better CD all year long and calling it utterly infectious. MusicOMH wrote that it was the sort of guitar rock that makes you fall in love with music all over again and along with many other critics cited A Certain Romance as the standout track and as being a wonderfully articulate dissection of youth culture that belies Turners tender years. It was however, noted that some of the tracks which had previously been released on the internet as demos had lost some of their quality and dont sound as good.', 6, 8);
79 INSERT INTO ALBUM VALUES (SQ_ALBUM.nextval, 'Franz Ferdinand', 'cd', TO_DATE('09/01/2004','dd/mm/yyyy'),'indie rock','http://cover.jpg','Franz Ferdinand received universal critical acclaim. The NME said that the band was the latest in the line of art school rock bands featuring The Beatles, The Rolling Stones, The Who, Duran Duran, Roxy Music, the Sex Pistols, Wire and Blur. It rated the album as 9 out of 10 and said: This album is the latest and most intoxicating example of the wonderful pushing its way up between the ugly slabs of Pop Idol, nu metal and Britons aping American bands. What these blossoming bands have in common is the absolute conviction that rock n roll is more than a career option.', 1, 8);
80 INSERT INTO ALBUM VALUES (SQ_ALBUM.nextval, 'Showbiz', 'cd', TO_DATE('04/10/1999','dd/mm/yyyy'),'alternative rock','http://cover.jpg','Showbiz is the debut studio album by English alternative rock band Muse, released in the United Kingdom on 4 October 1999. Recorded between April and May at RAK Studios and Sawmills Studio, respectively, the album was produced by John Leckie and Paul Reeve in conjunction with the band. Showbiz was a minor commercial success, reaching number 29 on the UK Albums Chart.', 5, 2);
82 commit;