Relational constraints, Database Management System

Relational and E-R Model

There are three types of constraints on relational database that have:

  • DOMAIN CONSTRAINT
  • PRIMARY KEY CONSTRAINT
  • INTEGRITY CONSTRAINT

 

Posted Date: 3/6/2013 5:24:54 AM | Location : United States







Related Discussions:- Relational constraints, Assignment Help, Ask Question on Relational constraints, Get Answer, Expert's Help, Relational constraints Discussions

Write discussion on Relational constraints
Your posts are moderated
Related Questions
What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

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

Define the term- Actors and Data Stores Actors: An actor is the active object which drives data flow graph by producing or consuming values. Actors are attached to inputs a

I want a professional with strong IT background who provide me timely assignments Project Description: I want a professional who can do my assignments for my major i.e. Infor

Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc

Security: Data not needed by local applications is not stored at the site, therefore no unnecessary security violations may exist. But how can we carry out fragmentation? Fragm

what do you understand by enhanced entity-relationship

What is conceptual schema? The schemas at the view level are known as subschema that describe dissimilar views of the database.

Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the