What is inheritance, Database Management System

Assignment Help:

What is inheritance? Define it in detail?

 Inheritance

Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then inheritance at the level of labels.

Type inheritance

Assume that we have the following type definition for people

create type person

(name varchar(20)

address varchar(20))

Table inheritance

Create table people of person

The consistency requirements for sub tables are

1. Each tuple of the sub table can correspond to at most single tuple in each of its immediate sub tables.

2. SQL:1999 has an additional constraint that all the tuples corresponding to each other must be derived from single tuple .

 


Related Discussions:- What is inheritance

Proposed information analysis, Add generation capabilities and/or tailor th...

Add generation capabilities and/or tailor the built-in functionality of generator. This enables you to produce "all" the test data for the MySQL tables you produced in the previous

What are the basic merits of decomposition, The basic merits of decompositi...

The basic merits of decomposition. The Advantages of Decomposition 1.  Separate person can work on each subsystem. 2.  A particular software engineer can specialize in a

Create a customer database and apply queries, For the question given below,...

For the question given below, you are required to submit design and implementation documentation as described over the page. Design, implement (in Java), test and document a set of

What are the advantages of using a dbms, What are the advantages of using a...

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Discuss the three level architecture of dbms, PRINCIPLES OF DATABASE 1....

PRINCIPLES OF DATABASE 1. State the following terms: a) Database b) Database Management System c) Entity d) Attribute e) Relationship 2. Discuss the Three Level Architecture

Equi-join, explain equi-join using illustration

explain equi-join using illustration

Each statement should have a where clause, Submit SQL SELECT Statements to ...

Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines: You must submit at least 5 SELECT Statements. Each

MULTI-LIST FILE ORGANIZATION, sir, could anybody help me in getting complet...

sir, could anybody help me in getting complete information about the mentioned topic

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

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