Welcome to my “Database vs database management system.”
Storage, retrieval, and sorting of information
Database and database management systems
Database. To store and process large amounts of information, databases are used. A telephone directory is a database that stores information about organizations (address, telephone, etc.). A notebook is a database in which information about people (name, phone, e-mail address, etc.) is recorded. The library catalog is a database that stores information about books (title, author, year of publication, etc.).https://www.blogger.com
Each database stores information about a large number of objects of the same type (organizations, people, books, etc.). Objects of the same type have the same set of properties, so the database stores the values of these properties for each object.
The database allows you to orderly store data about a large number of the same type of objects that have the same set of properties.
At present, computer databases are widely distributed. For example, when using e-mail, the Address Book database is used.
Tabular form of database representation. It is convenient to represent databases in the form of a table. In each row of the table, the property values of one object are placed, and each column of the table stores the values of a certain property of all objects. For example, in the "Notebook" database, each line of the table contains information about a certain person, and the values of its "properties": "No.", "Last name", "Phone", "E-mail" is stored in different columns.
Database and database management systems
Database. To store and process large amounts of information, databases are used. A telephone directory is a database that stores information about organizations (address, telephone, etc.). A notebook is a database in which information about people (name, phone, e-mail address, etc.) is recorded. The library catalog is a database that stores information about books (title, author, year of publication, etc.).https://www.blogger.com
Each database stores information about a large number of objects of the same type (organizations, people, books, etc.). Objects of the same type have the same set of properties, so the database stores the values of these properties for each object.
The database allows you to orderly store data about a large number of the same type of objects that have the same set of properties.
At present, computer databases are widely distributed. For example, when using e-mail, the Address Book database is used.
Tabular form of database representation. It is convenient to represent databases in the form of a table. In each row of the table, the property values of one object are placed, and each column of the table stores the values of a certain property of all objects. For example, in the "Notebook" database, each line of the table contains information about a certain person, and the values of its "properties": "No.", "Last name", "Phone", "E-mail" is stored in different columns.
Columns of the tabular database are called fields. Each field has a name and can store data of a certain type (text, number, date/time, etc.). In the "Notebook" database, the fields are "No." (number), "Last name", "Phone" and "E-mail" (text).
The rows of the table are called records (that is, they are records about the object). The record stores a set of values contained in the fields of the database. Records can be numbered using the counter (field "No.").
So, in the "Notebook" database there are three records, in each of which the values of four properties are stored.
The advantage of the tabular representation of the database is the ability to see several records at the same time. However, if the database contains many fields and field values contain many characters, it is not very convenient to enter, view and edit records.
View database records using a form. To alternately enter, view and edit database records, a form is often used. The form allows you to sequentially display records in a user-friendly format.
Typically, the form contains inscriptions that are the names of fields in the database, and fields in which the data of the selected database record is displayed (see Figure 5.1).
During the creation of the form, you can specify which fields of the database to include in the form and how to arrange the fields in the form window. The user can choose the appropriate design (size and color) of the inscriptions, text fields and the form itself.
The rows of the table are called records (that is, they are records about the object). The record stores a set of values contained in the fields of the database. Records can be numbered using the counter (field "No.").
So, in the "Notebook" database there are three records, in each of which the values of four properties are stored.
The advantage of the tabular representation of the database is the ability to see several records at the same time. However, if the database contains many fields and field values contain many characters, it is not very convenient to enter, view and edit records.
View database records using a form. To alternately enter, view and edit database records, a form is often used. The form allows you to sequentially display records in a user-friendly format.
Typically, the form contains inscriptions that are the names of fields in the database, and fields in which the data of the selected database record is displayed (see Figure 5.1).
During the creation of the form, you can specify which fields of the database to include in the form and how to arrange the fields in the form window. The user can choose the appropriate design (size and color) of the inscriptions, text fields and the form itself.
Database management systems (DBMS). Creation of databases, as well as operations for searching and sorting data, are performed by special programs - database management systems (DBMS). Thus, it is necessary to distinguish proper databases, which are ordered data sets, and database management systems are applications that manage storage and processing of data.
A database management system is an application that allows you to create databases and perform sorting and data search in them.
A simple DBMS can be executed by spreadsheets, as well as text editors, by inserting tables into the document. The table columns are database fields, and database records are placed in the rows of the table. The first line of the table should contain the names of the fields in the database.
Creating a database using DBMS begins with creating database fields, setting their types and entering field names. Then, in table or form mode, you enter, view and edit database records. Then you can sort and search the data in the created database.
In Microsoft Word and OpenOffice Writer text editors, you can insert a table into the document using the [Table-Insert] command. In the dialog box that appears, you can select the number of columns in the table (database fields) and the number of rows in the table (database entries).
In spreadsheets, you can enter, view and edit records in both table mode and form mode. In Microsoft Excel spreadsheets, you must select the data cells and enter the command [Data-Form ...] to call the form. A form appears that contains the database entry.
A database management system is an application that allows you to create databases and perform sorting and data search in them.
A simple DBMS can be executed by spreadsheets, as well as text editors, by inserting tables into the document. The table columns are database fields, and database records are placed in the rows of the table. The first line of the table should contain the names of the fields in the database.
Creating a database using DBMS begins with creating database fields, setting their types and entering field names. Then, in table or form mode, you enter, view and edit database records. Then you can sort and search the data in the created database.
In Microsoft Word and OpenOffice Writer text editors, you can insert a table into the document using the [Table-Insert] command. In the dialog box that appears, you can select the number of columns in the table (database fields) and the number of rows in the table (database entries).
In spreadsheets, you can enter, view and edit records in both table mode and form mode. In Microsoft Excel spreadsheets, you must select the data cells and enter the command [Data-Form ...] to call the form. A form appears that contains the database entry.
1. What are the advantages and disadvantages of database table presentation?
2. What are the advantages and disadvantages of representing databases using a form?
3. What is a record and what is a field in the database?
4. Which types of fields can be present in the database?
5. Is there a difference between the database and the DBMS?
6. Which applications can perform the functions of a simple DBMS?
Tasks for self-fulfillment
5.1 Practical task. In the text editor, create a table database called "Notebook" (see Table 5.1) and enter three entries.
5.2 Practical assignment. In the spreadsheets, create a tabular "Notebook" database (see Table 5.1) and enter three records using the form (see Figure 5.1).
5.3 Practical task. In the text editor, create a table database "Computers" (see Table 5.2) and enter six entries.
2. What are the advantages and disadvantages of representing databases using a form?
3. What is a record and what is a field in the database?
4. Which types of fields can be present in the database?
5. Is there a difference between the database and the DBMS?
6. Which applications can perform the functions of a simple DBMS?
Tasks for self-fulfillment
5.1 Practical task. In the text editor, create a table database called "Notebook" (see Table 5.1) and enter three entries.
5.2 Practical assignment. In the spreadsheets, create a tabular "Notebook" database (see Table 5.1) and enter three records using the form (see Figure 5.1).
5.3 Practical task. In the text editor, create a table database "Computers" (see Table 5.2) and enter six entries.
No comments:
Post a Comment