quizlet database definitions

Database topic

Analysis, Design

  • End user, Functional requirements
  • General Data Protection Regulations
  • Entities, attributes, relationships, ERD
  • Data dictionary, keys, validation constraints

Database topic

Implementation, Testing

  • SQL query, query design
  • tables
  • related (linked) tables: PK, FK
  • columns and rows
  • SELECT, FROM, WHERE
  • logical operators
  • ORDER BY, join, equi-join (WHERE)
  • INSERT, UPDATE, DELETE
  • test, evaluate

Database unit

All topics

Use the various study modes (suggested order of use):

  1. flashcard
  2. match
  3. learn
  4. spell
  5. test

Don't just do match, it is a useful warm-up but it is only tests reflexes by trial and error.

quizletDatabaseN5.pdf

Database Development

Revision Sheet

  • This PDF contains all the database key words
  • You can print this document or study it online.
  • Don't forget to follow up with a quizlet test.