1 0 0 0 0 0 0 1 1 1 1 1 1 1 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 6 0 2446000000 2678000000 1 32 1024 768 2679000000 2446000000 1000000 2446000000 2678000000 10.000000 1.000000 2 4478 65 1 22050 0 49 6 … To Physical Data Model (Relational Schema) 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 5 0 2314000000 2446000000 1 32 1024 768 2679000000 2314000000 233000000 2314000000 2446000000 10.000000 1.000000 2 4478 65 1 22050 0 49 5 From Logical Data Model … 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 4 0 1709000000 2314000000 1 32 1024 768 2679000000 1709000000 365000000 1709000000 2314000000 10.000000 1.000000 2 4478 65 1 22050 0 49 4 Relational Databases 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 3 0 1122000000 1709000000 1 32 1024 768 2679000000 1122000000 970000000 1122000000 1709000000 10.000000 1.000000 2 4478 65 1 22050 0 49 3 Typical DBMS Architecture 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 2 0 763000000 1122000000 1 32 1024 768 2679000000 763000000 1557000000 763000000 1122000000 10.000000 1.000000 2 4478 65 1 22050 0 49 2 Administrators 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 1 0 340000000 763000000 1 32 1024 768 2679000000 340000000 1916000000 340000000 763000000 10.000000 1.000000 2 4478 65 1 22050 0 49 1 A Modern Data Architecture 1 C:\Documents and Settings\james\My Documents\millerjwcom\dom\gbis722online\week5\Chap14aSummary\Chap14aSummary.avi 0 0 0 0 340000000 1 32 1024 768 2679000000 0 2339000000 0 340000000 10.000000 1.000000 2 4478 65 1 22050 0 49 0 Data Architecture 1 0 0x000003E9 Data Architecture 1 0 0 340000000 0x000003EA A Modern Data Architecture 1 0 1 763000000 0x000003EB Administrators 1 0 2 1122000000 0x000003EC Typical DBMS Architecture 1 0 3 1709000000 0x000003ED Relational Databases 1 0 4 2314000000 0x000003EE From Logical Data Model … 1 0 5 2446000000 0x000003EF … To Physical Data Model (Relational Schema) 1 0 6 32 0 0 0 0 No additional notes No additional notes 340000000 Teaching Notes It is useful to walk through this diagram. Teaching Notes It is useful to walk through this diagram. 763000000 No additional notes No additional notes 1122000000 Teaching Notes Point out everything above the DBMS block is traditionally Teaching Notes Point out everything above the DBMS block is traditionally 1317660000 called front-end while the DMBS and data are called back-end. Explain that metadata is “data called front-end while the DMBS and data are called back-end. Explain that metadata is “data 1513320000 about data” that describes the structure of the user data. about data” that describes the structure of the user data. 1709000000 No additional notes No additional notes 2314000000 No additional notes No additional notes 2446000000 Teaching Notes This is the physical relational database schema for the previous Teaching Notes This is the physical relational database schema for the previous 2562000000 slide. slide.