TAILIEUCHUNG - Database Systems: Lecture 8 & 9 - Nguyen Thanh Tung

Database Systems: Lecture 8 & 9 - Functional Dependencies & Normalization for Relational DBs includes about Functional dependencies (FDs), Normalization (1NF and dependency problems, 2NF – solves partial dependency, 3NF – solves indirect dependency, BCNF – well-normalized relations), Notes and suggestions. | Top-Down Database Design Mini-world Requirements Conceptual schema E1 E2 R Relation schemas ? Functional Dependencies & Normalization for Relational DBs Outline Introduction Functional dependencies (FDs) Definition of FD Direct, indirect, partial dependencies Inference Rules for FDs Equivalence of Sets of FDs Minimal Sets of FDs Normalization 1NF and dependency problems 2NF – solves partial dependency 3NF – solves indirect dependency BCNF – well-normalized relations Notes and suggestions Summary Reading suggestion: [1]: Chapters 10, 11; [2]: Chapters 13, 14 Introduction Each relation schema consists of a number of attributes and the relational database schema consists of a number of relation schemas Attributes are grouped to form a relation schema Need some formal measure of why one grouping of attributes into a relation schema may be better than another Introduction “Goodness” measures: Redundant information in tuples Update anomalies: modification, deletion, insertion .

• Cơ sở dữ liệu
• Database Systems
• Functional Dependencies
• Normalization for Relational DBs
• Inference Rules for FDs
• Equivalence of Sets of FDs
• Minimal Sets of FDs
• Lecture Database Systems
• Database systems concepts
• Database systems architecture
• Database languages
• Data management systems framework
• Introduction to Database Systems
• Database system concepts
• Entity Relationship model
• Database security
• Distributed database systems
• Principles of distributed database systems
• Cơ sở dữ liệu phân tán
• Parallel database systems
• Load balancing
• Database architecture
• Database approach
• Database management systems
• Lecture Database management systems
• File based system
• Characteristics of the database
• Data dictionary
• Database integration
• Schema matching
• Fundamentals of database systems
• The relational data model
• Database design
• Database programming techniques
• Relational database constraints
• Database System
• Relational databases
• Relational database design algorithms
• Relational database systems
• Computer networks
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Data models
• Hierarchical model
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Database users
• Database applications
• Typical DBMS functionality
• Databases and database users
• Relational calculus
• Physical database design
• Concurrency control techniques
• Database recovery techniques
• Distributed databases
• Multivalued dependencies
• Fundamentals of database management systems
• Logical database design
• Object oriented database management
• Data administration
• Design problem
• Dimensions of the problem
• Database development
• Database environments
• Object database management systems
• Object database
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Operating systems
• Attribute alias
• Lecture Database system concepts
• Database system architectures
• Relational database design