What Is database management System? // IT Management Solutions

What Is database management System?

Microsoft Access Database Management SystemA Database Management System (DBMS), is a software program that enables the creation and management of databases. Generally, these databases will be more complex than the text file/spreadsheet example in the previous lesson. In fact, most of today's database systems are referred to as a Relational Database Management System (RDBMS), because of their ability to store related data across multiple tables.

Some of the more popular relational database management systems include:

  • Microsoft Access
  • Filemaker
  • Microsoft SQL Server
  • MySQL
  • Oracle

Throughout this tutorial, you will become familiar with some of the key concepts of database management systems. These include:

  • Database creation
  • Tables
  • Adding data to your database
  • Querying a database
  • Relational database design

What Does a Database Management System Look Like?

Different database management systems look different, but generally, there are a number of common features that you'll usually see across most of them.

Microsoft Access

This is the main screen you'll see when opening up Access to view an existing database. The outer part is the database management system and it's menu, the middle part is the actual database. In this example, the database is called "dateSite" and has 20 tables. If you were to open a different database, the name of the database would be different and you would see different tables, but the available options would be the same (i.e. Tables, Queries, Forms, Reports, Macros, Modules, Open, Design, New).

Microsoft SQL Server - Enterprise ManagerSome of these options are common across all database management systems. All database systems allow you to create tables, build queries, design a new database, and open an existing database.

Microsoft SQL Server

Microsoft SQL Server is a more robust database management system than Access. While Access is better suited to home and small office use, SQL Server is more suited to enterprise applications such as corporate CRMs and websites etc.

The above screen is what you see when you open SQL Server through Enterprise Manager. Enterprise Manager is a built-in tool for managing SQL Server and its databases. In this example, there are 6 databases. Each database is represented down the left pane, and also in the main pane (with a "database" icon).

Which Database System to Use?

If you are using a database for home or small office use, Microsoft Access or Filemaker should be fine. If you need to create a database driven website, then you're better off using a more robust system such as SQL Server, Oracle, or MySQL.

The examples in this tutorial use Microsoft Access. If you don't have Microsoft Access, you should still be able to follow the examples. The tasks we perform are the same tasks you would need to perform regardless of which database management system you use. The key goal with this tutorial is to provide you with an overview of what is involved in creating and maintaining a database.

You might also like

Here's what is means

by EruditeGuy

A content management system is a data driven system. In other words, you log into the system (i.e. in most cases it's a web application...it could also be on a different platform), enter/retrieve/update information that is stored into a database and displayed somewhere within the application.
What is the job title and description? If it involves development/maintenance of the application you don't have any programming experience, then you are totally out of your domain (as you said, you don't have much experience using computers...not knowing how to program and develop applications follows from this).

What would you say is a more reasonable estimate

by for-a-dot-com?

I haven't gotten to much involved in the hardware side of the scalability question. Is there a rough estimate of a function that will relate cost per user in hardware? I can do it for storage space fairly easily, but processing requirements are a bit more complicated because they are more variable.
People use the system at different times of day all over the world. They use it for different purposes: file storage, database management, communications.
I can outsource the storage space for about $1000 per terabyte if I buy it in 20 TB chunks. I need 100Kbps for bandwidth and I can get that much cheaper than I can get the storage space, so it's negligible

What are you talking about?

by blur

I'm saying that I have the VB.Net version, which is well written and uses notepad and not Visual Studio.Net. All you need to write applications are the .net framework, IIS, a text editor and your database management system of choice.
The C# version, I would assume, is similarly written (e.g. does NOT use the IDE). If so, it sounds like what the OP wants, except that he asked for a website and this is a book.

McGraw-Hill Database Management Systems, 3rd Edition
Book (McGraw-Hill)
  • NA

Shielding names of police, prosecutors in online tax records divides lawmakers  — WRAL.com
Paul Stam, R-Wake, said counties would spend millions of dollars managing databases where some names were out in the open and others weren't. "This idea that you can have two different sets of records electronically – one at the courthouse and the ..

WAGmob (Simple 'n Easy) Database Management System
Mobile Application (WAGmob (Simple 'n Easy))
  • Study all the basic topics of Database Management System right on your Android device:
  • This app offers tutorials and flashcards on the following topics:
  • Introduction to DBMS,
  • Types of DBMS,
  • Data Models,
  • Relational Database Model,
  • Entity Relationship Modelling,
  • Normalization of Database Tables,
  • Database Connectivity and Web Technologies,
  • Database Administration and Security.
Wiley Operating System Concepts
Book (Wiley)
Addison-Wesley Fundamentals of Database Systems (6th Edition)
Book (Addison-Wesley)
BodyMedia BodyMedia LINK Armband Weight Management System
Health and Beauty (BodyMedia)
  • Track your activity and calorie burn like the contestants on The Biggest Loser and endorsed by health and wellness expert Jillian Michaels
  • The BodyMedia system automatically tracks your calories around the clock helping you to lose weight and even improve your weight loss by 3X proven in group trials
  • Provides most accurate calorie burn measurement in market (data available on BodyMedia.com)
  • Bluetooth-enabled to work with BodyMedia iPhone and Andoid apps so you can see your data in real-time and upload wirelessly Food logging also available with app
  • Works with MyFitnessPal, Runkeeper, Sparkpeople and more

Related Posts

Copyright © . All Rights Reserved