Explain the use of constraints in functional model, Database Management System

Assignment Help:

Explain the use of constraints in functional model with suitable example.

A constraint shows relationship between two objects at same time, or among various values of the same object at different times. A constraint can be expressed as a total function or as the partial function. For instance, a coordinate transformation may specify that scale factor for x-coordinate and the y-coordinate will be equal. This constraint completely defines one value in terms of the other values

Related Discussions:- Explain the use of constraints in functional model

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?

Describe identifying relationship, Describe identifying relationship? ...

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Design of a database, Ask questioYou are the database administrator in a un...

Ask questioYou are the database administrator in a university. You have been tasked to come up with a new database for the University. Using the stages in Database Life Cycle come

Explain the concept of deadlock, Question: In a multi-user database env...

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Project, I have a small project that contains 3 deliverable s. I have done ...

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

Clinic, Need a sample of a clinic database relationships

Need a sample of a clinic database relationships

Explain clustering file organization, Explain Clustering file organization ...

Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that

ER model, coventions for displaying an ER schema as ER diagram

coventions for displaying an ER schema as ER diagram

Define tuple variable, Define tuple variable Tuple variable is a type o...

Define tuple variable Tuple variable is a type of variable whose domain is the set of all tuples.

Prepare an erd for the scenario, Question: (a) Prepare an ERD for the s...

Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages