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

Describe the host language, Describe the host language? Host Language:...

Describe the host language? Host Language: You could write applications along with SQL statements embedded inside a host language. The SQL statements give the database inter

How many types of users works on database, How many types of users works on...

How many types of users works on database? Users are differentiated through the way they expect to interact along with the system (i) Application programmers-interact with

Differences between structured data and unstructured data, Explain the diff...

Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric

We need help in booking system for golf business, We need help in Booking S...

We need help in Booking System for Golf Business Development of a web based booking system which permits clients to book golf lessons with the following features- a) 4 user p

Information infrasctructure., what factors might influence a company to out...

what factors might influence a company to outsource its IT infrascture.

Horizontal Fragmentation, I want to fragment existing table using java code...

I want to fragment existing table using java code... help me..!!

What is the need for triggers, What is the need for triggers? Triggers ...

What is the need for triggers? Triggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular conditions are met.

Extended star schema, Northwind Pty Ltd sells a variety of food products th...

Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei

Database, Three way to handle missing field val

Three way to handle missing field val

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