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

Database administrator, The Database administrator (DBA) uses the data dict...

The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p

Database backup, Discuss the importance and characteristics of database bac...

Discuss the importance and characteristics of database backup and recovery procedures, then describe the actions that must be detailed in backup and recovery plan

Draw an er diagram with primary key for a farm, Draw an ER diagram that rep...

Draw an ER diagram that represents the information described below. Show all entity sets, relationship sets, primary keys, and the mapping cardinality of the relationship sets.

What are the disadvantages of file processing system, What are the disadvan...

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

Project, write a database program for concurrency transaction in a bank

write a database program for concurrency transaction in a bank

What is dbms and what are functions of dbms, What is DBMS and what are func...

What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical

Information infrasture, what benefit can a company gain by managing its own...

what benefit can a company gain by managing its own infrasture and services

Update city of first bank corporation to new delhi, Change the city of Firs...

Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

I need automated trading engine for crypto currencies, Project Description:...

Project Description: Looking to prepare automated trading engine for alternate cyprto currencies starting with Cryptsy, finally integrating into other exchanges. Need to work wi

Reflects organisational structure, Reflects organisational structure: Many ...

Reflects organisational structure: Many organizations are distributed over various locations. If an organisation has many offices in dissimilar cities, databases used in such an ap

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