Closed Agent-Banks closed 4 years ago
https://github.com/codyb23/SuncoastBands
Hello Gavin, I really enjoyed making this program. If we could schedule a time sometime this week where you can point me in the right direction for some code refactoring I would greatly appreciate it! I would like to try Adventure mode with a nice well-structured program. Thank you!
Your homework 03 - 03 - Rhythm's gonna get you was marked: Meets Expectations
“Well done!”
I'm very impressed by how your code and style are developing. Keep up the effort!
These two lines should go inside your while
loop so the related queries are re-run each time.
I would love to spend some time with you refactoring. My first suggestion is to see what happens if you try to make individual methods for each of your menu items. That is:
if (option == 2)
{
AddBand();
}
See what that style change implies for the structure of your code. See if you can get the code to that point and then let's talk about refactoring from there!
Find me in some 4-5pm lab time and we'll take some time to look at it.
Rhythm's gonna get you
For this project, we will model and create a database. We are starting a record label company, and we a place to store our bands, albums, and eventually songs. You are creating a console app that stores our information in a database.
Objectives
Setup
Create a console that allows a user to store and manage the company's bands, albums, and (eventually) songs.
Top Tips
Although in reality an album could be done by more than one band, our system will just have an album involving one band. That is, an album belongs to one band.
Explorer Mode
[x] Create a database that stores
Albums
, andBands
. They should have the following properties, use your best judgment for types. (We will add foreign keys in the next step)[x] Album
Id
Title
IsExplicit
ReleaseDate
[x] Band
Id
Name
CountryOfOrigin
NumberOfMembers
Website
Style
IsSigned
ContactName
ContactPhoneNumber
Add foreign keys to fulfill the following
[x] One Band has many Albums
[x] Create an interface to let the user:
[x] Add a new band
[x] View all the bands
[x] Add an album for a band
[x] Let a band go (update isSigned to false)
[x] Resign a band (update isSigned to true)
[x] Prompt for a band name and view all their albums
[x] View all albums ordered by ReleaseDate
[x] View all bands that are signed
[x] View all bands that are not signed
Adventure Mode
[ ] Add the ability for an album to have many songs. NOTE a song will only belong to a single album. Even if the same-named song appears on different albums we'd have a second entry for it.
[ ] Song
Id
Title
Lyrics
Length
Genre
[ ] Track the individual members of a band. Create a new table called
Musicians
and give it a many to many relationships with a BandAdd the following queries
Epic Mode
Additional Resources