A database application is a computer program whose primary purpose is entering and retrieving information from a computerized database. Early examples of database applications were accounting systems and airline reservations systems, such as SABRE, developed starting in 1957.

Answer Expert Verified The Apache Open Office Calc is an example of a database management system or DBMS that has the spreadsheet application that is easy to learn because of the comprehensive range of advanced functions.

A database management system (DBMS) is a tool to store, edit and organise data in a database . It provides several key features: stores data in one central location. allows data to be shared by many users. controls who can access and edit the data.

A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records.

Types of databases

• Centralised database.
• Distributed database.
• Personal database.
• End-user database.
• Commercial database.
• NoSQL database.
• Operational database.
• Relational database.

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.

A database management software features and supports a multi-user environment, allowing several users to access and work on data concurrently. It also supports several views of the data. As a database is typically accessed by multiple operators simultaneously, these operators may need different database views.

Databases support good data access because: Large volumes of data can be stored in one place. Multiple users can read and modify the data at the same time. Databases are searchable and sortable, so the data you need can be found quick and easily.

Databases are a collection of organized information that can easily be accessed, managed and updated. Database systems are very important to your business because they communicate information related to your sales transactions, product inventory, customer profiles and marketing activities.

Advantages of Database Management System

• Reducing Data Redundancy. The file based data management systems contained multiple files that were stored in many different locations in a system or even across multiple systems.
• Sharing of Data.
• Data Integrity.
• Data Security.
• Privacy.
• Backup and Recovery.
• Data Consistency.

Benefits of database development

• reduce the amount of time you spend managing data.
• analyse data in a variety of ways.
• promote a disciplined approach to data management.
• turn disparate information into a valuable resource.
• improve the quality and consistency of information.

The DBMS is the interface between the user of application programs on one hand and the data base on the other. The objective of a database management system is to facilitate the creation of data structures and relieve the programmer of the problems of setting up complicated files.

The goal of database security is the protection of data against threats such as accidental or intentional loss, destruction or misuse. These threats pose problems to the database integrity and access.

Below is a list of components within the database and its environment.

• Software. This is the set of programs used to control and manage the overall database.
• Hardware.
• Data.
• Procedures.
• Database Access Language.
• Query Processor.
• Run Time Database Manager.
• Data Manager.

The main objectives of database designing are to produce logical and physical designs models of the proposed database system. The logical model concentrates on the data requirements and the data to be stored independent of physical considerations.

Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.

The design process consists of the following steps:

1. Determine the purpose of your database.
2. Find and organize the information required.
3. Divide the information into tables.
4. Turn information items into columns.
5. Specify primary keys.
6. Set up the table relationships.
7. Refine your design.
8. Apply the normalization rules.

Create a database without using a template

1. On the File tab, click New, and then click Blank Database.
2. Type a file name in the File Name box.
3. Click Create.
4. Begin typing to add data, or you can paste data from another source, as described in the section Copy data from another source into an Access table.

CREATE DATABASE

1. CREATE DATABASE.
2. A Database is defined as a structured set of data. So, in SQL the very first step to store the data in a well structured manner is to create a database.
3. Syntax: CREATE DATABASE database_name; database_name: name of the database.
4. Example Query:
5. CREATE TABLE.
6. Syntax:
7. Example Query:

Creating Local Database Using Microsoft SQL Server

1. Go to Start and search for Microsoft SQL Server.
2. To create a local database, you need a Server first.
3. Now, you are connected to the Server, so can you create a database.
4. You will see a window when clicked on the new database option.
5. Now, you can see a new database appearing in the database menu in the Object Explorer.

There are a number of ways you can enter data into a database table….You can add data into a database using any of the following methods:

1. Direct entry.
2. Form.
3. Import.
4. Structured Query Language (SQL)
5. Website or other application.

Then issue one of the following SQL statement:

1. Show all tables owned by the current user: SELECT table_name FROM user_tables;
2. Show all tables in the current database: SELECT table_name FROM dba_tables;
3. Show all tables that are accessible by the current user:

The full update statement is used to change the whole table data with the same value. The conditional update statement is used to change the data that satisfies the WHERE condition.

SQL INSERT – Inserting One or More Rows Into a Table

1. First, the table, which you want to insert a new row, in the INSERT INTO clause.
2. Second, a comma-separated list of columns in the table surrounded by parentheses.
3. Third, a comma-separated list of values surrounded by parentheses in the VALUES clause.

The insert command is used for inserting one or more rows into a database table with specified table column values. The first DML command executed immediately after a table creation is the insert statement.

SQL CREATE TABLE Statement

1. CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype,
2. Example. CREATE TABLE Persons ( PersonID int, LastName varchar(255),
3. CREATE TABLE new_table_name AS. SELECT column1, column2,… FROM existing_table_name. WHERE ….;
4. Example. CREATE TABLE TestTable AS. SELECT customername, contactname.

SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE – format YYYY-MM-DD. DATETIME – format: YYYY-MM-DD HH:MI:SS. SMALLDATETIME – format: YYYY-MM-DD HH:MI:SS.

The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates. The BETWEEN operator is inclusive: begin and end values are included.

Before the INSERT statement, the DATEFORMAT command is executed with DMY option which notifies SQL Server that the values of Dates will be in dd/MM/yyyy format….

1. DMY – dd/MM/yyyy. Ex:
2. YDM – yyyy/dd/MM. Ex:
3. MDY – MM/dd/yyyy. Ex:
4. YMD – yyyy/MM/dd. Ex:

SQL SELECT DATE

1. SELECT* FROM.
2. table_name WHERE cast (datediff (day, 0, yourdate) as datetime) = ‘