Plug IT in 3: Fundamentals of relational database operations. In this chapter, the learning objectives are: Understand the process of querying a relational database, understand the process of entity–relationship modeling, understand the process of normalization and the process of joins. | PLUG IT IN THREE Fundamentals of Relational Database Operations OUTLINE Query Langauge Entity-Relationship Modeling Normalization and Joins LEARNING OBJECTIVES Understand the process of querying a relational database. Understand the process of entity–relationship modeling. Understand the process of normalization and the process of joins. Query Languages Primary Key Secondary Key Foreign Key Structured Query Language (SQL) Query By Example (QBE) Entity-Relationship Modeling Entity Relationship Modeling Entity Relationship Diagram (ERD) Business Rules Data Dictionary Relationships (Unary, Binary, Ternary) Entity-Relationship Modeling Connectivity Cardinality Attributes Normalization and Joins Normalization 1st Normal Form 2nd Normal Form 3rd Normal Form Functional Dependencies Join Operation | PLUG IT IN THREE Fundamentals of Relational Database Operations OUTLINE Query Langauge Entity-Relationship Modeling Normalization and Joins LEARNING OBJECTIVES Understand the process of querying a relational database. Understand the process of entity–relationship modeling. Understand the process of normalization and the process of joins. Query Languages Primary Key Secondary Key Foreign Key Structured Query Language (SQL) Query By Example (QBE) Entity-Relationship Modeling Entity Relationship Modeling Entity Relationship Diagram (ERD) Business Rules Data Dictionary Relationships (Unary, Binary, Ternary) Entity-Relationship Modeling Connectivity Cardinality Attributes Normalization and Joins Normalization 1st Normal Form 2nd Normal Form 3rd Normal Form Functional Dependencies Join Operation | PLUG IT IN THREE Fundamentals of Relational Database Operations OUTLINE Query Langauge Entity-Relationship Modeling Normalization and Joins LEARNING OBJECTIVES Understand the process of querying a relational database. Understand the process of entity–relationship modeling. Understand the process of normalization and the process of joins. Query Languages Primary Key Secondary Key Foreign Key Structured Query Language (SQL) Query By Example (QBE) Entity-Relationship Modeling Entity Relationship Modeling Entity Relationship Diagram (ERD) Business Rules Data Dictionary Relationships (Unary, Binary, Ternary) Entity-Relationship Modeling Connectivity Cardinality Attributes Normalization and Joins Normalization 1st Normal Form 2nd Normal Form 3rd Normal Form Functional Dependencies Join Operation . | PLUG IT IN THREE Fundamentals of Relational Database Operations OUTLINE Query Langauge Entity-Relationship Modeling Normalization and Joins LEARNING OBJECTIVES Understand the process of querying a relational database. Understand the process of entity–relationship modeling. Understand the process of normalization and the process of joins. Query Languages Primary Key Secondary Key Foreign Key Structured Query Language (SQL) Query By Example (QBE) Entity-Relationship Modeling Entity Relationship Modeling Entity Relationship Diagram (ERD) Business Rules Data Dictionary Relationships (Unary, Binary, Ternary) Entity-Relationship Modeling Connectivity Cardinality Attributes Normalization and Joins Normalization 1st Normal Form 2nd Normal Form 3rd Normal Form Functional Dependencies Join Operation
