Attributes also have these properties:
Attributes can be one of the following source categories:
An attribute whose value is supplied to the business, such as a client's name
An attribute whose value is invented or calculated and never changes, such as an employee number
An attribute whose value is derived from the values of other attributes, such as the total of an order
The collection of possible values for an attribute:
A character string
Numbers
A valid date
A valid time
A combination of date and time, to the level of microseconds
Double byte character set
A combination of double byte and single byte character sets
Restricts a domain to some subset of permitted values
The maximum number of characters or digits for each of the attributes' values
Of its total length, the number of digits to the right of the decimal place
Whether the attribute must always contain a value
Indicates if the attribute value can contain lowercase and uppercase characters. If not, the tool automatically converts them to uppercase.
If selected, the database only stores the actual length of the text string
We will see each of these again when we build the data model.
|
Copyright © 2013 CA.
All rights reserved.
|
|