Help required towards MYSQL project :(

by satz27
11 replies
This might find you silly. But I got MYSQL project, where we should disclose project on coming Saturday.
Here it is:




- Design a billing database for a coffee shop where 3 mean are at work selling coffee. And coffee shop is famous for delivering coffees in different flavors:
  1. Cold coffee.
  2. Coffee with cream.
  3. Roasted Coffee.
  4. Just coffee.
  5. Coffee blended with vanilla.
  6. Cappuccino.
Design neat database see to that all tables are normalized
Requirement of manager:
  • Get aggregated result of the sales men for each date.
  • Get aggregated result of the sales made as per flavors.
  • Get aggregated sale of till date, Find the person who made the highest sale get him 15% bonus (Note: Salary for all of them is equal).
  • Get the statistics to show which flavor is most successful till date.




Please teach me the procedure to create tables,attributes Or Plz get me the solution. Plz all MYSQL lovers assist me.
#mysql #project #required
  • Profile picture of the author MahindraI
    Banned
    [DELETED]
    {{ DiscussionBoard.errors[5264145].message }}
    • Profile picture of the author satz27
      Originally Posted by MahindraI View Post

      Sorry man I cant help you it here
      That's Okay fine. Eagerly waiting for others reply.
      {{ DiscussionBoard.errors[5264191].message }}
  • Profile picture of the author windfinder
    Looks like school work.

    What have you tried so far? What failed?

    You don't expect us to do it all, do you?
    {{ DiscussionBoard.errors[5264346].message }}
    • Profile picture of the author satz27
      Originally Posted by windfinder View Post

      Looks like school work.

      What have you tried so far? What failed?

      You don't expect us to do it all, do you?
      Ha ha! Not school. It'z a project given to each students at our institution.
      I wanna set tables and it's attributes to the above one. I can insert values and give proper values like primary key, auto increment etc i can manage.....
      But plz some1 get me tables and it's attributes.
      {{ DiscussionBoard.errors[5264636].message }}
      • Profile picture of the author Ikmal Syifai
        Originally Posted by satz27 View Post

        Ha ha! Not school. It'z a project given to each students at our institution.
        I wanna set tables and it's attributes to the above one. I can insert values and give proper values like primary key, auto increment etc i can manage.....
        But plz some1 get me tables and it's attributes.
        I think you can Google it, are you university student? Google must be your friend then.
        {{ DiscussionBoard.errors[5271120].message }}
      • Profile picture of the author KirkMcD
        Originally Posted by satz27 View Post

        Ha ha! Not school. It'z a project given to each students at our institution.
        It's not school, but you are a student? :confused:
        {{ DiscussionBoard.errors[5272930].message }}
        • Profile picture of the author satz27
          Originally Posted by KirkMcD View Post

          It's not school, but you are a student? :confused:
          Of course i am. But Seems like everyone is unable to assist me. You people want me to assist myself since it's a project right?
          {{ DiscussionBoard.errors[5275963].message }}
  • Profile picture of the author mywebwork
    It doesn't sound like an Internet Marketing issue.

    It sure DOES sound like you want us to do you homework for you though!

    :rolleyes:

    Bill
    {{ DiscussionBoard.errors[5273676].message }}
    • Profile picture of the author satz27
      Originally Posted by mywebwork View Post

      It doesn't sound like an Internet Marketing issue.

      It sure DOES sound like you want us to do you homework for you though!

      :rolleyes:

      Bill
      Yeah! I try myself. Indeed you people motivated me to do myself.
      {{ DiscussionBoard.errors[5275971].message }}
      • Profile picture of the author mywebwork
        Originally Posted by satz27 View Post

        Of course i am. But Seems like everyone is unable to assist me. You people want me to assist myself since it's a project right?
        It's not a matter of being "unable" to assist you - I recognize a few of the other responders on the thread and know that they are quite capable of solving your problem (as am I).

        But this is an Internet Marketing forum! The technical section is for answering questions regarding setting up websites, working with WordPress and Drupal, CSS and HTML - and yes MySQL.

        It is not, however, a place where you go to get others to do your school work for you!

        Originally Posted by satz27 View Post

        Yeah! I try myself. Indeed you people motivated me to do myself.
        That's much better! And at the risk of sounding like one of your professors it's really the only way you'll learn what you are supposed to be studying.

        Good luck with your project.


        Bill
        {{ DiscussionBoard.errors[5276006].message }}
        • Profile picture of the author satz27
          Originally Posted by mywebwork View Post

          It's not a matter of being "unable" to assist you - I recognize a few of the other responders on the thread and know that they are quite capable of solving your problem (as am I).

          But this is an Internet Marketing forum! The technical section is for answering questions regarding setting up websites, working with WordPress and Drupal, CSS and HTML - and yes MySQL.

          It is not, however, a place where you go to get others to do your school work for you!



          That's much better! And at the risk of sounding like one of your professors it's really the only way you'll learn what you are supposed to be studying.

          Good luck with your project.


          Bill
          Thank you sir.
          {{ DiscussionBoard.errors[5276383].message }}
  • Profile picture of the author omarusman
    Did you pin down your project? What happened?
    Signature

    My shot for an internet marketing blog.

    {{ DiscussionBoard.errors[5371092].message }}

Trending Topics