Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
consider the subsequent relation schemes project project projectname chiefarchitect employee emp empname assignedto project emp give
differentiate between logical database design and physical database design show how this separation leads to data independencebasislogical database
what is foreign keyforeign key - let there are two relations in tables r and s any candidate key of the relation r that is referred in the relation s
what is candidate keycandidate key - a candidate key of an entity set is a minimal superkey which uniquely identifies each row in the
what is primary keyprimary key - primary key is one of the candidate keys which uniquely identifies each row in the
explain five duties of database administrator 1 dba administers the three stages of the database and in consultation along with the whole user
what is disadvantages of dbms 1 cost of software and hardware and migration - a important disadvantage of the dbms system is cost2 reduced response
what are the advantages of dbms 1 centralized management and control - one of the major advantages of using a database system is in which the
what is a databasedatabase - basically in simple terms a database is a collection of inter related data andor information stored so which it is
which two files are used during operation of the dbmsdata dictionary and transaction log are two files used during operation of the
which data type can store unstructured dataraw data type can store unstructured
a table joined with itself is called a table joined with itself is known as self join table normal 0 false false false en-in x-none
which method of access uses key transformationa hash method of access uses key
what is a virtual table that draws its data from the result of an sql select statementview is a virtual table that draws its data from the result of
in e-r diagram how generalization is representedin e-r diagram generalization is represented by triangle
which data manipulation command combines the records from one or more tables join data manipulation command combines the records from one or more
what function divides one numeric expression by another and returns the remaindermod function divides one numeric expression by another and returns
a b-tree of order how much children m has maximum m has maximum m mchildren in a b
what is the aim of logical schema the main motive of the logical schema is to ensure the portability of procedures and models on various physical
which operator is used to compare a value to a list of literals values that have been specifiedbetween operator is used to compare a value to a list
to delete a particular column in a relation which command is used to delete a particular column in a relation alter command is
hierarchical model is also known bya hierarchical model is also known as a tree
in e-r diagram how relationship type is represented in e-r diagram relationship type is represented as a
what will be create when a primary key if combined with a foreign keya primary key if combined with a foreign key it creates parent-child
where does view definition storeda view definition is permanently stored as part of the