Describe the two alternatives for specifying structural, Database Management System

Assignment Help:

Describe the two alternatives for specifying structural constraints on relationship kinds?

Relationship kinds have certain constraints in which limit the possible combination of entities that might participate in relationship. An example of a constraint is in which if we have the entities Doctor and Patient, the organization might have a rule that a patient cannot be seen through more than one doctor. This constraint needs to be elaborates in the schema. There are two major kinds of structural relationship constraints on: cardinality ratio, and participation.


Related Discussions:- Describe the two alternatives for specifying structural

xml, basic structure of xm

basic structure of xml

Illustrate system design of an object oriented approach, System Design: An ...

System Design: An Object Oriented Approach Any software systems always try to change and evolve as technology and business rules evolve. The development of information systems

Increased overheads on update-data replication, Increased overheads on upda...

Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

Define Fifth Normal form is concerned with, Define Fifth Normal form is con...

Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.

Complete replication-data replication, Complete replication: It implies ma...

Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

Which component is not included in database environment, Which component is...

Which component is not included in database environment ? A users component is not included in database environment.

Product adder required for ecommerce website, Product adder required for Ec...

Product adder required for Ecommerce website Project Description: Want a product adder for 500 products I have a magento website and need products pulled from site A to my si

Benefits and drawbacks of sequential file organisation, Benefits of Sequent...

Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

The basic 2pl-two phase locking (2pl), Normal 0 false false ...

Normal 0 false false false EN-US X-NONE X-NONE

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