Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database Management (module 1 (lecture 2: relational model (Constraints…
Database Management
module 1
lecture 1: properties of a modern DMBS, history
properties
self-describing
program data separation
data abstraction
network multi-user access
client-server architecture
history
old ideas
1962
term "DB"
1964
Charles Bachman
1924-2017
Turing award 1973
IDS
network model
record
set
the gist
successful
general purpose with mentioned modern proerties
tied closely to COBAL
1966-68
navigational DB systems
1970
1977
1977-79
1973-85
1985
big deal
pre 1960
tapes
newer ideas
1990's
OODBMS
XML
2010's
noSQL
newSQL
lecture 2: relational model
relation
tuple
example
relation schema
degree
attributes
domain
relation
NULL
Constraints
implicit
explicit
key
superkey
primary
foreign
application-based
lecture 3: Intro to SQL
Data definition language
Declarative language
Data manipulation language
Queries
SELECT
WHERE
Conditions
operators
relational
Other
Arithmetic
AS
JOINS
result: cross product
can join on multiple
tables
attributes
conditions
NULLs
Notes:
https://docs.google.com/document/d/1fwGlDdk-DtMc5yGxZqOGFaESiUoTFpXqyXWSIagboFM/edit