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

Project, the of super market system done in database

the of super market system done in database

What is meant by data-transfer rate, What is meant by data-transfer rate? ...

What is meant by data-transfer rate? The data-transfer rate is the rate at which data can be retrieved from or kept to the disk.

Information Technology, What benefits can a company gain by managing its ow...

What benefits can a company gain by managing its own information infrastructure and servicea

Objectives-transactions and concurrency management, Objectives After Re...

Objectives After Reading this part, you should be able to: Explain the term CONCURRENCY; Describe the term transaction and concurrent transactions; Talk about co

State in detail about data flow diagram, What is a Data Flow Diagram?  ...

What is a Data Flow Diagram?  Data Flow Diagram: A data flow diagram is the graph that shows flow of data values from their sources in objects in the course of processes whic

Gui interfaces, Draw the database using the ER approach and then make the t...

Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the

DBMS, to develop elrctronic database from manual forms

to develop elrctronic database from manual forms

Determine the derived attribute to avoid re-computation, Determine the Deri...

Determine the Derived attribute to avoid re-computation Each class box consists of an ordered list of attributes and operations, each represented as a next string. We can find

Explain briefly concurrent task by taking an example, Explain briefly concu...

Explain briefly concurrent task by taking an example. Concurrent Task- The concurrent occurrence of more than one event is called concurrent task. Operating systems can handl

Normalization, Consider a bank that has a collection of sites, each running...

Consider a bank that has a collection of sites, each running a database system. Suppose the only way the databases interact is by electronic transfer of money between one another,

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