Explain derived and non-derived attribute, Database Management System

Assignment Help:

Explain Derived and Non-Derived Attribute?

In few cases, two or more attribute values are related, for instance, Age and BirthDate attributes of a person. For specific person entity, the value of Age can be determined from the current date and the value of that person's BirthDate. Therefore, the attribute Age is known as derived attribute and the attribute BirthDate is known as non-derived or stored attribute.

Related Discussions:- Explain derived and non-derived attribute

What is conceptual schema, What is conceptual schema? The schemas at th...

What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

Data, Explain three main attributes of data.

Explain three main attributes of data.

Describe in brief about object oriented design, Describe about Object orien...

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

Which operations need the participating relations to union, Which operation...

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Define the third normal form, Define the Third Normal Form: The third ...

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Describe hashing in dbms, Describe Hashing in DBMS? Hashing: Hashing ...

Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

Create an index for the table client, Create an index for the table Client,...

Create an index for the table Client, field CLIENT_NO of Q ? Command: CREATE INDEX client_client_no ON client(client_no);

Modify - referential integrity, Update or Modify operation alters the exist...

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

Sql, sql is relationally complete-justify

sql is relationally complete-justify

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages