Database Design

Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design.

Why is Database important?

A database management system is important because it manages data efficiently and allows users to perform multiple tasks with ease. A database management system stores, organizes and manages a large amount of information within a single software application.

What are the steps in designing and building a database?

Relational Database Design Process

  • Define the Purpose of the Database (Requirement Analysis)
  • Gather Data, Organize in tables and Specify the Primary Keys
  • Create Relationships among Tables
  • Refine & Normalize the Design

Why is normalization important in database design?

Normalization is the process of organizing a database to reduce redundancy and improve data integrity. Also referred to as database normalization or data normalization , normalization is an important part of relational database design, as it helps with the speed, accuracy, and efficiency of the database.

We have been working extensively with the MS Access database and SQL Server

MS Access is a Rapid Application Development (RAD) tool that allows you to quickly build forms and reports that are bound to relational data. It comes with a file-based database engine (Jet/ACE).

Access can serve the needs of a small-medium company very well, but SQL is the industry standard for corporate professionals.

Microsoft SQL Server is sometimes shortened to SQL Server. It’s a database server that provides the infrastructure for a lot of really heavy duty work - and is a rival for the Oracle Database Server and other such high-end databases.

A database in SQL Server is made up of a collection of tables that stores a specific set of structured data. A table contains a collection of rows, also referred to as records or tuples, and columns, also referred to as attributes. Each column in the table is designed to store a certain type of information, for example, dates, names, dollar amounts, and numbers.

A computer can have one or more than one instance of SQL Server installed. Each instance of SQL Server can contain one or many databases. Within a database, there are one or many object ownership groups called schemas. Within each schema there are database objects such as tables, views, and stored procedures.