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
Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

What are metrics for choosing the best algorithm? Matrices for choosing the best algorithms are as below: Computational complexity Ease of understand ability and im

What are composite attributes? Composite attributes can be separated in to sub parts.

What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.

Explain the Natural join Natural join is a binary operator which is written as (R* S) in which R and S are relations. The effect of the natural join is the set of all combinati

Define the terms   i) DDL   ii) DML   DDL: Data base schema is specified by a set of definitions expressed by a special   language known as a data def

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience