Jump to content
Forums are read-only ×
Larry Ullman's Book Forums

CalebCurry

Members
 View Profile  See their activity

  • Posts

    6

  • Joined

  • Last visited

 Content Type 

Everything posted by CalebCurry

  1. CalebCurry
    Thank you so much everybody, I'd like to let you know that you helped me a lot. I understand what you mean with the main genre, and also why enum is not recommended. THANKS!
  2. CalebCurry
    I guess my main question is this, When should you use ENUM, and when should you Make more tables instead?? Thanks for the help so far.
  3. CalebCurry
    I really need to know why ENUM or SET are bad options... Do you have the ability to explain farther why they are a bad choice? In the book I see Larry use it for male or female, but then again, those won't ever change, or anything. For your 4th option, do you mean like this? Song table - song ID, name, genre. genre table - genre name song genres table - Song ID, Genre ID. to allow for a main genre and also some extras? if not can you clarify?
  4. CalebCurry
    Let's say I have a database for music. it has an ID, the name of the song, and all that other information, and then it has style. (such as rock, rap, country...) Would it be best to: 1. make a table of available styles and link it to the table with a foreign key, 2. make a table for styles and a table for music, and have an intermediary table listing all the styles for each song (to allow for multiple styles) 3. Use the SET or ENUM datatype to allow for specific choices. Please explain why. Thank you!
  5. CalebCurry
    Yes, Thank you so much!!! I want to make an indepth database for my books and I was so confused about it. Is there anything else I should do to the database for easier use?
  6. CalebCurry
    How does This table allow for multiple authors for one book? if it doesn't pleae tell me how to implement it. (page 176, chapter 6 - normalization) PUBLISHERS publisher id name address1 address2 city state zip BOOKS book_id publisher ID title BOOKS AUTHORS book_id Author_id AUTHORS author_id author I'm not sure how everything ties together,...please explain it more. why doesn't BOOKS reference to author? like if you were searching it...shouldn't the author be a foreign key so it's in the books table?? also, why are all the ids with an underscore except publisher id? I'm not sure if that matters.
×
×
  • Create New...