What are attributes and define its various types?

Database

ATTRIBUTES:- Attributes describe the properties of the entity of which they are associated. A particular instance of an attribute is a value, for e.g... Ram is one value of the attribute name. The domain of an attribute is the collection of all possible values an attribute can have. The domain of name is a character string.

We can classify attributes as following types:

Simple attributes: A simple attribute is an attribute composed of a single component with an independent existence. Simple attribute cannot be further subdivided e.g. of simple attributes are sex, age, salary etc. simple attribute are sometimes called atomic attributes.
Composite attributes: - An attributes composed of multiple component, each with an independent existences is called a composite attribute. Some attributes can be further divided for example the address attributes can be composed of components like street number, area, city, pin code and so on.
Single valued attribute:- A single valued attributes is one that holds a single value for a single entity for e.g. the classroom entity has single value for the room number attribute& therefore the room-number attribute is referred to as being single- valued.
Multi valued attribute:- That holds multiple values for a single entity for e.g. a student entity can have multiple values for the hobby attribute- reading, singing, dancing etc
Derived attribute-:: is one that represents a value that is derivable from the value of a related attribute or set of attributes for e.g. age attribute can derived from the date of birth attribute.

Gallery

Comments

Submit Reviews:

Rate

Review

Security Code

(Enter the characters seen on the image below.)

Promotional Ads

Packers and Movers in Chandigarh
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Kurukshetra

Packers and Movers in Chandigarh
Plot No-123 Sunrise Colony Godown Area Pabhat Zirakpur-140603
Plot No-123 Sunrise Colony Godown Area Pabhat Zirakpur-140603
Jind

Packers and Movers In Satna - VP Max
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Shahdol

Packers and Movers in Sagar
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Ground Floor, Shop 2, JL Institute of Study Center, Tilak Ganj, Ward 14, Sagar, Madhya Pradesh 470002
Sagar

Packers and movers in Mohali
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Mohali

JB Rock Bolts & SN BOLTS
10 A & B Industrial Area (at Vill. Nangal Jarialan)
Distt. Una Himachal Pradesh
Una

Packers and Movers in Zirakpur - Packers and Mover
SCO 3 AKS 2, Bhabat Rd, near Post Office, Zirakpur

Website Design and Development
Bangalore
Hyderabad

JF Engineering Products LLP
Parhar Village, Near Vasai Fata, Eastern Express Highway, Vasai (E), Palghar,
Motilal Nagar Mumbai

Nandishwar Steel
51 M.G. Mahimtura Marg, 3rd Kumbharwada Lane, Opp. Durgadevi Garden
August Kranti Marg Mumbai