出版時間:2007-8 出版社:清華大學(xué) 作者:弗羅斯特 頁數(shù):508
內(nèi)容概要
你將開始數(shù)據(jù)庫課程的學(xué)習(xí)。對于這門課程,許多書都提供了不同的學(xué)習(xí)方法,如何進行選擇呢?不當(dāng)?shù)臅鴷贡菊n程變得令人頭腦麻木。你需要一本理論上通俗易懂,開發(fā)方法上簡單直接的書;你需要一本使用實際商業(yè)例子的書,你更需要一本有趣又吸引人的書。本書正是如此。 本書以循序漸進的方式,由淺入深地介紹了關(guān)系數(shù)據(jù)庫的理論和設(shè)計方法,并結(jié)合商業(yè)開發(fā)上的技術(shù)和經(jīng)驗,選取不同平臺上具有代表性的范例,介紹了在Oracle、MS Access和MS SQL Server中使用SQL進行數(shù)據(jù)庫設(shè)計和開發(fā)的方法。 本書內(nèi)容全面、技術(shù)實用且先進、敘述深入淺出,語言生動有趣,圖文并茂,使其跳脫了技術(shù)類書籍的枯燥煩悶,其內(nèi)容、講授方法、選用的示例以及課后練習(xí)別具特色,是一本很好的數(shù)據(jù)庫教材。
作者簡介
作者:(美國)弗羅斯特 等
書籍目錄
Chapter 1: The Role of Databases in Electronic Business Learning Objectives Introduction Components of an Organizational System Network Hardware Software Content What Is a Database? Why Are Databases Important to Business? General Business Example E-business Example Organization of the Text Summary Key Terms Exercises Review Discuss PracticeChapter 2: Relational Theory Learning Objectives Introduction Relational Model Relational Databa.se Management System (RDBMS) Database Administrator (DBA) Entity Relationship Diagrams Primary Keys Creating Relationships: Foreign Keys Data Integrity First Normal Form Types of Database Systems Relational Advantages Logical Rather Than Physical Links Fourth-Generation Language (4GL) Data Independence Summary Key Terms Exercises Review Discuss Practice ReferencesChapter 3:Conceptual Design Learning Objectives Introduction Step 1:Represent Entities as Tables Step 2:Determine Relationships Step 3:Lisl Fields step 4:Identify Keys Step 5:Determining Data mypes Designing a Single—Table Database Problem Statemenl Process Designing a Database with a One-to-Many Relationstip Problem Statemenl Process Database with Many-to-Many Relationships Problem Statement Other Multitable Database Examples The HospitaI Database The ACME Database The Amazon Database Summary KeyTerms Exercises Review Discuss PracticeChapter 4:Normalization Learning Objectives Introduction NormaI Forms Denormalized Designs Normalizing the Arcade Database Update Problem lnsert Problem The Normal Forms First NormaI Form 1 NF) Determinants Second Normal Form(2NF) Third NormaI Form f3NF) Boyce-Codd NormaI Form(BCNF) Fourth NormaI Form(4NF) Detecting Normaiization Violations Summary ……Chapter 5:Advanced Database Designs Chapter 6:Creating Databased with Oracle Using SQLChapter 7:Retrieving Data with Oracle Chapter 8:Creating Databases with Microsoft Acccess Chapter 9:Retrieving Data with Microsoft Access Chapter 10:Creating Databases with Microsoft SQL ServerChapter 11:Retrieving Data with SQL ServerChapter 12:Accessing Databases from Web Applecetions with Microsoft AST.NETChapter 13:Maintaining Databases from Web Applections with Microsoft ASP.NET
圖書封面
評論、評分、閱讀與下載
數(shù)據(jù)庫設(shè)計與開發(fā) PDF格式下載