Database design and management tutorial // IT Management Solutions

Database design and management tutorial

a select query and the resultIf you are going to create your own database it is good to stick to the rules of database design, because they will ensure the long term integrity and maintainability of your data. This tutorial teaches you what databases are and how to design a database that conforms to the rules of relational database design.

Databases are programs that allow for the storage and retrieval of large quantities of related data. Databases consist of tables that contain data. When creating a database you should think about what tables you are going to create and what relationships exist between the data in your tables. In other words, you have to think about the design of your database. A good database design will ensure the integrity and maintainability of your data.

The structured query language (SQL)

A database is created for the storage and retrieval of data. This means that we want to be able to INSERT data into the database and we want to be able to SELECT data from the database.

A database query language was invented for these tasks called the Structured Query Language, or SQL. Both the SELECT and INSERT operations are part of the Structured Query Language. Below is an example of an SQL SELECT query and its result.

SQL is a large topic in itself, so it is outside the scope of this article. This article focusses strictly on database design. I will discuss the basics of SQL in a separate tutorial later.

The relational model

Database modelThis tutorial shows you how to create a relational database model. The relational model is a model that describes how to organize data into tables and how to define relationships between these tables.

The rules of the relational model dictate how data should be organized in tables and how tables are related to eachother. Ultimately, this results in a database diagram or Entity-Relationship diagram like the one in this picture. (Example taken from MySQL Workbench)


For the examples in this tutorial I used a number of applications.

Database administration tool

When you install Mysql you only get a command line interface to operate Mysql. Personally I prefer a graphical tool to administer my database. I often use Sqlyog for managing Mysql. Sqlyog is a freely available graphical administration tool for Mysql. When you see a picture of a database table in this tutorial, it comes from Sqlyog.

You might also like

Resume advice anyone? *resume inside*

by ----

OBJECTIVE To obtain a challenging position with room for professional growth.
11/2004 - 5/2006
Office Manager xxxxxxx co
Responsible for database management, scheduling clients, donors and volunteer staff, meeting and greeting, answering emails, and updating website.
10/2001 - 5/2004
Credit & Collection Officer xxxx co
Responsible for patient collections, processing applications for Financial Assistance, determining eligibility for Medicaid and assisting patients with the Medicaid application. Set up and tracking of payment plans. Verifying accuracy of all outgoing statements and bills

Job Ad Continues -- PART II

by --

II Payroll & Benefits
1) Work with HR to maintain payroll
2) Direct deposit; review and supervise where appropriate
3) Proper deductions for medical, 401(K), short & long term disability, medical and dental; review with HR, etc.
4) Payroll processing including tax, benefits, 401(K) and other deductions using outsourced payroll processing services
III Reports
1) Vendor purchases & insurance
2) Customer extra work order and sales
3) Amortization, cash flow, and partnership distribution schedules
4) Monthly company P&L
5) Portfolio review

McGraw-Hill Osborne Media Oracle E-Business Suite Manufacturing & Supply Chain Management
Book (McGraw-Hill Osborne Media)

互联网时代的网络自动化运维  — 中关村在线
CMDB(Configuration Management Database) 配置管理数据库(以下简称:CMDB),将IT基础架构的所有组件存储为配置项,维护每个配置项的详细数据,维护各配置项之间的关系数据以及事件、变更历史等管理数据。通过将这些数 ..

Wrox Real-World Solutions for Developing High-Quality PHP Frameworks and Applications
Book (Wrox)
Tsinghua University Press Pub. Date :2004-3-1 SQLServer database management. design and implementation tutorials(Chinese Edition)
Book (Tsinghua University Press Pub. Date :2004-3-1)
SELECTSOFT PUBLISHING New Selectsoft Publishing Orgchart Express Version 4.5 Drag Drop Box Styles Chart Design Wizard
  • Drag and drop box styles make creating eye-catching charts a snap
  • Tutorial walks you through each step
  • Quickly apply a color theme or background
  • Chart Design Wizard guides you through building the perfect chart
  • Multiple views let you edit data easily
Packt Publishing Getting Started with Oracle BPM Suite 11gR1 - A Hands-On Tutorial
Book (Packt Publishing)

Related Posts

Copyright © . All Rights Reserved