Question

  Asked: Feb 17 2008   2:14 PM GMT
  Asked by: Mis


Implementing DBMS


DBMS, Database, Database management

My company does not have information services staff and I am not planning to ave one at this moments because of the expanses. We have 12 WINTEL microcomputers that we used for variety of tasks withing the organization. We use Microsoft Office for words and financial application and power point, but we want to obtain more information on our operation. We need to implement DBMS, but we have no database management expertise. Could you provide a short list of basic steps that we should take in implementing a DBMS? Please Help!

Thanks

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0



Implementing a Database is easy. You simply select the database platform that you want to use and install the software. However by it self a database platform won't do much for you. It's all about what information is stored within the database as to if the information will do you any good. You'll need to know what information you want to store within the database, as well as how to view the information.

Personally I recommend Microsoft SQL Server as the database platform. It comes in various price points depending on the features that you want. The cost ranges from Free (limited feature set) to the Enterprise edition which costs several thousand dollars. I would recommend that you start with the free version SQL Server 2005 Express. It includes most of the features that you'll be looking for if not all of them.

The web page for Microsoft SQL Server can be found here and the web page for Microsoft SQL Server Express Edition can be found here. You can download the Express edition for free from here. You will see two download options. I recommend the SQL Server 2005 Express Edition with Advanced Services SP2 (right had side of the page) as it includes the free version of the management tools which will make it much easier to create databases and tables.

Now SQL Server does not include any sort of data forms. It is only the back end database. You will still need to create a front end to make it easier to add and view the records in the database. If everyone has Microsoft Access installed you can use this to create an access database which has forms which point to the database tables within the Microsoft SQL Server.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement and Database.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Feb 17 2008  8:26PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 

Mis  |   Feb 17 2008  11:29PM GMT

Thank you so much for your tips, I will definitely look into the Microsoft SQL Server and give you a feedback shortly. This was very helpful.