Implementing DBMS

15 pts.
Tags:
Database
Database management
DBMS
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
ASKED: February 17, 2008  2:14 PM
UPDATED: February 17, 2008  11:29 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 <a href=”http://www.microsoft.com/sql/”>here</a> and the web page for Microsoft SQL Server Express Edition can be found <a href=”http://www.microsoft.com/sql/editions/express/default.mspx”>here</a>. You can download the Express edition for free from <a href=”http://msdn2.microsoft.com/en-us/express/bb410792.aspx”>here</a>. 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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    65,450 pointsBadges:
    report
  • Mis
    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.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following