oobbles / 06-23-fania Goto Github PK

https://github.com/oobbles/06-23-fania

What tables will your application need? albums, styles, artists, albums_styles, albums_artists
What are the schemas (names and types of columns) for each table? See below
What are the relationships between your application's data entities? See below
Which columns in your tables are foreign keys? album_id, style_id and artist_id in the lookup tables

Fetch all artists with a given style

Fetch and read artist records

Create artist records (heh heh)

Delete artsit records

Integrated a gem in to the Fania App

Method to enter an album (id, title, year) while also dealing with entering its associated artists and styles. Must also make the appropriate entries in to the lookup tables.

Read / update / delete albums.
Create Albums is a separate issue.

Delete an artist or style without first ensuring that it has no albums assigned to it.

Edit artist records

Fetch all albums with a given style

• Be able to create an album that doesn't have a year, at least one style and at least one artist.
• Have a given single album repeated in the albums table.

Fetch all artists on a given album

Create / update / delete styles

This is for the Artist Class. View only supports listing of Artist and finding associated albums for that artist. Artist.rb contains methods to do other things, but my plan is to only allow the user to enter a full album entry (album, year, artist(s) and style(s)) not individual artists.

Fetch all albums with a given artist