Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
find out the names and company names of all employees sorted in ascending order of company name and descending order of employee names of by which
find out the names of all employees who work for first bank corporation from databaseselect employeenamefrom workswhere companyname lsquofirst bank
create table employee and enter employee data in sqlconsider the following relational schemas employee employeename street city works employeename
short note on mid square method of hashingmid square method of hashing in the method midsquare hashing the key is squared and the address selected
write a short note on oracle instanceoracle instances an instance is the executed oracle software and the memory they use it is the instance which
describe the types of attributestypes of attributes an attributes category determines the type of values that are permitted in the attribute for
explain weak and strong entity setsweak and strong entity sets a physically powerful entity set has a primary key all tuples in the group are
describe logical data independence logical data independence - it is the capacity to modify the conceptual schema without having to change external
describe physical data independence physical data independence - it is capacity to modify the internal schema without having to change conceptual
explain data independence data independence is the capacity to modify the schema at one stage of a database system without having to change the
explain foreign keyforeign key - let there are two relations tables r and s any candidate key of the relation r that is referred within the relation
explain alternate keyalternate key - all the candidate keys except primary key are known as alternate
explain candidate keycandidate key - a candidate key is a minimal superkey that can be used to uniquely identify a tuple in the
what is key key - a single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances
consider the following relational schema person ss name address car registrationnumber year model accident date driver carregno owns ss
describe application programming interfaceapplication programming interface - commercial sql implementations take one of the two primary techniques
explain view in rdbmsview - a view is a relation virtual rather than base and could be used in query expressions which is queries can be written by
explain what is rdbms rdbms - rdbms is a database management system dbms which stores data within the form of relations relational databases are
explain cursors in sqlcursors in sql - an object used to store the output of a query for row-through-row processing through the application programs
what is nested queries explain in detailsnested queries - a select query could have subquerys in it while a select query having another select query
explain the integrity constraints not null unique primary key with an example each is the combination not null primary key a valid combination
describe a technique for direct search explain how data is stored within a file so which direct searching can be performedfor a file of unordered
explain sorted file with advantages sorted file the sort utility shall perform one of the subsequent functions1sort lines of all the named files
explain heap file with advantagesheap file is an unordered set or a group of records stored on a set of pages this class gives basic support for
the following information was obtained from a host computer 000517176507 74125228541270 gt 642541286625 s 268856040926885604090 win 16384 ltmss