Write short notes on:
(a)
DBMS
(b)
Field Type
(C)
Record
(d) Field Name
(e) Tables
Answers
DBMS=
DBMS Tutorial – Database Management System notes. DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data.
FIELD TYPE =
· A type of field that can only contain an entity reference, such as Asset, Shot, Person, Note, etc. Entities are linked together
RECORD =
A record is composed of fields and contains all the data about one particular person, company, or item in a database. In this database, a record contains the data for one customer support incident report. Records appear as rows in the database table.
FIELD NAME =
In computer science, data that has several parts, known as a record, can be divided into fields. Relational databases arrange data as sets of database records, so called rows. Each record consists of several fields; the fields of all records form the columns. Examples of fields: name, gender, hair colour.
TABLES =
In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. A table has a specified number of columns, but can have any number of rows.