Click here to Skip to main content
Search within:



Next

how can design a church darabase?
Sign Up to vote bad
good
See more: SQL-Server
Please I wanted to design a small database for my church with the following features:
family member tracking,
small group tracking
ministry tracking class tracking
special event tracking
misc tracking
giving
member history
notes
 
into a GUI interface how do i go about it? and please help me with a step by step approach method.
Posted 21 Sep '12 - 1:39
john olive312
Add a Solution


2 solutions

I don't know how you are going to design your database. I don't have your requirement specification document. But I can suggest you to go through the links which will demonstrate "What will be the best for you".
SQL SERVER – 15 Best Practices for Better Database Performance[^]
Best Practices for Database Schema Design[^]
SQL Server Database Design Best Practices for Good Performance[^]
 
You should use these Three Ways to Plan Database Design[^].
 
You need to take care about Ten Common Database Design Mistakes[^] also.
 

--Amit
  Permalink  
Posted 21 Sep '12 - 1:48
_Amy38.6K
You might wanna talk to God, maybe you'll get him to do it for you.
 
Other than that, you might wanna start reading on Database design[^], while avoiding common DB design mistakes[^] (which I don't fully agree with, but it's ok on the whole).
 
And if you want to design it in a GUI interface, well, there's a few solutions that may actually help, but SQL Server Management Studio comes to mind first (you did specify SQL-Server).
  Permalink  
Posted 21 Sep '12 - 1:51
Andrei Straut10.7K
Comments
john olive - 21 Sep '12 - 9:11
I just want to say a big thank you to Amit. I have clicked on the respected links and have simply gotten some ideal. i will try them as soon as posible. God Bless!
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 OriginalGriff 263
1 Sergey Alexandrovich Kryukov 254
2 Maciej Los 161
3 Tadit Dash 110
4 Richard MacCutchan 95
0 Sergey Alexandrovich Kryukov 10,264
1 OriginalGriff 7,917
2 CPallini 4,181
3 Rohan Leuva 3,522
4 Maciej Los 3,125


Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 21 Sep 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid