Database Systems: A Practical Approach to Design, Implementation, and ManagementAdopting a pragmatic approach to database systems, with an emphasis on design, this work integrates a central case study throughout. It details a step-by-step methodology and teaches readers how to apply this to design and build applications using leading commercial PC and mainframe database systems. Highlighted boxes and margin tips draw attention to important information. Distributed and Object-Orientd database systems are covered. related areas for 1st course database systems. It should also be useful for IT professionals. |
Contents
Part One Background 1 Introduction to Databases | 3 |
Chapter Summary | 45 |
Database Environment | 48 |
Copyright | |
45 other sections not shown
Common terms and phrases
Address Alternate Key application programs Area attributes branch number Branch_No candidate key Chapter clause column conceptual conceptual data model concurrency control cursor data dictionary data item data type database design database system David Ford DBMS DBMSs DDBMS deadlock default defined delete distributed domain DreamHome ensure entity type example EXEC SQL field FName foreign key fragmentation Glasgow identify implementation Iname indexes INSERT integrity constraints ISO standard language LName lock logical data model logical database design Manager member of staff NULL operations Owner Owner_No Paradox for Windows participant physical database design Postcode primary key property for rent Property_for_Rent relation Property_No PROPRENT table protocol query records referential integrity relationship Renter result table retrieve rows salary schema Section serializability shown in Figure specified SQL statement SQLDA Staff entity staff number Staff_No storage Tel_No timestamp tion transaction tuples update