hi
i am gonna create a student record keeping application.
i just wanna how which are the basic information means the table in my database are require to create common database
i just wanna know table name and require filed in each table which are common in all student record keeping application in general that according to this database i will have changes according to my requirement
so i only need you little suggestion about database require to create student record keeping application.
Jump to PostStudent to have fields like roll no, name,course ,etc
Student to have fields like roll no, name,course ,etc
I am not sure i understand the question. Database modeling is like a playdough - it is a pile of shapeless material untill you decide in which direction to go and how to shape it. In development there is a term "business rules". Every single development project starts with gathering business rules. Business rules are the "rules of the game", for example, in your case a rule could be that one student may not attend more than 3 classes per semester. Another rule might be that 2 classes cannot be scheduled at the same classroom at the same time. Now, there are plenty of "modeling languages and tools". UML or agile modeling, for example.
I highly recommend to any given developer in the world first to get in the clear of WHAT they want to do, and then find out a way to do it. For me, it takes me a long time to carefuly model my projects with pencil and paper, and then it takes me 15 minutes to write the code for it.
Hope it helps.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.