Magda Balazinska

Database Design Database Design Process

7 Pages
1.1 MB
18,057
3,430

introduction to data management cse 344 lecture 14: e/r diagrams magda balazinska - cse 344, fall 2012 1 today: e/r diagrams motivating scenario •  customer asks you to help them setup a dbms •  they want to store information about –  companies and

NULLS in SQL Null Values

6 Pages
591.7 KB
3,115
809

introduction to data management cse 344 lectures 4 and 5: aggregates in sql magda balazinska - cse 344, fall 2011 outline •  nulls (6.1.6 - 6.1.7) •  outer joins (6.3.8) •  aggregations (6.4.3 – 6.4.6) •  examples, examples, examples… magda balazinska - cse 344, fall 2011 nulls in