Describe integrity and security, Database Management System

Assignment Help:

Describe integrity and security?

a) Domain constraint

b) Referential integrity

A value that appears in one relation for a given set of attributes also appear for a particular set of attributes in another relation. This condition is known as referential integrity.

a) Referential integrity and E-R models

b) Database modification

c) Referential integrity in SQL

Related Discussions:- Describe integrity and security

Demonstrate the design of associations, Demonstrate the Design of associati...

Demonstrate the Design of associations During object design phase we must design a strategy to implement associations. Association may be unidirectional or bi-directional. Wha

Explain data dictionary in short, Explain Data Dictionary in short?

Explain Data Dictionary in short?

Define the terms - physical schema and logical schema, Define the terms 1)...

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest lev

Advantages and disadvantages of using a database system, What are the advan...

What are the advantages and disadvantages of using a database system. Sol. Advantages of Database System (DBMS) : (1) Data Redundancy and Inconsistency: Since differen

Project on designing and creating a database , This project will involve de...

This project will involve designing and creating a database for an organization. In the design of a database, there is no single "perfect" design. So your database design may not

Joins, how can apply joins on table

how can apply joins on table

List the string operations supported by sql, List the string operations sup...

List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas

Define deadlock prevention, Define Deadlock prevention These protocols...

Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

Produce a set of relations - normalisation, Produce a set of relations (equ...

Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog

Data mining, 1.Why we need data mining? Give an example to illustrate your ...

1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages