Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Join Date
    Mar 2008
    Posts
    6

    Help?? New guy... need some help.

    This might sound kinda crazy but i'm sure a pro could do this in a matter of 20 minutes, if someone is willing to help me out I need help with the following project.

    -Zip Williams


    What I need is to normalize the following..

    FIRE_REPORT(FireID,Alarms,Address,FiremanID,Firema nName,FiremanPhone,FiremanHomeStation,
    StationAddress,StationPhone,TruckID,License,TruckH omeStation)

    Some assumptions

    Each fire can have several firefighters assigned to it
    each fire can have several fire trucks assigned to it
    each firefighter can be assigned to several fires
    each firetruck can be assigned to several fires
    each firefighter has a unique home station
    Each fire truck has a unique home station
    each station name is unique
    each station has a unique phone number

    -Write SQL create table statments for the normalization
    -Write SQL statements to insert two records into each table (with made up data)
    -Write SQL statements for the following..

    *Display StationName and StationPhone for all stations located on BroadStreet
    *Display FireID and adress for all 3,4,5 alarm fires
    Display alarms and how many fires have been fought for each type of output
    *Display FiremanID, FiremanHomeStation, and phone number of the station for all firefighters whose phone number has a 703 area code.
    Add a column with the date of the fire to the appropriate relation. Then, insert the actual dates into your records.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    homework alert!!!!

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2008
    Posts
    6
    blame canada.

  4. #4
    Join Date
    Mar 2008
    Posts
    6
    Im willing to pay... contact me @ zipwirebe@gmail.com I need it tonight.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oh, man, that is so sad

    and you are ~way~ low with your 20 minute estimate
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Mar 2008
    Posts
    6
    bah you've got nothing better to do but to chat with me on a database forum, i'm not impressed either.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i've got tons o' things better to do but chat on database forums

    for instance, i am now going to catch some zeds (in canada we say zeds, perhaps you know it as zees)

    thanks goodness ~i~ don't have a homework assignment due tomorrow

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by Zipwirebe
    Im willing to pay... contact me @ zipwirebe@gmail.com I need it tonight.
    Nice. You are cheating, and you posted your email on the forum.
    Brilliant.
    And now some jackass has quoted you in his own post, and there is no way you can edit the post and delete your e-mail. That must really suck.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Aug 2003
    Location
    Toronto, Ontario, Canada
    Posts
    203
    Not to mention the amount of spam that'll be sent to that gmail address... I suspect it'll have to be closed in a couple of days and a new address set up.
    When it rains, it pours.

  10. #10
    Join Date
    May 2005
    Location
    San Antonio, Texas
    Posts
    134
    can I get paid even if I give bad information?

    you won't know right?
    Vi veri veniversum vivus vici
    By the power of truth, I, a living man, have conquered the universe

  11. #11
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Is the offer still open? I could use the cash this month
    George
    Home | Blog

  12. #12
    Join Date
    Mar 2008
    Posts
    6
    you're all idiots.. atleast you guys think you're funny.

  13. #13
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    well, i can see how you wouldn't

    how'd that assignment work out for you?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  14. #14
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Quote Originally Posted by Zipwirebe
    you're all idiots.. atleast you guys think you're funny.
    That's not all. We think you're funny too.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  15. #15
    Join Date
    Mar 2008
    Posts
    6
    I think your hilarious, not to mention how green with envy I get when I found out you are part of the Delaware Youth Chess Club. Be sure to be on time on for the next meeting. Pocket Protector optional.

    The club meets every Sunday from 2:00 to 4:00 pm at the Delaware County District Library. Participation is free. Dont even have to pay for all that excitment.

Posting Permissions

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