关系数据库习题与解答（英文版） (2008 年度畅销榜NO.49894 )

Schaum's Outlines give you the information your teachers expect you to know in a handy and succinct format--without ovetwhelming you with unnecessary jargon. You get a complete overview of the subject.Plus, you get plenty of practice exercises to test your skill. Compatible with any classroom text, Schaum's let you study at your own pace and remind you of all the important facts you need to remember--fast! And Schaum's are so complete, they're perfect for preparing for graduate or professional exams.\r\n\r\n Inside, you will find:\r\n\r\n ' Full coverage of the database system used by most manufacturers including Microsoft and Oracle\r\n\r\n ' Complete scripts to create and populate all databases used in the book\r\n\r\n ' Labs and practice tests similar to tests currently used in certification exams\r\n\r\n ' Language features that are applicable across platforms If you want top grades and a thorough understanding of the fundamentals of relational databases, this powerful study tool is the best tutor you can have!\r\n
\r\n

CHAPTER 1 An 0verview of DBMS and DB Systems \r\n\r\n Architecture \r\n\r\n 1.1 Introduction to Database Management System \r\n\r\n 1.2 Data Models \r\n\r\n 1.3 Database System Architecture \r\n\r\n CHAPTER 2 Relational Database Concepts \r\n\r\n 2.1 Relational Database Management Systems \r\n\r\n 2.2 Mathematical Definition of a Relation \r\n\r\n 2.3 Candidate Key and Primary Key of Relation \r\n\r\n 2.4 Foreign Keys \r\n\r\n 2.5 Relational Operators \r\n\r\n 2.6 Set Operations on Relations \r\n\r\n 2.7 Insertion, Deletion and Update Operations on \r\n\r\n Relations \r\n\r\n 2.8 Attribute Domains and Their Implementations \r\n\r\n CHAWER 3 An Introduedon to SQL \r\n\r\n 3.1 Introduction to SQL Language \r\n\r\n 3.2 Table Creation \r\n\r\n 3.3 Selections, Projections, and Joins using SQL \r\n\r\n CHAWER 4 Funchonat Dependendes \r\n\r\n 4.1 Introduction \r\n\r\n 4.2 Deflnition of Functional Dependencies \r\n\r\n 4.3 Functional Dependencies and Keys \r\n\r\n 4.4 Inference Axioms for Functional \r\n\r\n Dependencies \r\n\r\n 4.5 Redundant Functional Dependencies \r\n\r\n 4.6 Closures, Cover and Equivalence of \r\n\r\n Functional Dependencies \r\n\r\n CHAPTER 5 The Normalization Process \r\n\r\n 5.1 Introduction \r\n\r\n 5.2 First Normal Form \r\n\r\n 5.3 Data Anomalies in 1NF Relations \r\n\r\n 5.4 Partial Dependencies \r\n\r\n 5.5 Second Normal Form \r\n\r\n 5.6 Data Anomalies in 2NF Relations \r\n\r\n 5.7 Transitive Dependencies \r\n\r\n 5.8 Third Normal Form \r\n\r\n 5.9 Data anomalies in 3NF Relations \r\n\r\n 5.10 Boyce-Codd Normal Form \r\n\r\n 5.11 Lossless or Lossy Decompositions \r\n\r\n 5.12 Preserving Functional Dependencies \r\n\r\n CHAPTER 6 Basic Securfty Issues \r\n\r\n 6.1 The Need for Security \r\n\r\n 6.2 Physical and Logical Security \r\n\r\n 6.3 Design Issues \r\n\r\n 6.4 Maintenance Issues \r\n\r\n 6.5 Operating System Issues and Availability \r\n\r\n 6.6 Accountability \r\n\r\n 6.7 Integrity \r\n\r\n CHAWER 7 The Entity-Retationship Model \r\n\r\n 7.1 The Entity-Relationship Model \r\n\r\n 7.2 Entities and Attributes \r\n\r\n 7.3 Relationships \r\n\r\n 7.4 One-to-One Relationships \r\n\r\n 7.5 Many-to-One and Many-to-Many \r\n\r\n Relationships \r\n\r\n 7.6 Normalizing the Model \r\n\r\n 7.7 Table Instance Charts \r\n\r\n INDEX \r\n\r\n \r\n\r\n \r\n
\r\n