Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    It seems so simple (ACC97-SR2)

    As an extra-curricular project I am building a music database that lists songs, players, vocal capacity and instruments performed per song.

    I'm having difficulty constructing the appropriate forms.
    Ideally, It should:

    List each song (with new ones to be entered)
    Show each player performing in the song-(I'm thinking Option Groups here)
    Show the instrument of each player
    indicate if they are singing the lead.
    indicate if they can do back-up vocals.
    indicate which of 3 ranges (Hi-Mid-Low) they will be singing

    Many of the players can play multiple instruments (but not on 1 song
    There can be more than 1 lead vocal per song.

    This will be my first NORMALIZED database, so getting this form done the correct way will help me tremendously in the future.
    If you've got the extra time, and it seems intriguing, I'd appreciate the assist. <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>

  2. #2
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: It seems so simple (ACC97-SR2)

    Nevermind...That was a lot easier than it seemed, actually.
    In my obsession with 'keeping it small, I forgot functionality.

    Sometimes you just micro-manage your way into a corner. <img src=/S/toilet.gif border=0 alt=toilet width=24 height=26>

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: It seems so simple (ACC97-SR2)

    I hope that you realized that you need a Song table, a Performer table, and an Instruments table. There would be a one-to-many relationship between the Song table and the Performer table, and a one-to-many relationship between the Performer table and the Instruments table. That is, if you want a normalized database.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •