Đang chuẩn bị liên kết để tải về tài liệu:
Lecture Management information systems (3rd Edition): Plug it in three - Rainer, Prince, Watson

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 PI3.1 Query Langauge PI3.2 Entity-Relationship Modeling PI3.3 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 PI3.1 Query Langauge PI3.2 Entity-Relationship Modeling PI3.3 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 PI3.1 Query Langauge PI3.2 Entity-Relationship Modeling PI3.3 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 PI3.1 Query Langauge PI3.2 Entity-Relationship Modeling PI3.3 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