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

Purchase orber , Run the following queries. For each query show 1) What yo...

Run the following queries. For each query show 1) What you expect the output to be based upon the data 2) the SQL code and 3) the output running the query in Oracle. 1. Show all c

Explain the advantages of database management system, Advantages of Databas...

Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Transaction, Draw the precedence graph of the following schedule and determ...

Draw the precedence graph of the following schedule and determine whether the schedule is serializable. (Note that all instructions, except lock and unlock, are omitted. We assume

Project, I need help in doing my dbms project

I need help in doing my dbms project

Discuss on transmission impairments, Question 1 Discuss on transmission im...

Question 1 Discuss on transmission impairments Question 2 What is framing? Question 3 Write a note on 10Base2 10Base- T Question 4 Explain the rev

Explain cursors in sql, Explain cursors in SQL? Cursors in SQL - An o...

Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs

Database design and documentation, A use case diagram giving a pictorial ov...

A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als

What are the various symbols used to draw an e-r diagram, What are the vari...

What are the various symbols used to draw an E-R diagram? Explain with the help of an example how weak entity sets are represented in an E-R diagram. Various symbols used to d

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