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
What is meant by normalization of data? It is a process of examining the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the prop

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

Problem: A DBMS built for Online Transaction Processing (OLTP) is usually regarded as unsuitable for data warehousing. Each system is designed with a different set of requireme

What are the two types of errors? The two types of errors are: a) Logical error b) System error

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am


, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans