Databases Theory Notes & Revision

Difference Between Server-side Scripting and Client-side Scripting

Sequence of events when you request a web page World Wide Web works in a client-server architecture. The client-side has an application program called Web Browser which is used to send the request to the server for a particular web page. Google Chrome and Microsoft Internet Explorer are examples of Web Browser. The server side …

Relational databases and SQL

In this article, we will discuss what is SQL? And what part is it playing in shaping business in today’s world? In order to understand this first, we need to understand what is the need for SQL and how it works. On what principles does it work and what is its history? SQL SQL is …

Database Management Systems (DBMS)

In this article, we will discuss the type of data that is concerned with storage that exist in computers and are readable and used by computers. We will also discuss all the different types of data storage that are present. We will also discuss what is Sequential Query Language and how it helps in handling …

Primary Key (Primary Keyword)

A primary key, also known as a primary keyword, is a key in a relational database that is specific for each record. It is a unique attribute, like a driver’s license number, telephone number with area code, or vehicle identification number (VIN). A relational database can only have one primary key. Primary keys are usually …

What is a Database?

Database Management System (DBMS) A database is any collection of information that has been systematised for quick searching and retrieval via the use of a computer. Databases are intended to provide the means for the modification, deletion, storage, and retrieval of data in connection with different operations. A database management system (DBMS) utilises queries to pull out information from the …

Database Query

Database Query A database query is a way of requesting information from the database. A database query can be either a select query or an action query. A select query is a query for retrieving data, while an action query requests additional actions to be performed on the data, like deletion, insertion, and updating. For …

Database Fields

Database A database is a set of data arranged in a way that a computer program can immediately choose required portions of data. It is often called a DB. A common database can be compared to a filing system which is arranged by fields, records, and files. A field is a specific piece of data, …

Database Table

A relational database is made up of different components. The most important of these is the table. All the data in the database is stored in the database table. Without tables, there would not be much needed for relational databases at all. Information on a single subject is placed in order as rows and columns in …

DBMS

Candidates should be able to: describe how a DBMS allows the separation of data from applications and why this is desirable describe the principal features of a DBMS and how they can be used to create customised data handling applications. What is a DBMS? A Database Management System (DBMS) is used to manage a database. …

Database Validation

It is imperative that data is entered correctly in a database. An automated database has the benefit of including automatic checks in order to prevent incorrect data from being recorded into the database. This is a process which isn’t available in a manual database. Validation is a process whereby the data entered in the database is …

Database Data Types

Database data types refer to the format of data storage that can hold a distinct type or range of values. When computer programs store data in variables, each variable must be designated a distinct data type. Some common data types are as follows: integers, characters, strings, floating-point numbers and arrays. More specific data types are …

Database Record

A database record is a collection of fields about the same person, item, or object in a database. The database record can be thought of as a row of information within a database table. The Database A database is a set of data arranged in a way that a computer program can immediately choose the …

Steps in Creating a Database Exercise

Data Entry Checks Quiz

Access Database Validation 2 Quiz

Access Database Validation 1 Quiz

What is a Relational Database?

Candidates should be able to: What are the limitation of flat-file databases? In a flat-file database, all the data is held in a single table and there are several problems associated with this. Consider the following scenario: The problems that can then occur: Data redundancy: The limitations of trying to represent this information in a …

The DBMS

The Database Concept

Candidates should be able to: describe a database as a persistent organised store of data explain the use of data handling software to create, maintain and interrogate a database. What is a database? A database is a persistent, organised store of related data. A database is persistent because the data and structures are stored in …

Databases

Data types, fields, queries, records, tables, validation, primary keys and the database concept.