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
What does Aggregation mean?

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

Design an algorithm to implement operations  Each and every operation specified in the functional model could be formulated as an algorithm. The algorithm indicates how operat

Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio

Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

Define canonical cover? A canonical cover Fc for F is a set of dependencies like F logically implies all dependencies in FC and Fc logically shows all dependencies in F.

Demonstrate the UML model Using UML, it is possible to generate code in any of the programming language from UML model (called forward engineering) and rebuild a model from an

MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t