Describe the types of attributes, Database Management System

Describe the types of attributes?

Types of attributes: An attribute's category determines the type of values that are permitted in the attribute. For instance, the value version 1 is not valid for an attribute described as an integer, but the value 1 is valid. Numeric types (such as integer or real) can also be limited to a predefined range through their attribute definition.

Choice : An attribute along with a list of predefined values.

ID Reference: An attribute along with a value which is a Unique ID value from another element. It is typically used for element-based cross-references.

ID References: An attribute along with a value of one or more Unique ID values from another part.

Integer: An attribute along with a whole number value (no decimal parts). Examples of valid integers are 22, -22, and +322. An integer could be described to fall within a range.

Integers: An attribute along with a value of one or more integers. Enter each number on a separate line within the Attribute Value text box.
Real An attribute along with a real number value, with or without a decimal part (the value could also be expressed within scientific notation). Examples of valid real numbers are 2, 22.4, -1 0.22, and 2.3e. A real number could be described to fall inside a range.

Posted Date: 5/10/2013 2:05:10 AM | Location : United States







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

Write discussion on Describe the types of attributes
Your posts are moderated
Related Questions
Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

define anomalies and different types of anomalies with example

What is meant by normalization of data? It is a process of examining the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the prop

Have database built but having problems with some questions that go with the database

Should I select imaging software that allows changes? An imaging system should not give features to edit or alter images. Images generally are formed as safe and secure records

Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r