Vault

ECS160-L11

1 min read

📗 -> 01/30/26: ECS160-L11

Lecture Slide Link

🎤 Vocab

❗ Unit and Larger Context

Small summary

✒️ -> Scratch Notes

Relational DBs

  • Tables (excel)
  • No dupliate primary keys

SQL used to interface between application and DB

  • SQL = Structured Query Language

IE:

  • CREATE TABLE Products ( ... )
  • INSERT INTO Products ( ... )

Foreign Keys

  • RelDBs maintain relations through foreign keys
  • Foreign keys MUST refer to primary keys of other tables
    • Enforce reference integrity
  • Table can contain one or more foreign keys

Table joins

Java Database Connectivity Interface (JDBC)

  • Interfaces for Java to SQL
  • PreparedStatement API: create a new query
  • pstmt.executeUpdate(): execute the update
  • ResultSetAPI: retrieve query results

🧪 -> Refresh the Info

Did you generally find the overall content understandable or compelling or relevant or not, and why, or which aspects of the content were most novel or challenging for you and which aspects were most familiar or straightforward?)

Did a specific aspect of the content raise questions for you or relate to other ideas and findings you’ve encountered, or are there other related issues you wish had been covered?)

🔗 -> Links

Resources

  • Put useful links here

Connections

  • Link all related words

Graph View

Backlinks