Database DB; is an organized, shareable, structured collection of related data stored on a computer storage device. It is the core and main management object of the database management system.

Database management system DBMS; is a system for managing databases. It is a software interface between users and databases. Its main function is to unify management and control the establishment, use and maintenance of databases.

Database system DBS; is a computer system that introduces database technology. A database system consists of a database and its management system.

Hierarchical model; a data model that represents data and its relationships in a tree structure is called a hierarchical model.

Network model; a data model that uses a network structure to represent data and its relationships is called a network model.

Relational model; a data model that represents data and its relationships in a two-dimensional table format is called a relational model.

Relationship; a relationship is a two-dimensional table, and each relationship has a relationship name. In this software a relationship is a table.

Tuple; each row in a relationship is called a tuple. A relationship can contain multiple tuples, but identical tuples are not allowed. In this software a tuple is a record in the table

Attributes; each column in a relationship is called an attribute, and the same attribute name is not allowed in a relationship. In this software, attributes are fields of the table.

Domain; the value range of an attribute is called the domain. For example, the domain of the "date of birth" field can only be a date, and the domain of the "unit price" field is generally a number, etc.

Key; a key, also called a keyword, is an attribute or collection that uniquely identifies a tuple. In this software, a key consists of one or more fields, and the key used to identify a record is called the primary key.

start up

quit

Title bar, quick access toolbar, ribbon, tab group, navigation form, workspace, status bar

Table; Table is the core and foundation of the database. It is mainly used to store data information. The operations of other database objects are performed on the basis of the table.

Query; the purpose of establishing a database system is not just to simply store data, but to analyze and research the data on the basis of storing the data.

Form: Form is the main interface between the database and users. Users can use forms to design various user interfaces for displaying, inputting or modifying table contents, and can input, edit, query and display data conveniently and quickly.

Report; the function of the report is to analyze and print data. Specifically used to output database objects.

Macro; a collection of one or more operation commands in the database, each operation command implements a specific function. A macro can be a single macro or a group of related macros composed of multiple macros.

Module object; a module is an object used for Visual Basic macro language programming.

Planning tables in the database

Determine the required fields in the table

Determine the primary key of the table

Determine table relationships

Optimize design