Table of Content

Topics

(Sections 1.1 - 1.8) data vs. information; concept of database; type of databases; importance of database design; database vs. files main component and main functions

(Chatper 2) data model; data modeling; entities and relationship; entity-relationship model

(Chapter 4) identify entity relationship components; define and refine relationships between entities; create conceptual model using E-R diagrams

(Chapter 3) attributes, schemas, tuples, domains, relation instance, keys of relations; database schema; defining a relation schema in SQL convert E-R model to relational database schema; convert entity sets to relations; convert relationships to relations; convert ISA hierarchies to relations

(Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra) ) defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries