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. Artist artist_id name Album album_id title artist_id Genre genre_id name Track track_id title rating len count album_id genre_id What to Hand in For this assignment you will hand in: 1. Screen shot (JPG or PNG) of data in the Track table 2. Screen shot (JPG or PNG) of all the data joined up sorted in ascending order by the album title 3. Screen shot (JPG or PNG) of all of the genres for a particular artist. Hint - use JOIN, DISTINCT and WHERE
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. Artist artist_id name Album album_id title artist_id Genre genre_id name Track track_id title rating len count album_id genre_id What to Hand in For this assignment you will hand in: 1. Screen shot (JPG or PNG) of data in the Track table 2. Screen shot (JPG or PNG) of all the data joined up sorted in ascending order by the album title 3. Screen shot (JPG or PNG) of all of the genres for a particular artist. Hint - use JOIN, DISTINCT and WHERE
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Big Data
Section: Chapter Questions
Problem 4PSE
Related questions
Question
Question: Building a Multi-Table DB with Relationships
(Include the tables creation query)
(Include the tables creation query)
(Include the tables creation query)
In this assignment, you will build a copy of the "Music"
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning