Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
the natural join is equal to which productthe natural join is equal to combination of projection and cartesian
consider the join of a relation r with relation s if r has m tuples and s has n tuples then the maximum size of join isif r has m tuples and s has n
an instance of relational schema r a b c has distinct values of a including null values then a is a candidate key or notif relational schema r a b c
in e-r diagram how derived attribute are represented in e-r diagram by dashed ellipse derived attribute are
what it creates while a primary key is combined with a foreign keyit creates parent-child relation ship between the tables that connect them while a
using relational algebra which query finds customers who have a balance of over 1000 using relational algebra pi customername sigma balance
the physical location of a record is determined by which mathematical formula that transforms a file key into a record locationthe physical location
a file manipulation command that extracts some of the records from a file is called a file manipulation command that extracts some of the records
what does data dictionary is a special file contains the data dictionary is a special file contain the name of all fields in all filesthe width of
which model is record based logical modelnetwork modelis basically known as record based logical
which database object does not physically exista view database object does not physically
which is another name for weak entitychild is another name of weak
which of the operations constitute a basic set of operations for manipulating relational datarelational algebra operations constitute a basic set of
a set of possible data values is calleda set of possible data values is called as
what are the comparison operator in sql comparison operator in sql are like and
the result of the union operation between r1 and r2 is a relation that includesthe result of the operation between r1 and r2 includes all the tuples
which are the two ways in which entities can participate in a relationshiptotal and partial are the two ways in which entities can participate in a
which database level is closest to the usersexternal database level is closest to the
the users who use easy-to-use menu are called the users who use easy to use menu are called as naiumlve
which is a legal expression in sqlselect name from employee is a legal expression in
which is an advantage of viewthe advantages of view is data security derived columns and hiding of complex
what is the full form of ddlddl is stand for data definition
which operations need the participating relations to be union compatiblea union intersection and difference operations need the participating
what is rdbms terminology for a rowa tuple is a rdbms terminology for a
which is a valid sql typea valid sql should be in character it is should be numeric and