Skip to content

Latest commit

 

History

History
15 lines (14 loc) · 810 Bytes

File metadata and controls

15 lines (14 loc) · 810 Bytes

Database Systems

  1. What database models do you know?
  • Which are the main functions performed by a Relational Database Management System (RDBMS)?
  • Define what is "table" in database terms.
  • Explain the difference between a primary and a foreign key.
  • Explain the different kinds of relationships between tables in relational databases.
  • When is a certain database schema normalized? What are the advantages of normalized databases?
  • What are database integrity constraints and when are they used?
  • Point out the pros and cons of using indexes in a database.
  • What's the main purpose of the SQL language?
  • What are transactions used for? Give an example.
  • What is a NoSQL database?
  • Explain the classical non-relational data models.
  • Give few examples of NoSQL databases and their pros and cons.