I 320D
Document the Music Festival Database Design
Skip To Content
Dashboard
  • Login
  • Dashboard
  • Calendar
  • Inbox
  • History
  • Help
Close
  • My Dashboard
  • I 320D
  • Assignments
  • Document the Music Festival Database Design
Fall 2022
  • Home
  • Syllabus
  • Assignments
  • Zoom
  • Lectures Online
  • Course Evaluations
  • NameCoach
  • UT Simple Syllabus
  • My Textbooks
  • Panopto Video

Document the Music Festival Database Design

  • Due Oct 10, 2022 by 11:59pm
  • Points 10
  • Submitting a file upload
  • File Types pdf

Your task is to document the music_festival.festival schema that is available via Superset on the server.

Recall that a database design for our course has four parts:

  1. Sample data, together with a crossing lines diagram.
  2. The Conceptual ER diagram
  3. The physical ER diagram
  4. The table sketches.

For this assignment you will work backwards, starting with the data in the database, then creating parts 1, 2 and 3 of the design.

Go to https://superset.dei320.net/superset/sqllab/ Links to an external site. and log in.  Then in the drop downs on the left choose the "music_festival" database and the "festival" schema, like this:

music_festival_in_superset.png

Then select each of those tables, so that the previews are available. Like this:

music_festival_with_previews.png

 

My screenshot shows the performances table. You can see the venue_id and band_id columns, which must be foreign keys. You can then draw part of the physical ER diagram, showing performances, bands, and venues and connecting with the crowsfeet lines in appropriate places. Continue inspecting the tables locating foreign keys and drawing both of the ER diagrams.  You should end up with six entities in both diagrams. For concrete data and crossing lines diagrams (part 1) you need only show data about two people making two purchases of 2 tickets each to see 2 different shows.

You can work with paper and pen (take a photo and convert that to PDF to submit), or you can work with programs like draw.io, Lucidchart, Miro, or Vizio. Submit a 1 page PDF.

1665464399 10/10/2022 11:59pm
Please include a description
Additional Comments:
Rating max score to > pts
Please include a rating title

Rubric

Find Rubric
Please include a title
Find a Rubric
Title
You've already rated students with this rubric. Any major changes could affect their assessment results.
 
 
 
 
 
 
 
     
Can't change a rubric once you've started using it.  
Title
Criteria Ratings Pts
This criterion is linked to a Learning Outcome Description of criterion
threshold: 5 pts
Edit criterion description Delete criterion row
5 to >0 pts Full Marks blank
0 to >0 pts No Marks blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
  / 5 pts
--
Additional Comments
This criterion is linked to a Learning Outcome Description of criterion
threshold: 5 pts
Edit criterion description Delete criterion row
5 to >0 pts Full Marks blank
0 to >0 pts No Marks blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
  / 5 pts
--
Additional Comments
Total Points: 5 out of 5