Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
create role named roletable that allows a user to create tables using roletable allow users kripa and reena to create tablescreate role roletable
consider employee table of i and list names of departments for which average salary for department is more than 10000select dname from dept where
consider the table student and list names of students in the departments other than maths and computerselect stdname frm student where deptname not
a constraint named lessthan20 was defined on the field dateofbirth of table student delete this constraintalter table student drop constraint
consider student stdid stdname dateofbirth phone deptname put the data for a student with student id200 name arun birth date 1 february 1985 phone
consider employee eno ename esalary dcode deptdcode dname and dependent depndtname eno relation show the names of employees in purchase and accounts
consider the following relationsbranch bno street area city pcode telno faxno staff sno fname lname address position salary bno express the
differentiate between primary and secondary storageprimary and secondary storage - primary storage device stores the data temporarily primary storage
differentiate between key and superkeykey and superkey - a key a single attribute or a combination of two or more attributes of an entity set in
define database layerthe database layer defines the data formats used in the
differentiate between procedural and non procedural languages procedural and non procedural languages - a procedural language specifies the
explain the relevance of data dictionary in a database systemdata dictionary is a database in its own right residing on the disk that consist of meta
a well-maintained relational dbms has a high level of data integrity what features of a relational dbms contribute towards this level of
explain what is aggregation aggregation this is used whenever we intend to show a relationship between an entity and the relationship there is no
describe specialsation and generalizationspecialisation generalization this is a top down and bottom up approach to the design of database it
describe identifying relationshipidentifying relationship it is relationship among strong entity and a weak entity it is represented through a doubly
explain the three data models namely relational network and hierarchical and evaluate their relative advantages and disadvantageshierarchical model
explain the disadvantages of file oriented approachin the oriented approach applications are designed in isolation design of application is optimized
explain retrieval in qberetrieval in qbe a gui for expressing queries based on the domain relational calculus drc actually invented before guis very
explain group by clause in sqlgroup by clause in sql the group by clause can be used in a select statement to collect data across multiple records
what is oracle databse structureoracle database structure the relational model has three main aspectsstructures structures are well-defined objects
write short note on data modelsdata models a data model is an abstract model which elaborates how data is represented and accessed the term data
consider the relations described below physician regno name telno citypatient pname street city visit pname regno dateofvisit fee where the regno and
using sql create a view rs for the relations r and s the view consists of the columns a and d renamed as x and y in that order insert a tuple lt10
what is a view in sql when can views be updated a view is a virtual table which consists of columns from one or more tables through it is same to a