DatabasesandDatabaseManagementSystems.pptVIP

Databases and Database Management Systems (Based on Chapters 1-2) DBMS concepts and architecture ER model Relational Databases Relational Algebra Query Languages (SQL) Storage and Indexing (optional) Database Design : Normalization and Functional Dependencies Transaction Processing Concurrency Control and Recovery Emerging Trends in Database Technology – Web Data management, XML, Web mining, Text Required: Elmasri, R. and Navathe S., Fundamentals of Database Systems, 3rd Edition, Addison-Wesley, 2000. ISBN – 0-8053-1755-1 ? ORACLE Reference: ORACLE 8: The Complete Reference, by George Koch Kevin Loney, Osborne McGraw-Hill, Inc., 1998. 1. Basic Definitions Database: A collection of related data. ? Data: Known facts that can be recorded and have an implicit meaning. ? Mini-world: Some part of the real world about which data is stored in a database. For example, consider student names, student grades and transcripts at a university. ? Database Management System (DBMS): A software package/ system to facilitate the creation and maintenance of a computerized database. It defines (data types, structures, constraints) construct (storing data on some storage medium controlled by DBMS) manipulate (querying, update, report generation) databases for various applications. ? Database System: The DBMS software together with the data itself. Sometimes, the applications are also included. 2. Example of a Database(Conceptual Data Model) Mini-world for the example: Part of a UNIVERSITY environment. ?Some mini-world entities (Data elements): - STUDENTs - COURSEs - SECTIONs (of COURSEs) - (academic) DEPARTMENTs - INSTRUCTORs ?Some mini-world relationships: - SECTIONs are of specific COURSEs - STUDENTs take SECTIONs - COURSEs have prerequisite COURSEs - INSTRUCTORs teach SECTIONs - COURSEs are offered by DEPARTMENTs - STUDENTs major in DEPARTMENTs Figure 1.1: A simplified database system environment, illustrating the concepts and terminology discussed in