Synonyms, Database Management System

Synonyms It allows short names or alternative names for objects.

Example:

              CREATE SYNONYM D30

              FOR EMPD30;

  Now if we give command:

             SELECT * FROM D30;

NAME

MINSAL

MAXSAL

AVGSAL

---------------------

------------

-------------

--------------

ACCOUNTING

1300

5000

2916.6667

RESEARCH

800

3000

2175

SALES

950

2850

1566.6667

 

Posted Date: 3/11/2013 2:33:00 AM | Location : United States







Related Discussions:- Synonyms, Assignment Help, Ask Question on Synonyms, Get Answer, Expert's Help, Synonyms Discussions

Write discussion on Synonyms
Your posts are moderated
Related Questions
Write short notes on domain relational calculus The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole t

Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that

How does a query tree represent a relational algebra expression?      Ans: This includes transforming an initial expression (tree) into an equivalent expression (tree) that is

ERD Diagram of Medical Recruitment Agency?

Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

Provide Examples of different types of Time and Date formats.  It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation

Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati