《数据库原理（第6版）英文版》教学课件—ch02The Relational Model.pptxVIP

The Relational Model;All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. Printed in the United States of America.;Chapter Objectives;Chapter Objectives (Cont’d);Entity;Relation;Characteristics of a Relation;A Sample Relation;A Nonrelation Example;Example of a Nonrelational Table;Terminology;A Key;Uniqueness of Keys;A Composite Key;Composite Key Characteristics;A Candidate Key;A Primary Key;Defining the Primary Key in Microsoft Access;Defining the Primary Key in Microsoft SQL Server 2012;Defining the Primary Key in Oracle Database 11g Release 2;Defining the Primary Key in Oracle MySQL 5.5;A Surrogate Key;Surrogate Key Example;Relationships Between Tables;A Foreign Key;Foreign Key Example I;Foreign Key Example II;Referential Integrity;Referential Integrity (Cont’d);Foreign Keys inMicrosoft Access;Foreign Keys inMicrosoft SQL Server 2012;Foreign Keys inOracle Database 11g Release 2;Foreign Keys inOracle MySQL 5.5;The Null Value;The Problem of Null Values;Functional Dependency;Determinants;Candidate/Primary Keys and Functional Dependency;Primary Key and Functional Dependency Example;Normalization;Normalization Principles;Normalization Example;Normalization Example (Cont’d)