Scene 1 (0s)
[Audio] CALIFORNIA UNIVERSITY OF SCIENCE AND TECHNOLOGY.
Scene 2 (6s)
[Audio] Information Technology and Artificial Intelligence.
Scene 3 (13s)
[Audio] Chapter 9: Database Systems. Chapter 9: Database Systems.
Scene 4 (20s)
[Audio] Chapter 9: Database Systems 9.1 Database Fundamentals 9.2 The Relational Model 9.3 Object-Oriented Databases 9.4 Maintaining Database Integrity 9.5 Traditional File Structures 9.6 Data Mining 9.7 Social Impact of Database Technology 9-4.
Scene 5 (50s)
[Audio] Database A collection of data that is multidimensional in the sense that internal links between its entries make the information accessible from a variety of perspectives 9-5.
Scene 6 (1m 3s)
[Audio] Schemas Schema: A description of the structure of an entire database, used by database software to maintain the database Subschema: A description of only that portion of the database pertinent to a particular user's needs, used to prevent sensitive data from being accessed by unauthorized personnel 9-6.
Scene 7 (1m 26s)
[Audio] Database Management Systems Database Management System (DBMS): A software layer that manipulates a database in response to requests from applications Distributed Database: A database stored on multiple machines DBMS will mask this organizational detail from its users Data independence: The ability to change the organization of a database without changing the application software that uses it 9-7.
Scene 8 (1m 54s)
[Audio] Database Models Database model: A conceptual view of a database Relational database model Object-oriented database model 9-8.
Scene 9 (2m 6s)
[Audio] Relational Database Model Relation: A rectangular table Attribute: A column in the table Tuple: A row in the table 9-9.
Scene 10 (2m 16s)
[Audio] Figure 9.3 A relation containing employee information 9-10.
Scene 11 (2m 23s)
[Audio] Relational Design Avoid multiple concepts within one relation Can lead to redundant data Deleting a tuple could also delete necessary but unrelated information 9-11.
Scene 12 (2m 36s)
[Audio] Improving a Relational Design Decomposition: Dividing the columns of a relation into two or more relations, duplicating those columns necessary to maintain relationships Lossless or nonloss decomposition: A "correct" decomposition that does not lose any information 9-12.
Scene 13 (2m 54s)
[Audio] Figure 9.4 A relation containing redundancy 9-13.
Scene 14 (3m 0s)
[Audio] Figure 9.5 An employee database consisting of three relations 9-14.