0
The simplest example of a database is a list of items. This could namers of friends, names of plants, TV Channels and so on. eg NAME Brian Thomas Elsie John .. ... .. and so on Each line or row in the list is called a 'Record' (starting with Brian) which has only one Field called NAME. As you add more information about each person you need to add fields (though usually you decide at the beginning of the design phase just what Fields you want - and their type or format eg., numeric, alphanumeric, text, date, wrapped text etc.) Lets add a new field called AGE and add some data to the table.. NAME AGE Brian 21 Thomas 32 Elsie 19 John 47 We now have 4 RECORDS each of which has 2 FIELDS.
Still curious? Ask our experts.
Chat with our AI personalities
Jordan
Beau
ViviA database stores data in a table and the data may or may not be related to other data. The tables in the database also may or may not have any relation with the other tables. A field is the attribute or the column name in a table.
In a database, a "field" is the name of a column. You can think of them as fields on a form or in a record, where the rows are other records.
A field is a particular area of data. I.e. telephone number is a field in a database and will be of type NUMBER.
A field will consist of the field name (i.e. Telephone number) and will consist of a datatype (the type of data to be used in the field, i.e. number, date, boolean, varchar).
Fields in databases also commonly have a size restriction on how many characters can be entered into that field. Some databases put these restrictions on automatically unless overwritten by the user.
Add your answer:
Earn +20 pts
