1 0 0 0 0 0 0 1 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 0 0 875000000 1 32 1024 768 6029000000 0 5154000000 0 875000000 10.000000 1.000000 2 4478 65 1 22050 0 49 0 Goals of Database Design 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 1 875000000 1877000000 1 32 1024 768 6029000000 875000000 4152000000 875000000 1877000000 10.000000 1.000000 2 4478 65 1 22050 0 49 1 A Method for Database Design 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 2 1877000000 2543000000 1 32 1024 768 6029000000 1877000000 3486000000 1877000000 2543000000 10.000000 1.000000 2 4478 65 1 22050 0 49 2 Database Integrity 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 3 2543000000 3080000000 1 32 1024 768 6029000000 2543000000 2949000000 2543000000 3080000000 10.000000 1.000000 2 4478 65 1 22050 0 49 3 Data Types for Different Database Technologies (cont.) 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 4 3080000000 3438000000 1 32 1024 768 6029000000 3080000000 2591000000 3080000000 3438000000 10.000000 1.000000 2 4478 65 1 22050 0 49 4 Data Types for Different Database Technologies (cont.) 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 5 3438000000 3581000000 1 32 1024 768 6029000000 3438000000 2448000000 3438000000 3581000000 10.000000 1.000000 2 4478 65 1 22050 0 49 5 Physical Database Schema 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 6 3581000000 4008000000 1 32 1024 768 6029000000 3581000000 2021000000 3581000000 4008000000 10.000000 1.000000 2 4478 65 1 22050 0 49 6 Database Schema with Referential Integrity Constraints 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 7 4008000000 4150000000 1 32 1024 768 6029000000 4008000000 1879000000 4008000000 4150000000 10.000000 1.000000 2 4478 65 1 22050 0 49 7 Database Distribution and Replication 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 8 4150000000 4844000000 1 32 1024 768 6029000000 4150000000 1185000000 4150000000 4844000000 10.000000 1.000000 2 4478 65 1 22050 0 49 8 Database Distribution and Replication (continued) 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 9 4844000000 5204000000 1 32 1024 768 6029000000 4844000000 825000000 4844000000 5204000000 10.000000 1.000000 2 4478 65 1 22050 0 49 9 Database Capacity Planning 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14bSummary\Chap14bSummary.avi 0 10 5204000000 6028000000 1 32 1024 768 6029000000 5204000000 1000000 5204000000 6028000000 10.000000 1.000000 2 4478 65 1 22050 0 49 10 SQL DDL Code 1 0 Goals of Database Design 1 0 875000000 A Method for Database Design 1 1 1877000000 Database Integrity 1 2 2211000000 Presentation Paused 1 2 2253000000 Presentation Resumed 1 2 2543000000 Data Types for Different Database Technologies (cont.) 1 3 3080000000 Data Types for Different Database Technologies (cont.) 1 4 3438000000 Physical Database Schema 1 5 3581000000 Database Schema with Referential Integrity Constraints 1 6 4008000000 Database Distribution and Replication 1 7 4150000000 Database Distribution and Replication (continued) 1 8 4844000000 Database Capacity Planning 1 9 5204000000 SQL DDL Code 1 10 32 0000 No additional notes 875000000 Teaching Notes Referential integrity is discussed on the next slide. 1877000000 No additional notes 2543000000 Teaching Notes Comparing the data types of different databases underscores 2722000000 database-specific data types vs. conceptual data types and broadens students’ 2901000000 understanding of databases If your school uses another database, add a fourth column 3080000000 Teaching Notes Comparing the data types of different databases underscores 3199330000 database-specific data types vs. conceptual data types and broadens students’ 3318660000 understanding of databases If your school uses another database, add a fourth column 3438000000 No additional notes 3581000000 No additional notes 4008000000 No additional notes 4150000000 No additional notes. 4844000000 No additional notes. 5204000000 Teaching Notes DDL can often be created by a CASE tool given a physical data 5616000000 model. DDL can also be hand-written.