Click here to Skip to main content
15,913,055 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hai...
I am planning to develop a software for my school management. it has many modules like
1. Student Management
2. Fee Management
3. Time Table
4. Library Management
5. Attendance
6. Inventory
7. Payroll
8. Achievements etc..

I am little confused about it... Should I use one project and add all features in one.. but it will be a big project... or should I split into different projects like Fee Management, Library Management, Inventory, Payroll etc.. and then call all exe(s) from one main project.
Which will be better?

same confusion with database...
because at present which software we are using it has 5 sql databases.. Student, Fee, Library, Timetable and Payroll..

should I create one sql server database, will it be good..

please help.....

What I have tried:

I am still under planning... getting software development methodologies.... please reply
Posted
Updated 6-Jul-17 7:27am
Comments
Prifti Constantine 6-Jul-17 5:57am    
When you say Databases, do you mean Tables inside the databases? Also, if you want to create libraries in order to split the project into many libraries, it will get more confusing . Spliting into libraries and taking such serious decisions on the project, it always has to do on wether you have the required experience in order to implement your thoughts into code.
Rajan Pandit 6-Jul-17 6:05am    
not tables inside databases... there are 5 sql databases... but I am planning for one database..
so, should I create only one project?
Prifti Constantine 6-Jul-17 6:16am    
Again...if you have the required experience to do so, then you could try creating many projects...A potential drawback in creating ONE project can be that you will probably have to create many connection strings in order to access the 5 databases that you have. This means that one sqlDataSource is not enough and you will have to use an ORM in order to access the databases through the classes that will be generated.If you only create one database then i dont think that the complexity will go very high, so one project should cover your needs.
Rajan Pandit 6-Jul-17 12:38pm    
dear, I am not using my old databases.. I am planning a new database for all my need...

Start making a model with some UML tool or some drawing on paper. Invest some hours - it is worth it. Than you get some skeleton to implement.

Make one database, which can and should have different tables.

Make one project but work with classes.
 
Share this answer
 
Comments
Rajan Pandit 6-Jul-17 12:41pm    
Thanks dear.. I am also planning one project for all my modules... one question... what is the use of ORm and which is better..
Prifti Constantine 7-Jul-17 2:52am    
ORM makes the connection to the database and generates classes that will be able to help you out acting as the data access layer.
KarstenK 7-Jul-17 7:46am    
Fine, your work load is a normal small project. Use the UML to find a class and modul concept. Use the MVVM pattern to separate data, UI and worker code.

My experience is that tool generated code is good starting point, but will replaced with some hand written special code someday.

So dont make yourself a slave of some tools. It hinders creativity.
Rajan Pandit 9-Jul-17 10:15am    
thanks for reply... I got the idea....
As Robert Burns once said:

(Oh) ... "of the best laid plans of mice and men" ...

Doubtless that in the planning stages of ANYTHING, something will not be what it turns out to be WHEN it happens and you'll end up doing something else.

So my thought is, why not ask a question when SOMETHING actually does THAT. I'm not saying be prepared for a failure but I am saying that here in CPQA, until some code that is disfuntional crops up and the navigators can see it, Pip will be going on about conjugation and noone's going to care much.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900