Introduction to Database Management System

Aeroplane_No Departure_City anomalies application programs architecture B-tree candidate key Cartesian product client column name Consider constraints cost CPU’s data item data mining data type data warehouse database system DBMS DDBMS deadlock defined delete Department Dept Dept-ID Disadvantages disk distributed database DName domain domain relational calculus E-R diagram E-R model execution plan Explain file organization foreign key functional dependency graph hashing insert key attributes key value lock Name Salary node NULL values Number(4 outer join Output parallel databases performance pointer primary key protocol query language query optimization query processing query tree read(B record type recovery relation Employee relational algebra relational model relationship set result retrieve rollback RollNo Schedule_Master search key sequential file server Shared Nothing Architecture shown in Figure specify storage stored Student Syntax table name techniques timestamp tuple relational calculus update variable weak entity