It is a term referring to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

Composed of a collection of file folders that are properly tagged, kept in a filing cabinet, and organized according to their logical relationships.

Allows representing information using parent/child relationships: each parent can have many children, but each child has only one parent

It is very similar to the hierarchical model such that it also facilitates a 1:* relationships. However, it allows the child to have several parents.

It is a collection of relations or two-dimensional tables having distinct names.

It identifies all the system’s physical devices

It refers to the collection of programs used by the computers within the database.

It refers to all the users of the database system.

These are the rules that govern the design and use of the database system.

It overs the collection of facts stored in the database.

Type of user in the database system who oversee the general operations of the database system

Type of user in the database system who manage the use and proper functionality of the database system

Type of user in the database system who design the database structure

Type of user in the database system who design and implement the application programs - through which access and manipulation of the database’s is done

Type of user in the database system who use the application programs for the daily operations of the organization.

Type of software needed for the database that manages all the hardware components and makes all the other software run on the computer.

Type of software needed for the database that manages the database within the database system.

Type of software needed for the database that are used to access and manipulate data in the DBMS.

Select the Three Database Applications

Select Three Database Applications

It is a collection of programs that manages the database structure and controls access to the data stored in the database.

It is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types.

It is a collection of logical constructs used to represent the data structure and the data relationships found within the database.

It is anything (a person, a place, a thing, or an event) about which data are to be collected and stored.

It is the characteristic of an entity.

Collection of records

Collection of tables

It describes the association among entities.

Unique identifier of records in table

Primary key from another table.

It is a restriction placed on the data and is important because they help ensure data integrity.

It is the method of organizing data elements in tables

It refers to the most common database operations

Select the Three Types of Relationship

Select the Two Types of Data Dictionary

It is Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

It is an object that is used to define and store data.

It is an object in a desktop database designed primarily for data input or display or for control of application execution.

It is an object in desktop databases designed for formatting, calculating, printing, and summarizing selected data.

It is an object that provides a custom view of data from one or more tables.

This object is a structured definition of one or more actions that you want Access to perform in response to a defined event.

It is an object in desktop databases containing custom procedures that you code using Visual Basic.

It provides all the data definition, data manipulation, and data control features that you need to manage large volumes of data.

It contains fields or columns that store different kinds of data, such as a name or an address, and records or rows that collect all the information about a particular instance of the subject, such as all the information about a customer or employee etc.

These are a way of searching for and compiling data from one or more tables.

It is used for entering, modifying, and viewing records.

It is useful because they allow you to present components of your database in an easy-to-read format.

It can be attached directly to table events such as inserting new records, editing existing records, or deleting records.

These provide a more discrete flow of actions and allow you to trap errors.

Unique identifier of records in table