which databse element is used for collecting the data from the user
Answers
Answer:
Advertisement
The Elements of a Database
by Ryan Stephens and Ronald Plew
There are a number of key terms and concepts that you must be aware of in order to understand and work with databases. Do you know the key terms?
What elements comprise a database? This article deals mainly with the objects that comprise a database. Several concepts are worthy of coverage within the scope of the database as it relates to database design. As you work with data and databases, you will see how the origination of business information and databases is formulated into database elements. The intent here is to provide a brief coverage of basic database elements to provide you with a basic understanding of the elements found in a database.
Several topics are discussed in the following sections. These topics include:
The database schema
Schema objects
Indexes
Tables
Fields and columns
Records and rows
Keys
Relationships
Data types
Database Schema
A schema is quite simply a group of related objects in a database. Within a schema, objects that are related have relationships to one another, as discussed earlier. There is one owner of a schema, who has access to manipulate the structure of any object in the schema. A schema does not represent a person, although the schema is associated with a user account that resides in the database.
The three models associated with a schema are as follows:
Advertisement
The Elements of a Database
by Ryan Stephens and Ronald Plew
There are a number of key terms and concepts that you must be aware of in order to understand and work with databases. Do you know the key terms?
What elements comprise a database? This article deals mainly with the objects that comprise a database. Several concepts are worthy of coverage within the scope of the database as it relates to database design. As you work with data and databases, you will see how the origination of business information and databases is formulated into database elements. The intent here is to provide a brief coverage of basic database elements to provide you with a basic understanding of the elements found in a database.
Several topics are discussed in the following sections. These topics include:
The database schema
Schema objects
Indexes
Tables
Fields and columns
Records and rows
Keys
Relationships
Data types
Database Schema
A schema is quite simply a group of related objects in a database. Within a schema, objects that are related have relationships to one another, as discussed earlier. There is one owner of a schema, who has access to manipulate the structure of any object in the schema. A schema does not represent a person, although the schema is associated with a user account that resides in the database.
The three models associated with a schema are as follows:
Sponsored Content

Market leaders in enterprise, SMB, social, and mobile CRM
By TechnologyAdvice
In this buyer’s guide, we’ll look at four primary categories of CRMs based on features and business application
The conceptual model, also called the logical model, is the basic database model, which deals with organizational structures that are used to define database structures such as tables and constraints.
The internal model, also called the physical model, deals with the physical storage of the database, as well as access to the data, such as through data storage in tables and the use of indexes to expedite data access. The internal model separates the physical requirements of the hardware and the operating system from the data model.
The external model, or application interface, deals with methods through which users may access the schema, such as through the use of a data input form. The external model allows relationships to be created between the user application and the data model. Figure 1 depicts a schema in a relational database.
Table
A table is the primary unit of physical storage for data in a database. When a user accesses the database, a table is usually referenced for the desired data. Multiple tables might comprise a database, therefore a relationship might exist between tables. Because tables store data, a table requires physical storage on the host computer for the database.