Explain dbms- ddl-domain-alias, Database Management System

Briefly explain each of the following database terms. Use no more than 2-3 lines for each term.

1. DBMS

2. Update Anomaly

3. Alias (referring to tables in SQL queries)

4. DDL

5. Domian

 

Posted Date: 3/19/2013 5:28:40 AM | Location : United States







Related Discussions:- Explain dbms- ddl-domain-alias, Assignment Help, Ask Question on Explain dbms- ddl-domain-alias, Get Answer, Expert's Help, Explain dbms- ddl-domain-alias Discussions

Write discussion on Explain dbms- ddl-domain-alias
Your posts are moderated
Related Questions
Define multivalued dependency.  What do understand by trivial multivalued dependency?  Ans: A multivalued dependency is a full constraint among two sets of attributes in a rela

Explain Recursive relationship type? Recursive relationship type: A recursive relationship is one in that the similar entity participates more than once in the relationship

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

List and also explain the dissimilar stages of DDLC ?

Differance between Open addressing and chaining for collision resolution ? In open addressing , proceeding from the occupied position specified by hash address the program che

Prove that a relation which is 4NF must be BCNF.   Ans Let R be in 4NF.  Suppose it is not in BCNF.  Hence, there exists an FD X→Y in R such that x is not a super key. Although

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin

Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to

Consider the subsequent relation   Professor (Pfcode, dept, head, time)   It is assumed that      (i) A professor can work in much more than one