Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. want a school good database ( tables and columns)

want a school good database ( tables and columns)

Scheduled Pinned Locked Moved Database
databasehelp
7 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    my name is coder
    wrote on last edited by
    #1

    hi i want to write a good app for schools to use in regeister student. please help me to create a good database for that ! thanks for your helping ! ! ! :-O

    W L 2 Replies Last reply
    0
    • M my name is coder

      hi i want to write a good app for schools to use in regeister student. please help me to create a good database for that ! thanks for your helping ! ! ! :-O

      W Offline
      W Offline
      Wendelius
      wrote on last edited by
      #2

      Based on the info you provided there's not much to say. Have you designed something, got specific problems etc. If you're in the beginning, may I suggest a good book: http://www.amazon.com/Database-Modeling-Design-Fifth-Management/dp/0123820200/ref=sr_1_1?s=books&ie=UTF8&qid=1301228968&sr=1-1[^]

      The need to optimize rises from a bad design.My articles[^]

      M 1 Reply Last reply
      0
      • W Wendelius

        Based on the info you provided there's not much to say. Have you designed something, got specific problems etc. If you're in the beginning, may I suggest a good book: http://www.amazon.com/Database-Modeling-Design-Fifth-Management/dp/0123820200/ref=sr_1_1?s=books&ie=UTF8&qid=1301228968&sr=1-1[^]

        The need to optimize rises from a bad design.My articles[^]

        M Offline
        M Offline
        my name is coder
        wrote on last edited by
        #3

        sorry ! ! ! i want to design a database for school ! please help me !

        W 1 Reply Last reply
        0
        • M my name is coder

          sorry ! ! ! i want to design a database for school ! please help me !

          W Offline
          W Offline
          Wendelius
          wrote on last edited by
          #4

          You don't have to be sorry. The problem is that you haven't: - given any usable information for/about the design - showed anything you've already done - pointed out a specific question These forums are for getting help for example when you get stuck in a certain issue or don't understand a certain detail etc. People here won't hand over the code or database etc. If you're a student it's important that you learn the tools and techniques you're given lessons in. This won't happen if someone else does the thinking for you. I would suggest that you have a look at other questions in this forum. You'll quickly notice what is the best way to ask for help. I believe that if you explain yourself well and in detail and more importantly show that you've done some effort then you'll get quality answers.

          M 1 Reply Last reply
          0
          • W Wendelius

            You don't have to be sorry. The problem is that you haven't: - given any usable information for/about the design - showed anything you've already done - pointed out a specific question These forums are for getting help for example when you get stuck in a certain issue or don't understand a certain detail etc. People here won't hand over the code or database etc. If you're a student it's important that you learn the tools and techniques you're given lessons in. This won't happen if someone else does the thinking for you. I would suggest that you have a look at other questions in this forum. You'll quickly notice what is the best way to ask for help. I believe that if you explain yourself well and in detail and more importantly show that you've done some effort then you'll get quality answers.

            M Offline
            M Offline
            my name is coder
            wrote on last edited by
            #5

            ok i'm student and i want to creat an App for my school. i learned C# programing but i have problem in sql server . i can't Normalization what i want ! if any body can to teach me how to create a good database for my school, I will be grateful

            K 1 Reply Last reply
            0
            • M my name is coder

              hi i want to write a good app for schools to use in regeister student. please help me to create a good database for that ! thanks for your helping ! ! ! :-O

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              Oracle has a nice description[^] of the steps. 3NF is usually considered "normalized".

              I are Troll :suss:

              1 Reply Last reply
              0
              • M my name is coder

                ok i'm student and i want to creat an App for my school. i learned C# programing but i have problem in sql server . i can't Normalization what i want ! if any body can to teach me how to create a good database for my school, I will be grateful

                K Offline
                K Offline
                Klaus Werner Konrad
                wrote on last edited by
                #7

                So you really ask: PLEASE, MAKE THE COMPLETE DESING FOR ME Look, it isn't this hard; you just have to think about relationships: - you have *students* with Student_ID and other student related columns - vou have *teachers* with Teacher_ID and other teacher related columns - you have *courses* with Course_ID and other course related columns them are your BASE tables then you have a relation: which teacher can teach which courses - *TeachCourse* with Teacher_ID and Course_ID and other columns (i.e Weekday/Time) also, you have a relation: which student took what courses - *StudCourse* with Student_ID and Course_ID, no other columns (initially) needed Underlined columns are the primary keys for the tables Beware this is just the basic work - you have to refine it for multiple years and so on HTH

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups