Skip to content
CS Exit Ethiopia
Revision outline6 / 100 blueprint items

Fundamental of Database Systems

40 topics · 830 revision cues · 226 practice questions

0 / 40 topics reviewed
40 / 40 topics shown · Progress saved in this browser.
Revision approach
  • Business rules → correct schema
    • Constraints justify design
    • Dependency tests
    • Queries justify design
    • Three official design outcomes
    • Question-bank extensions
    👁 Full explanation
    Design a correct schema from explicit business rules, then use constraints, dependency tests and queries to justify it. This chapter covers all three official design outcomes alongside related database concepts.
  • Design workflow
    • Requirements → ER/EER
    • ER/EER → relational mapping
    • Keys/FDs → normalization
    • SQL → physical choices
    👁 Full explanation
    Work in order: requirements → ER/EER → relational mapping → keys/FDs → normalization → SQL and physical choices.
  • Registration/dormitory reconstruction
    • Draw schema unaided
    • Justify every key
    • Justify every reference
    👁 Full explanation
    Practice drawing and constructing the registration/dormitory schema without looking; explain why every key and reference exists.
  • MCQ interpretation
    • Literal syntax
    • Required assumptions
    • Overlapping choices
    • Weak supplied keys
    👁 Full explanation
    For each MCQ, check literal syntax, assumptions and overlapping choices; justify the answer using database rules.
  • Recalculate rather than memorize
    • Attribute closure
    • Cartesian product counts
    • Join preservation
    • Group filters
    • Concrete term contrasts
    👁 Full explanation
    Recalculate closure, product counts, join preservation and group filters; compare similar terms through concrete examples.
Blueprint learning outcomes
  • F1 · Understand the principles of database design
    FDB04, FDB05, FDB06, FDB07, FDB08, FDB09, FDB13, FDB15, FDB17, FDB20, FDB21, FDB22
  • F2 · Apply the database concepts to real world database design
    FDB05, FDB10, FDB11, FDB12, FDB16, FDB17, FDB18, FDB20, FDB21, FDB22, FDB23, FDB38, FDB39
  • F3 · Design database systems for real world scenarios
    FDB05, FDB10, FDB11, FDB12, FDB13, FDB16, FDB22, FDB38, FDB39