Explain nested relations, Database Management System

Assignment Help:

Explain nested relations?

Nested relations

The assumption of INF is a natural one in the bank examples we have considered.

However, not all applications are best modelled by INF relations.

The nested relational model is an extension of the relational model in which domains might be either atomic or relation valued.

We illustrate nested relations by an example from a library. Assume we store for every book the following in formations

 Book title

Set of authors

Publishers

Set of keywords

We can see that if we describe a relation for the preceding information, several domains will be monatomic

Authors

Keywords

Publishers

Complex types

Collection and large object types

Create table books(

...

Keyword-set setoff(varchar(20))

           ...

            )

            Structure types

            Creation of values of complex types

 


Related Discussions:- Explain nested relations

What is relational calculus, What is Relational calculus? Relational c...

What is Relational calculus? Relational calculus is a Non- Procedural language.

Explain optimistic locking and pessimistic locking, Explain the difference ...

Explain the difference between optimistic locking and pessimistic locking. Optimistic locking supposes no transaction conflict will occur and deals with the consequences if it

What is known as sequential file organization, What is known as sequential ...

What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

Explain the timestamp ordering protocol, Timestamp Ordering Protocol A ...

Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

To delete a particular column in a relation which command, To delete a part...

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Disadvantages or unsecure, In Database software have only pure security or ...

In Database software have only pure security or some dis secured by administrator?

Data model in DBMS, how many types of data model in DBMS? explain data abst...

how many types of data model in DBMS? explain data abstraction with its different level

What are the several forms of identity, What are the several forms of ident...

What are the several forms of identity? a) Value b) Name c) Built-in

Lock, intent locking

intent locking

Keys, #questiontypes of keys examples..

#questiontypes of keys examples..

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