Database Design: data requirements, entity relationship diagrams, relational data model, integrity constraints, key constraints, types, integrity maintenance. Relational Queries: SQL, Boolean combinations of queries, aggregation, duplicate elimination, nested queries, negation, views, insertions, deletions, updates, command level interfaces, integration with programming application Query execution and optimization: data storage principles, file organization, indexing, indexes in commercial DBMSs, relational algebra, query execution plans, cost estimation of plans, interpretation of plans, physical database design. Concurrency: transactions, schedules, serializability, concurrency control protocols, locking, two-phase-locking, time stamp-based concurrency control. Emerging Database Trends: data warehousing, distributed databases, and alternative database models such as XML, document, object, and graph stores
- Teacher: Dr. Hassan Ibrahim 47
- Teacher: Eng. Hazem Aboud 67