free classified ads and leads
domain website price


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:

      1. 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.
      2. 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.
      3. 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.
      4. 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
      5. 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.

 

Bookmark and Share




Gallery

Related Topics

Comments



Submit Reviews:


(Enter the characters seen on the image below.)



Promotional Ads

Advertisement

Bhansali Overseas
Shop No 12, Bhabha Chawl, Ground Floor, Near H.N. Reliance Hospital,Khetwadi 13th Lane, Mumbai - 400004, Maharashtra, .
Motilal Nagar Mumbai

Rajendra Industrial Flanges
97/99, Shiv Vilas Building, 2nd Pathan Street, 5th Kumbharwada
August Kranti Marg Mumbai

Rann Utsav
301, KALING, Behind Bata Showroom, Opp. Mount Carmel Convent school, Ashram Road – 380009
Ahmedabad

Sangeeta Metal Corporation
Office No. 5A & 5B, Gr. Fl. Sabu Bhavan, Ardheshir Dadi Cross Lane,Opp. Madhav Bagh Temple, Near C.P. Tank Circle, Mumbai � 400004.
Andheri East - Mumbai

General Physician | Consultant Physician in Ahmeda
408, Fourth Floor, Sigma Icon 2, above Qaraar Restaurant, Shyamal, Ahmedabad, Gujarat 380015
Ahmedabad

Zeligz Webstore
F-135 Industrial area , Phase 8B , Mohali, Punjab 160059, IN
Chandigarh

Kalp Industries
Devashish Bldg no.20 Off no.5 Gr Floor, 1st Carpenter Street. Mumbai – 400 004
Nehru Nagar Mumbai

Cenforce 100 mg
571 Monroe Avenue
Hialeah

Galaxy Thermoplast Pvt. Ltd.
29A, Mira Co. op. Industrial Estate, Off Western Express Highway, Mira Road East
Mira Road Thane

Access Cover Manufacturer - Crescent Foundry
#406, Lords Building, 7/1 Lord Sinha Rd., Kolkata, 700071, IN
Kolkata