L2 - Introduction to Relational Databases and Modeling
Tid: Onsdag 26 mars 2014 kl 10:00 - 12:00
Plats: Q11
Aktivitet: Föreläsning
Lärare: Gyözö_Gidofalvi_(gyozo.gidofalvi@abe.kth.se) ()
Studentgrupper: TTGTM_1
Info:
Outline:
- The data modeling process
- The Entity-Relationship (E-R) model
- Entities, attributes, relationships, cardinalities, keys
- Mapping ER to logical schema
- Relational databases
- SQL crash course
Reading:
- Basic SQL: [PGRi.2, SC2.2]
- SQL Functions: [PGR35.3-4]
- PL/pgSQL: Browse [PGR39]
- Advanved SQL: [PGRi.3]