Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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
Control Files : The redo and control files logs support the rest of the architecture. Every database must have at least one control file, although you have more than one to guard
Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator. Altern
Problem: (a) Briefly explain the ‘Hierarchical Database Model' using appropriate diagram. (b) List and briefly describe five potential benefits of the database approach comp
What is a disjoint less constraint? Ans: It needs that an entity belongs to no much more than one level entity set. Disjoint less constraint needs that an entity belongs to
#floating point representation is used to store
Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item. After finishing all the operations on
Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema. The entity rela
For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti
Smart Alex Catering Sevice (SACS) is a company offering top class catering staff for prestigious events. The company employs approximately 200 hourly paid contact staff - chefs,
Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd