View the step-by-step solution to:

png" file, must copy the text in "Tim Stern Database Project 1.txt" file and copy in to sql+ and that will give you the database to use.

the questions are the "next assignment.png" file, must copy the text in "Tim Stern Database Project 1.txt" file and copy in to sql+ and that will give you the database to use.

Background image of page 1
Tim Stern Database Project 1 Question 1: Short Narrative of Database My database is TimzTunes. Hold data of music artist; track names, album names etc. And to show how many times ive played them (hopefullyf). ________________________________________________________________________________ ________________________________________________________________________________ ___________________________________________________________________ Question 2: Develop an Entity Relationship Diagram sent as pdf file ________________________________________________________________________________ ________________________________________________________________________________ __________________________________________________________________ Question 3: Develop schema of entire database sent as different file ________________________________________________________________________________ ________________________________________________________________________________ ______________________________________________________________________ Question 4: Determine the appropriate constraints for all Fields in All tables Artist Table: Artist_Id (pk) number(5) Artist_Name (UK) varchar2(20) Years_Active number(2) Album Table: Album_Name (UK) varchar2(25) Album_ID (PK) number (5) Artist_ID (FK) number (5) to Artist table Release_Date DATE DEFAULT SYSDATE Genre_Id number(20) (fk) to Genres table Track Table: Track_ID (pk) number (5) Track_Name Varchar2(25) (not null) Album_Id (fk) number(5) to Albums table Genre Table: Genre_Id (pk) number(20) Genre_Name (Not Null) varchar2(20) ________________________________________________________________________________ ________________________________________________________________________________ __________ Question 5: Determine the appropriate column definition for each field in each table. Above (Im Lost on that question) ________________________________________________________________________________ ________________________________________________________________________________ __________ Question 6: Write the sql scripts to create three tables. SQL> create table Artists 2 (artist_id number(5), 3 artist_name varchar2(25) not null, 4 constraint artists_artist_id_pk primary key (artist_id),
Background image of page 1
5 constraint artists_artist_name_uk unique (artist_name)); SQL> create table albums 2 (Album_name varchar2(25), 3 artist_id number(5), 4 album_id number(5) not null, 5 album_release_date date default sysdate, 6 constraint albums_album_id_pk primary key (album_id), 7 constraint albums_artist_id_fk foreign key (artist_id) 8 references artists (artist_id)); SQL> create table Track 2 (track_id number(5), 3 track_name varchar2(20), 4 artist_id number(5), 5 album_id number(5), 6 constraint track_track_id_pk primary key (track_id), 7 constraint track_artist_id_fk foreign key (artist_id) 8 references artists (artist_id), 9 constraint track_album_id_fk foreign key (album_id) 10 references albums (album_id)); ________________________________________________________________________________ ________________________________________________________________________________ _____________ Question 7: Build your tables in oracle SQL> create table Artists 2 (artist_id number(5), 3 artist_name varchar2(25) not null, 4 constraint artists_artist_id_pk primary key (artist_id), 5 constraint artists_artist_name_uk unique (artist_name)); Table created. SQL> create table albums 2 (Album_name varchar2(25), 3 artist_id number(5), 4 album_id number(5) not null, 5 album_release_date date default sysdate, 6 constraint albums_album_id_pk primary key (album_id), 7 constraint albums_artist_id_fk foreign key (artist_id) 8 references artists (artist_id)); Table created. SQL> create table Track 2 (track_id number(5), 3 track_name varchar2(20), 4 artist_id number(5), 5 album_id number(5), 6 constraint track_track_id_pk primary key (track_id), 7 constraint track_artist_id_fk foreign key (artist_id) 8 references artists (artist_id), 9 constraint track_album_id_fk foreign key (album_id) 10 references albums (album_id)); Table created. SQL> desc artists Name Null? Type
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

I did all queries in notepad, you can check at your own database. Also check what... View the full answer

sql.txt

Ans1. SELECT albums.Album_name, Track.track_name, Artists.artist_name FROM (Artists INNER JOIN albums ON Artists.artist_id = albums.artist_id) INNER JOIN Track ON (Artists.artist_id =...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online