Types of attributes, Database Management System

Attributes attached to an entity can be of various types.

Simple

The attribute that cannot be further separated into smaller parts and shows the basic meaning is known as a simple attribute. For instance: The 'First name', 'Last name', age attributes of a person entity signifies a simple attribute.

Composite

Attributes that can be further separated into smaller units and every individual unit have a specific meaning.

For instance:-The NAME attribute of an employee entity can be sub-divided into

First name, Last name and Middle name.

Posted Date: 3/6/2013 6:02:31 AM | Location : United States







Related Discussions:- Types of attributes, Assignment Help, Ask Question on Types of attributes, Get Answer, Expert's Help, Types of attributes Discussions

Write discussion on Types of attributes
Your posts are moderated
Related Questions
what is inverted and multilist structure

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Step 1 . Using Oracle, create the tables identified in the preferred solution for Assignment 2. Technicians (ZipCode, TechnicianID, FirstName, LastName, Street, City, State, Home

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

The cross-section of twisted pair The cross-section of each and every strand of the twisted pair is π/4 square mm. A 10-km length of this type of material, with two strands per

how does Btree differ from a B+ - tree?

What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.