SQL

SQL

            SQL is a programming language that is used to manage database and perform operations on them.

SQL COMPONENTS:

    A. Data Definition Language:

                Data definition language is a language that is used to modify the structure of the objects in the database. With this language, you could create a structure of your database objects in a database, including views, index tables.

    B. Interactive Data Manipulation Language

                This language allows the user to insert, delete and retrieve data in a table. With this language, you will be able to modify and data into a table in your database.

    C. Embedded Data Manipulation Language

                The embedded form of DML is used so commands and statements from the SQL are combined into program language using another programming language.

Database Management System

DATABASE MANAGEMENT SYSTEM

DBMS: Database Management System

                                    DBMS( Database Management System) is a software tool that gives the users the benefits to handle data easily. It allows the users to control and interact with the data with ease. This software also allows users to recover their data, it has a feature that will help users to restore their lost information. DBMS also allows users to work on their database without interference from other users.

    Advantages of DBMS

    *Increased data security- DBMS secures our data so that it wouldn't be vulnerable.

    *Data integration- DBMS allows different users to operate on one entity without any problems.

    *Data recovery- DBMS allows the users to recover their lost data easily.

    Disadvantages of DBMS

    *High Cost- DBMS requires huge memory size to use the database, sometimes it requires a high-speed processor.

    *Complexity- DBMS is quite hard to learn. It wouldn't be easy for new-learners to fully utilize the application from the start.

    *Performance- DBMS performs slow at times. It is generally good for some applications however it isn't the same to all, as such, some applications may not run due to bad performance.

Database

What is Database?

            Database refers to a collection of related information that is organized in a way that you can easily access, manage and update. Database allows you to store data, in addition, you can summarize and extract the collected data.

What type of software is Microsoft office Excel?

                Excel is a type of spreadsheet software program that is used to manage numerical functions. The data in excel are stored in spaces called cells. It is capable of calculation and large computation, you can add charts, tables, graphing tools in this software. It allows the user to organize, format and compute data from the cells of the program.

What type of software is Microsoft office Access?

                Access is a database management system program, where tables are linked and connected. It uses unique ID to easily find and access the information. You use access to store details on large amount of items. This program keeps them organized, link and extract information from a lot of data.

Differences between Excel and Access

                Excel and Access are both used in organizing and managing data. Excel is used to perform mathematical equation and financial calculations, while Access is used for storing large amount of data. Access is hard to learn, meanwhile Excel can be learned easily. Both of these store data, however Access has a larger amount of storage capacity compared to excel.