Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    6

    Unanswered: mysql console error and help with normalisation please

    hello, im a new member and was wondering if you can help out?

    firstly, when i started playing with PHP, mysql and apache i used PHPdeveloper package and phpmyadmin, all was good until i started to use mysql administrator and query browser, when i tired to use them i had loads of error messages.

    I decided to remove developer - well lets just say i tired to - and decided to install mysql/apache and php one step at a time. All went well and my databse works and the scripts I do have will access and manipluate the database - cool well now i have an issue with the console - when i use phpdev it would actually let me run the console from the mysql/bin folder, now it comes up with a msg - ERROR 1045<28000>:ACCESS DENIED FOR USER 'ODBC'@' LOCALHOST'<USING PASSWORD: NO>
    console then disapears. - can anyone help me through this as i need the console to set my passwords as for some reason im getting errors in my php scripts when i set database passwords via mysql administrator - so i wanna give it a go via the console

    also im working on a web site that will allow user to advertise for accommodation and second hand items they are looking to sell.

    the attached file above contains my normalisation, im having a little trouble, can anyone help put where im going wrong?

    thanks guys for the help, hope to hear from anyone soon

  2. #2
    Join Date
    Nov 2004
    Posts
    6
    ok here is the file
    Attached Files Attached Files

  3. #3
    Join Date
    Nov 2004
    Posts
    6
    ok i have no more errors with accessing console i was doing it wrong but can anyone take a look at my database normalisation?

  4. #4
    Join Date
    Nov 2004
    Posts
    6
    ok guys dont know if you are worried of course to open my file maybe so here it is, where am i going wrong? or is it ok for the database to go ahead

    0NF

    Username
    Password
    Name_first
    Name_last
    Age
    Course_name
    Current_academic_year
    Nationality
    Email_address
    Bills
    Utilities
    Cost
    Image
    Additional_information
    Contact_details
    Rooms_available
    General_location
    Description
    General_location


    1NF

    User_Table
    Username (P)
    Name_first
    Name_last
    Password
    Age
    Course_name
    Current_academic_year
    Nationality
    Email_address

    User_Advert_Table
    Advert_ID (P)
    Username (F)
    Title
    Advert_Type
    Contact_details

    Accommodation_Ad_Table
    Advert_ID (P) (F)
    Rooms_available
    Additonal_Information
    General_location
    Cost_per_week
    Bills_Payable
    Utilities
    A_Image

    Classified_Ad_Table
    Advert_ID (P) (F)
    Description
    C_Image
    Item_Price


    2NF

    User_Table
    Username (P)
    Name_first
    Name_last
    Password
    Age
    Course_name
    Current_academic_year
    Nationality
    Email_address

    User_Advert_Table
    Advert_ID (P)
    Username (F)
    Title
    Advert_Type_ID (F)
    Contact_details

    Accommodation_Ad_Table
    Advert_ID (P) (F)
    Rooms_available
    Additonal_Information
    General_location
    Cost_per_week
    A_Image

    Classified_Ad_Table
    Advert_ID (P) (F)
    Description
    C_Image
    Item_Price

    Advert_Type_Table
    Advert_type_ID (P)
    advert

    Bills_Payable_Table
    Advert_ID (F)
    Bill

    Utilities_Table
    Advert_ID (F)
    Utility

  5. #5
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    Hey, i don't see any problem with your design. BTW can you explain what is your problem with the design
    Sudar

    --
    My Blog

  6. #6
    Join Date
    Nov 2004
    Posts
    6
    yeah its ok, sweet
    thanks dudes

Posting Permissions

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