Question: Building a Multi-Table DB with RelationshipsIn this assignment, you will build a copy of the "Music" database covered in lecture. You will populate your database with tracks, artists, albums and genres that are different from the ones used in class. You must include three artists, five albums, and 20 tracks in your data. Choose a genre for each track. Your tables need to normalized as described in class.Then you must construct and run some queries on your data and then take screen shots of those queries and submit the screen shots as your assignment. Sample Screen ShotsphpMyAdminde(Recent tables)...Newimportedinformation_schema6-miscmijsmmommorpsmoodleMusicNewAlbumArtistGenreTrackmysqlPeopleperformance_schemapr4eFrestrest demosakai10sakai11tsugi由izapphpMyAdmin公园日 3(Recent tables)...Newimportedinformation_schema.miscmijsmmorpsmoodleMusicNewAlbumArtistGenreSonTrackmysqlPeopleperformance_schemapr4erestrest demosakai10sakai11tsugizap#Table: Track+ Server: localhost:8889» Database: Music »Browse Structure SQL O Search Insert Export Import✔Showing rows 0-3 (4 total, Query took 0.0003 sec)SELECT FROM "TrackNumber of rows: 25 #Sort by key: None+ OptionsSET FOR TOMTO nutink+ OptionsnamenameLed Zepplin RockT→O EditCopy X DeleteEditCopy X DeleteCopy X DeleteCopy X DeleteEditEditto Check All0ONumber of rows: 25Artist.name = 'Led Zepplin'+ OptionsNumber of rows: 25 ++titleAbout to RockWho Made WhoBlack DogStairway+With selected:Number of rows: 25 +track_idProfiling [Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]-Query results operationsPrint view Print view (with full texts) Export Display chart Create viewtitle1 Black Dog2 Stairway3 About to Rock4 Who Made WhoChange X DeleteShowing rows 0 - 0 (1 total, Query took 0.0004 sec)Server: localhost:8889 » Database: Music »Table: TrackBrowse Structure SQL Search Insert Export Import ✓ MoretitlenameAC/DCAC/DCWho Made WhoWho Made WhoLed Zepplin IVLed Zepplin IVlen rating count album_id297482313207ExportShow query boxCurrent selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete featuresare not available.✓ Showing rows 0-3 (4 total, Query took 0.0004 sec)select Track.title, Artist.name, Album.title, Genre.name from Track join Genre join Album join Artist onTrack.genre_id = Genre.genre_id and Track.album_id= Album.album_id and Album.artist_id = Artist.artist_idProfiling [Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]nameMetalMetalRockRock5555Number of rows:25 +-Query results operationsPrint view Print view (with full texts) Export Display chartCreate viewServer: localhost:8889 »Database: Music » Table: TrackBrowse Structure SQL Search Insert Export Import ✓ More0000MoreShow query boxCurrent selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Deletefeatures are not available.Number of rows: 25 +-Query results operationsPrint view Print view (with full texts) Export Display chartCanna nama PDOK SAL TOTH Alhum TOTE CARna ТАТМ2211genre_idCreate view1122Antint 111 m.album_idHEREProfiling [Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]Ā Question: Building a Multi-Table DB with RelationshipsIn this assignment, you will build a copy of the "Music" database covered inlecture. You will populate your database with tracks, artists, albums andgenres that are different from the ones used in class. You must include threeartists, five albums, and 20 tracks in your data. Choose a genre for eachtrack. Your tables need to normalized as described in class.Then you must construct and run some queries on your data and then takescreen shots of those queries and submit the screen shots as yourassignment.Artistartist_idnameAlbumalbum_idtitleartist_idGenregenre_idnameTracktrack_idtitleratinglencountalbum_idgenre_idWhat to Hand inFor this assignment you will hand in:1. Screen shot (JPG or PNG) of data in the Track table2. Screen shot (JPG or PNG) of all the data joined up sorted inascending order by the album title3. Screen shot (JPG or PNG) of all of the genres for a particular artist.Hint - use JOIN, DISTINCT and WHERE

1. Query to display all the data from the Track table: SELECT * FROM Track; Output of sample data:

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Question: Building a Multi-Table DB with Relationships

In this assignment, you will build a copy of the "Music" database covered in lecture. You will populate your database with tracks, artists, albums and genres that are different from the ones used in class. You must include three artists, five albums, and 20 tracks in your data. Choose a genre for each track. Your tables need to normalized as described in class.

Then you must construct and run some queries on your data and then take screen shots of those queries and submit the screen shots as your assignment.