advanced database management system pdf notes

What is the Role of Databases in an Enterprise?Įnterprises typically make use of both internal databases and external databases. Table: A table is a collection of related records with a unique table nameĭatabase: A database is a collection of related tables. Record: A record is a collection of related fields. There are a few key terms that would be useful to help one understand data more, particularly the relation between data and databases.įields: Within a database, a field contains the most detailed information about events, people, objects, and transactions. Data is not limited to facts themselves, as pictures, images, and files are also considered data. For example, examples of data relating to an individual would be the person’s name, age, height, weight, ethnicity, hair color, and birthdate. Put simply, data are pieces of information or facts related to the object being considered. The five major components of a database are hardware, software, data, procedure, and database access language.īefore we get into the concept of a database, we should first understand what data is.

External databases refer to databases external to an organization and are generally accessed over the Internet and are owned by other organizations. Internal databases typically include operational databases and data warehouses.

Enterprises typically make use of both internal databases and external databases.

Databases are generally accessed electronically from a computer system and are usually controlled by a database management system (DBMS).

A database refers to a collection of logically related information organized so that it can be easily accessible, managed, and updated.

Advanced database management system pdf notes