Chapter 2: Relational Database Management Systems

Lesson Goals

Students understand fundamental relational database theory and are able to develop relational databases using the PostgreSQL database engine and the pgAdmin administrative interface.

Lesson Outcomes

Students understand:

  • The benefits of using relational databases
  • The three relationship types found in relational databases
  • The use of Entity-Relationship diagrams for planning the structure of a relational database
  • The role of Primary and Foreign keys in setting up relationships
  • Understand fundamental Structured Query Language (SQL)

Using pgAdmin, students can:

  • Create PostgreSQL tables
  • Use the query tool to run various SQL queries such as create tables or insert data commands
  • Use the graphical query builder to do queries and joins between tables to get answers to questions

To begin the work associated with this chapter, go to the next chapter section.

results matching ""

    No results matching ""