Difference Between Attributes and Fields

We ask our teacher that what is the difference between attribute and fields. He just replied us like this written below.

Attributes means the properties of the entity. For example, there is an entity STUDENT. Its attributes can be,

Stu_ID
Name
Address
Class
and so on in the Entity Relationship Model.

These attributes will become fields when we talk about the relations / tables in relational databases. So it can be called as a location in a table in which a particular type of data is stored.

For example, EMPLOYEE-RECORD might contain fields to store
Last-Name
First-Name
Address
City
State
Zip-Code
Hire-Date
Current-Salary
Title
Department and so on.

Individual fields are characterized by their maximum length and the type of data,

for example

alphabetic
numeric
financial that can be placed in them.

The facility for creating these specifications usually is contained in the data definition language (DDL). In relational database management systems, fields are called columns.

More Definitions regarding this topic.

Entity:
An entity you can say an object which we want to model and want to store some information about. Basically can say it's real life thing which we will model using database. Entities either concrete or abstract. e.g. company staff, a company, peoples of hospitals, Places, Events which have relevance to the database.

DDL Data Definition language:
Data Definition Language are internal command structure of the database which include miscellaneous commands. This language uses to create or alter the database objects or used to remove indexes and users. Some example of commands ALTER, DROP and CREATE.

Entity Relationship Model (ER-Model):
Let's suppose you are designing hospital management system which graphically represent your whole criteria. That graphic representation called your logical ER Model. This will used to create a database, relationship of entities(objects).

Post a Comment

0 Comments