Describe the types of attributes, Database Management System

Assignment Help:

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.


Related Discussions:- Describe the types of attributes

What is called as an n-way merge, What is called as an N-way merge? The...

What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k

Explain dbms- ddl-domain-alias, Briefly explain each of the following datab...

Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)

Database administrator, Database Administrator One of the main perpos...

Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li

Function module, When a function module is activated syntax checking is per...

When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.

N-ary relationship, For every n-ary relationship type R where n>2, we make ...

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

What are partial and natural key, What are partial, alternate,, artificial,...

What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

Data, Explain three main attributes of data.

Explain three main attributes of data.

Define lock, Define lock? Lock is the most common used to execute the r...

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Define a relation in dbms, Define a relation ? Relation - A relations...

Define a relation ? Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a lis

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd