How to Build a Database from Scratch

Database

A database is a collection of information organized in a way that makes it easy to access, manage, and update. Data in databases is typically structured in tables with rows and columns and is indexed to facilitate efficient retrieval and reading.

Creating a Database

Using Microsoft Access

Microsoft Access is a database management system similar in nature to relational databases. It is part of the Microsoft Office suite and features a user-friendly interface. It also supports integration with other Microsoft software such as Microsoft SQL Server, making it suitable for managing both small and large databases. To create a database using Microsoft Access, follow these steps:

• When opening Access, options appear under the New tab for creating a new database, allowing users to either start from scratch or use pre-designed templates.
• After selecting a database template, the program will prompt for a name and allow changing the save location by clicking the folder icon and choosing the desired path.
• Click the Create button to finalize the process.

Using SQL Servers

Microsoft SQL Server

The SQL Server Management Studio can be used to create a database by following these steps:

• In the Object Explorer, establish a connection to the Microsoft SQL Server engine.
• Right-click on Databases and select New Database.
• Enter a name for the database.
• Click OK to confirm.

MySQL

MySQL is one of the most popular open-source database management systems, known for its ease of use and robust features. To install MySQL on Windows, use the MySQL Installer for Windows:

• Download the installer from the official MySQL website.
• Run the downloaded file.
• Select the Setup Type; the Developer Default option is usually recommended.
• Follow the installation prompts until completion.

After installation, set a password for the root user as follows:

• Open the MySQL Command Line Client via the Start menu under the MySQL folder.
• Run the command: mysql -u root -p
• Enter a new password and press Enter.

Once configured, SQL commands can be executed through the MySQL command-line interface. To create a new database, run the following command (replacing "databasename" with the desired name): CREATE DATABASE databasename.

Structured Query Language (SQL) can be used to perform various operations on databases that support it, including creating tables, retrieving data based on specific conditions, and inserting or updating records.

Types of Databases

Databases can be classified based on their structure and interaction methods into several types:

• Relational database: Data is stored in tabular format, enabling versatile management and access. Structured Query Language (SQL) is the primary language used for organizing data in this type.
• Distributed database: Data is spread across multiple locations on a network and stored on different devices.
• Cloud database: Designed for cloud computing environments, this type allows flexible selection of storage capacity and bandwidth according to requirements.
• Object-oriented database.
• NoSQL database: Ideal for storing large volumes of distributed data. Unlike relational databases, which may face performance issues with massive datasets, NoSQL databases offer high performance when handling large-scale data processing.
• Graphical database: This type uses graph theory to store and process data, making it effective for representing complex relationships.

Database Management Systems

Database Management Systems (DBMS) are software tools used to create and manage databases by providing mechanisms for data creation, retrieval, and administration. They act as intermediaries between the database and users or developers. DBMS focuses on three core aspects: the data itself, the database engine, and the database structure. Notable examples include:

• Oracle: Used for managing relational databases.
• Microsoft SQL Server: Available exclusively for the Windows operating system.
• PostgreSQL: Compatible with multiple operating systems, including Windows and Linux.
• MySQL.
• MariaDB: Developed by a community of programmers, it is an open-source database system.

References

1. ^ ^{a b} Margaret Rouse, "database (DB)", TechTarget, Retrieved 29-7-2017. Edited.
2. ↑ "Microsoft Access", Techopedia, Retrieved 29-7-2017. Edited.
3. ↑ "Create a new database", Office, Retrieved 29-7-2017. Edited.
4. ↑ "How to: Create a Database (SQL Server Management Studio)", Microsoft, Retrieved 29-7-2017. Edited.
5. ^ ^{a b c} "Getting Started with MySQL", MySQL, Retrieved 29-7-2017. Edited.
6. ↑ "Installing MySQL on Microsoft Windows", MySQL, Retrieved 29-7-2017. Edited.
7. ↑ "SQL CREATE DATABASE Statement", W3Schools, Retrieved 29-7-2017. Edited.
8. ↑ Jackie Goldstein, "Writing SQL Queries: Let's Start with the Basics", Microsoft, Retrieved 29-7-2017. Edited.
9. ↑ Margaret Rouse, " database management system (DBMS)", TechTarget, Retrieved 29-7-2017. Edited.
10. ↑ "DBMS", techterms, Retrieved 30-6-2022. Edited.