Introduction to relational

Introduction to relational databases. Access is a tool for database administration, designed by Microsoft to work under Windows OS. We must, first of all, understand that it is a database, and it then defines the term data. Concept of data Any piece of information may be called data. These figures should be significant, so it can be used in everyday life. The data and facts are represented by values such as numbers, strings, or symbols to explain any meaning. The data are an important resource in the operation and management of an organization. Effective management of the data makes the organization responsible and successful. Introduction to relational databases. Definitions and terminology. Database can be defined as a collection of data and objects related to a theme or purpose. For example, the complete data of employees of a company, product inventory in a warehouse, the registered houses in an estate, or registered guests in a hotel. We can deduce, therefore, that almost all companies need to store the information handled in an organized manner, and a database is the optimal tool for this purpose. Table is the basic structure of a system of administration of relational databases. In Access, a table is an object that stores data in rows and columns. The rows are called records and columns fields. The data stored in a table refer to a specific topic within the database, for example, personal data of employees, overtime hours worked by each employee, the various units of the company, the cities where the company operates, data providers of a warehouse, customer data. The success of a good database design is determined by how consistent and logic that are the tables that we implement. Campo is the component of a table that contains a specific element of information. For example, full name, address, city, product codes, product values, and so on. Fields in a table correspond to the columns. Register A set of data (attributes) about an event, person, place, or some other element in a table. For example, an employee’s personal data, private data of a product. Each record contains all fields from the table that contains it. The records in a table correspond to the rows. Relational Database is a collection of data whose main feature is that data can be stored and managed in tables.