The software that manages a database is called a Database Management System (DBMS). The main purposes of a DBMS are to add, delete, and update the data in the database and to provide various ways to view the data. Popular DBMS software available today is

Authors Avatar

Table of Contents

Question Title                                                                            Page Number

A). Database        

C). Attributes (Columns)        

D). Tuples (Rows)        

E). Primary Key        

F). Composite Primary Key        

G). Foreign Keys        

References        


A). Database

A Database is any collection of data organized for storage in a computer memory and designed for easy access by authorized users. The data may be in the form of text, numbers, or encoded graphics. The software that manages a database is called a Database Management System (DBMS). The main purposes of a DBMS are to add, delete, and update the data in the database and to provide various ways to view the data. Popular DBMS software available today is Microsoft Access, Microsoft SQL Server and Oracle. Databases are used in many applications, spanning virtually the entire range of computer software. Databases are the preferred method of storage for large multi-user applications, where coordination between many users is needed. Even individual users find them convenient, and many electronic mail programs and personal organizers are based on standard database technology. Software database drivers are available for most database platforms so that application software can use a common application programming interface to retrieve the information stored in a database. Two commonly used database application programming interfaces are JDBC and ODBC.

Join now!

Databases have become so important in industrial societies that they can be found in almost every field of information. Government, military, and industrial databases are often highly restricted, and professional databases are usually of limited interest. A wide range of commercial, governmental, and nonprofit databases are available to the general public, however, and may be used by anyone who owns or has access to the equipment that they require.


 

B). Tables

A table (a relation) is a collection of data about a specific topic, such as ‘Books’, ‘Borrowed Books’, ‘Employees’, ‘Incoming Books’, ‘Members’, ‘Outdated Books’, ...

This is a preview of the whole essay

Here's what a teacher thought of this essay

Avatar

*** Generally a good explanations of the main database concepts but a bit confusing in parts