Briefly describe any four (4) elements of database.

CS Professional · Information Technology and Systems Audit · PYQS · June 2021
Briefly describe any four (4) elements of database.

Answer & Explanation:

Elements of database: The database schema - It is a structure defined by the database administrator of a Database system that refers to the organization of data. It is also called as blueprint of database system. Schema objects - A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users. Objects such as tables or indexes hold data, or can consist of a definition only, such as a view. Indexes - A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and the use of more storage space. Tables - A data table is a set of data elements that is organized using a model of vertical columns and horizontal rows, the cell being the unit where a row and column intersect. Fields and columns - A column is a set of data values of a particular simple type, one for each row of the table. The columns provide the structure according to which the rows are composed. Columns are also called as fields. Records and rows - It is a set of fields called as record or tuple or row. Keys - A key part of a relational database and a vital part of the structure of a table. They ensure each record within a table can be uniquely identified by one or a combination of fields within the table. There are various type of keys we used like super key, candidate key, primary key etc. Relationships - We create different types of entities or tables in the database but these entities should have a kind of relationship between them. There are various kind of relationships like one to one, one to many etc. Data types - These are the characteristics assigned to a particular field that which kind of value will it contain. Like character, integer, float etc.

Topics: Database Management System (DBMS)

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic