1 / 4

Database Design: ER Models, Relational Data Model, SQL, and ACID

Learn the fundamentals of database design, including ER models, relational data models, relational algebra, SQL, and ACID properties. Understand disk management, indexing techniques, external sorting, and transaction management.

fdiana
Download Presentation

Database Design: ER Models, Relational Data Model, SQL, and ACID

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Final Week

  2. Overview: Database Design • Data models: ER, Relational Data Model and their mapping • Relational Algebra: be able to use relational algebra to answer question. • Database Languages: SQL, PLpgSQL (final exam: need be able to determine the meaning of a SQL or PLpgSQL) • Relational Database Design: Functional Dependency, Normal Forms, Design Algorithms for 3rd normal form and B-C normal form (3 and half normal form)

  3. Overview: DBMS • Disk, Files, Buffer Replacement Policy • Index: Tree-Index, Hash Index. • External Sorting • Transaction Management • ACID properties • Various schedules: strict, avoid cascading aborts, recoverable, conflict-serializable, view-serializable, schedule graph • concurrency control (locking, time-stamp ordering) --- for multi-versioning, optimistic, only need to know the basic idea.

  4. Final Exam • 3 hrs • Based on understanding • If you do not feel well on the exam day, please not attend the exam. If you attend the exam, no sup-exam will be given! • Consultation: One week prior to the final exam. • Sample questions will be out soon. Please note that sample questions just reflect the difficult degree but not the scope nor the similarity.

More Related