Sir Arthur Conan Doyle Programmer productivity In the 1970s Codd laid out a plan for improving programmer productivity and accelerating systems development by improving the management and processing of data ID: 930812
Download Presentation The PPT/PDF document "Data Modeling and SQL It is a capital mi..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Data Modeling and SQL
It is a capital mistake to theorize before one has data
Sir Arthur Conan Doyle
Slide2Programmer productivity
In the 1970s, Codd laid out a plan for improving programmer productivity and accelerating systems development by improving the management and processing of data
The relational model
Shift from record to set (table) processing
2
Slide3Data modeling and SQL
Relational model is very popular
Successful use of the relational model requires skills in
Data modelingSQL3
Slide4Organizational memory hierarchy
4
Slide5Key database design questions
What collection of files should a database contain?
How are these files related?
What fields should each file contain?
5
Slide6Learning strategy
Incremental, parallel development of
Data modeling
SQL 6