CSC 540 Learning Objectives

For the Introduction (Chapter 1 in both editions of the textbook)

For E/R Diagrams (Sections 4.1-4.4 of the 2nd edition of the textbook, or Chapter 2 first edition)

For E/R to Relations Conversion (Sections 2.1-2.2 and 4.5-4.6 of the 2nd edition of the textbook, or Sections 3.1-3.3 in the first edition)

For Functional Dependencies and Normalization (Sections 3.1-3.5 of the 2nd edition of the textbook, or Sections 3.4-3.6 in the first edition)

For Relational Algebra (Sections 2.4 and 5.1-5.2 of the 2nd edition of the textbook, or Sections 5.1-5.4 in the first edition)

For SQL: The Basics (Sections 6.1-6.3 of the textbook 2nd edition, or Sections 6.1-6.3 in the first edition)

For More SQL (Sections 2.3 and 6.4-6.5 of the textbook 2nd edition, or Sections 6.4-6.6 first edition)

For Constraints and Triggers (Chapter 7 of the textbook 2nd edition, or Chapter 7 first edition)

For Transactions, Security and User Authorization in SQL (Sections 6.6 and 10.1 of the textbook 2nd edition, or Sections 8.6-8.7 first edition)

For Data Storage, Representing Data Elements, and Index Structures (Chapters 13-14 of the textbook 2nd edition, or Chapters 11-13 first edition)

For Coping with System Failures (Chapter 17 of the textbook – either edition)

For Concurrency Control (Chapter 18 of the textbook – either edition)