Your new client has a collection of original music recordings in digital formats

Question

Your new client has a collection of original music recordings in digital formats that he wants to store in his Oracle 10g database. He plans to give online customers the ability to select songs and assemble a customized CD that is then printed and mailed to them. Your job is to create the table to store the music. The client wants to use software other than Oracle 10g to update the music. Therefore, the music must reside in AUD format in a file that can be viewed by the database. (AUD format is a format used especially for music that can be played on the Internet or printed on a CD and played on a stereo like any music CD.) Create another table named CH07SONGLIST that is used to assemble the customer's song list. This table should have the customer's name and address, CD name (the customer fills this in online, and it can be up to 40 characters long), and a list of song ID numbers (up to 15 songs). Once again. you find a collection appropriate for the list of songs in the Scheme Manager.

Explanation / Answer

prompt CREATE TABLE ch07song
prompt (song_id   NUMBER,
prompt artist_name   VARCHAR2(30),
prompt song_title   VARCHAR2(30),
prompt song_length   NUMBER(4,2),
prompt song       bfile);
CREATE TABLE ch07song
(song_id   NUMBER,
artist_name   VARCHAR2(30),
song_title   VARCHAR2(30),
song_length   NUMBER(4,2),
song       bfile);

prompt *****************************************************************************
prompt *****************************************************************************
prompt Music Table stuff, create table ch07songlist
prompt *****************************************************************************
prompt *****************************************************************************
prompt CREATE TABLE ch07songlist
prompt (customer_name   VARCHAR2(40),
prompt street_addr   VARCHAR2(40),
prompt city       VARCHAR2(30),
prompt state       VARCHAR2(2),
prompt zip       VARCHAR2(10),
prompt cd_name        VARCHAR2(40),
prompt songlist   classmate.chosensong);

CREATE TABLE ch07songlist
(customer_name   VARCHAR2(40),
street_addr   VARCHAR2(40),
city       VARCHAR2(30),
state       VARCHAR2(2),
zip       VARCHAR2(10),
cd_name        VARCHAR2(40),
songlist   classmate.chosensong);
prompt *****************************************************************************

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.