Database Systems is a subject which gives you a clear cut information about database, like how you can store data in database. Different types of databases like What is relational database? etc.
Things you will cover in this course:
- Basic database concepts,
- Database Architecture,
- DB Design Life Cycle,
- Schema Architecture,
- Conceptual, Logical and physical database Modelling
- and design, Entity Relationship diagram (ERD), Enhanced ERD ,Relational
- data model,
- mapping ERD to relational model, Functional dependencies and
- Normalization, Relational Algebra, Structured Query language (SQL),
- Transaction processing, concurrency control and recovery techniques, Query
- optimization concepts.
Reference material:
1. Database Systems A Practical Approach to Design, Implementation, and Management, 4th Edition, Thomas Connolly, Carolyn Begg, Addison Wesley, 2005.2. Modern Database Management by Fred McFadden, Jeffrey Hoofer, Mary Prescott, Prentice Hall; 11th Edition (July 26, 2012). ISBN-10: 0132662256
3. Fundamentals of Database Systems by R. Elmasri and S. Navathe. 6th Edition, Addison-Wesley (2010). ISBN-10: 0136086209.
4. Database Design and Relational Theory: Normal Forms and All That Jazz by C. J. Date, O'Reilly Media; 1st Edition (April 24, 2012). ISBN-10: 1449328016.
0 Comments