Describe specialsation and generalization, Database Management System

Assignment Help:

Describe Specialsation and generalization?

Specialisation /generalization: This is a top down and bottom up approach to the design of database. It displays the IS_A relationship among a super class (parent) and related sub-classes. It is represented through inverted triangle in the Chen notation.

Related Discussions:- Describe specialsation and generalization

What is alternate key, What is Alternate Key Alternate Key: This is t...

What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the

Functional dependency in entities, FDs in Entities : Student entity : ...

FDs in Entities : Student entity : Enrolment number → Student name, Address Course Entity :

What are the three data anomalies, What are the three data anomalies that a...

What are the three data anomalies that are likely to occur as a result of data redundancy? Can data redundancy be completely eliminated in database approach? Why or why not? A

Data base administrator, What is the role of a database administrator?

What is the role of a database administrator?

Explain differance between primary and secondary storage, Explain differanc...

Explain differance between Primary and secondary storage ? Primary and secondary storage Computer storage is classified within primary(main) memory and secondary(per

Database part of ldb?, Is it mandatory to declare all the tables in Report ...

Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD

Explain cascade and restrict clauses of drop schema command, Explain severa...

Explain several types of constraints that can be specified using CREATE TABLE command. Explain CASCADE and RESTRICT clauses of DROP SCHEMA command? Constraint Description PRIM

Software engineering, Critically evaluate the bulleted list of information-...

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Cartisian product, Explain the cartesian product in Database Management Sys...

Explain the cartesian product in Database Management System

Compare the nested-loop join and block-nested loop join, Compare the Nested...

Compare the Nested-loop join and block-nested loop join Ans: Nested loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r where b

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages