Introduction to Database.ppt

Introduction to Database CHAPTER 2 ENTITY-RELATIONSHIP MODEL Contents Chapter 1: Introduction PART 1 DATA MODELS Chapter 2: Entity-Relationship Model Chapter 3: Relational Model PART 2 RELATIONAL DATABASES Chapter 4: SQL Chapter 5: Other Relational Languages Chapter 6: Integrity and Security Chapter 7: Relational Database Design PART 4 DATA STORAGE AND QUERYING Chapter 11: Storage and File Structure Chapter 12: Indexing and Hashing PART 1: DATA MODELS Data Model: Is a collection of conceptual tools for describing Data, Data relationships, Data semantics, and Consistency constraints The tools Entity-Relationship Model (Chapter 2) Relational Model (Chapter 3) Object-Oriented Data Model (Chapter 8) Object-Relational Data Model (Chapter 9) … PART 1: Entity-Relationship Model (Chapter 2) Relational Model (Chapter 3) 2.1 Basic Concepts A database can be modeled as: A collection of entities (objects), e.g. Students, Department Relationship among entities (objects), e.g. Major-In E.g. Joni major-in IM Entity-Relationship (E-R) Data Model: Entity sets Relationship sets Attributes Semantic Data Model: Representation of the meaning of the data Mapping the real-world enterprise onto a conceptual schema E.g. Fig. 2.22: E-R diagram for a banking enterprise, p.62 E-R Diagram for a Banking Enterprise, p.62 Example: Banking Database Banking Database: consists 6 relations: branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-only) account (account-number, branch-name, balance) loan (loan-number, branch-name, amount) depositor (customer-name, account-number) borrower (customer-name, loan-number) Example: Banking Database (cont.) Example: Banking Database (cont.) Example: Banking Database (cont.) 2.1.1 Entity Sets A database can be modeled as: a collection of entities, and relationship among entities. Entity: is an object that exists and is distinguishable from other objects. E