Database systems : (Record no. 6882)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 10825cam a2200229 i 4500 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 9780132575676 |
| Terms of availability | TZS 26,000/= |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 0132575671 |
| Terms of availability | TZS 26,000/= |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MUL |
| Language of cataloging | eng |
| Description conventions | AACR |
| 082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.74 JUK |
| 100 1# - MAIN ENTRY--AUTHOR NAME | |
| Personal name | Jukic, Nenad. |
| 245 10 - TITLE STATEMENT | |
| Title | Database systems : |
| Sub Title | introduction to databases and data warehouses / |
| Statement of responsibility, etc | Nenad Jukic, Susan Vrbsky and Svetlozar Nestorov |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication | Boston : |
| Name of publisher | Pearson, |
| Year of publication | c2014. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Number of Pages | xxv, 373 p. : |
| Other physical details | ill. ; |
| Dimensions | 28 cm. |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes index. |
| 505 ## - Formatted Contents | |
| Formatted contents note | Machine generated contents note: ch. 1 Introduction<br/>Initial Terminology<br/>Steps in the Development of Database Systems<br/>Database Requirements Collection, Definition, and Visualization<br/>Database Modeling<br/>Database Implementation<br/>Developing Front-End Applications<br/>Database Deployment<br/>Database Use<br/>Database Administration and Maintenance<br/>The Next Version of the Database<br/>Database Scope<br/>People Involved with Database Systems<br/>Database Analysts, Designers, and Developers<br/>Front-End Applications Analysts and Developers<br/>Database Administrators<br/>Database End Users<br/>Operational versus Analytical Databases<br/>Relational DBMS<br/>Book Topics Overview<br/>Key Terms<br/>Review Questions<br/>ch. 2 Database Requirements And ER Modeling<br/>Introduction<br/>Basic ER Modeling Constructs<br/>Entities<br/>Attributes (Unique and Non-Unique)<br/>Relationships<br/>Cardinality Constraints<br/>Types of Relationships (Maximum Cardinality-Wise). Note continued: Relationships and Relationship Instances<br/>Relationship Attributes<br/>Example: Set of Database Requirements and ER Diagram<br/>Composite Attributes<br/>Composite Unique Attribute<br/>Multiple Unique Attributes (Candidate Keys)<br/>Multivalued Attributes<br/>Derived Attribute<br/>Optional Attribute<br/>Example: Entity Containing Various Types of Attributes<br/>Exact Minimum and Maximum Cardinality in Relationships<br/>Unary Relationships and Relationship Roles<br/>Multiple Relationships Between Same Entities<br/>Weak Entity<br/>Naming Conventions for Entities, Attributes, and Relationships<br/>Multiple ER Diagrams<br/>Example: Another Set of Database Requirements and an ER Diagram<br/>Database Requirements and ER Model Usage<br/>Various ER Notations<br/>Enhanced ER (EER)<br/>A Note About M:N Relationships with Multiple Instances Between the Same Entities<br/>A Note About Associative Entities<br/>A Note About Ternary (and Higher Degree) Relationships<br/>Summary. Note continued: Key Terms<br/>Review Questions<br/>Exercises<br/>Mini Cases<br/>ch. 3 Relational Database Modeling<br/>Introduction<br/>Relational Database Model: Bask Concepts<br/>Primary Key<br/>Mapping Entities into Relations<br/>Mapping Entities with Composite Attributes into Relations<br/>Mapping Entities with Unique Composite Attributes into Relations<br/>Mapping Entities with Optional Attributes into Relations<br/>Entity Integrity Constraint<br/>Foreign Key<br/>Mapping Relationships into Relational Database Constructs<br/>Mapping 1:M Relationships<br/>Mapping M:N Relationships<br/>Mapping 1:1 Relationships<br/>Referential Integrity Constraint<br/>Example: Mapping an ER Diagram into a Relational Schema<br/>Mapping Entities with Candidate Keys (Multiple Unique Attributes) into Relations<br/>Mapping Entities with Multivalued Attributes into Relational Database Constructs<br/>Mapping Entities with Derived Attributes into Relations. Note continued: Example: Mapping an Entity Containing Various Types of Attributes into a Relational Schema<br/>Mapping Unary Relationships<br/>Mapping 1:M Unary Relationships<br/>Mapping M:N Unary Relationships<br/>Mapping 1:1 Unary Relationships<br/>Mapping Multiple Relationships Between the Same Entities<br/>Mapping Weak Entities<br/>Example: Mapping another ER Diagram into a Relational Schema<br/>Relational Database Constraints<br/>Implicit Constraints<br/>User-Defined Constraints<br/>A Note About Mapping Associative Entities<br/>A Note About Mapping Ternary Relationships<br/>A Note About Designer-Created Primary Keys and the Autonumber Option<br/>A Note About Performing Both ER and Relational Modeling<br/>Summary<br/>Key Terms<br/>Review Questions<br/>Exercises<br/>Mini Cases<br/>ch. 4 Update Operations, Update Anomalies, And Normalization<br/>Introduction<br/>Update Operations<br/>Insert Operation Example<br/>Delete Operation Example<br/>Modify Operation Example. Note continued: Update Operation Terminology Note<br/>Update Anomalies<br/>Example Scenario<br/>Example Relation (Containing Redundant Data)<br/>Insertion Anomaly<br/>Deletion Anomaly<br/>Modification Anomaly<br/>Functional Dependencies<br/>Functional Dependency Notation<br/>Functional Dependencies Example<br/>Streamlining Functional Dependencies<br/>Augmented Functional Dependencies<br/>Equivalent Functional Dependencies<br/>Types of Functional Dependencies<br/>Partial Functional Dependency<br/>Full Key Functional Dependency<br/>Transitive Functional Dependency<br/>Another Functional Dependencies Example<br/>Normalization<br/>First Normal Form (1NF)<br/>Second Normal Form (2NF)<br/>Third Normal Form (3NF)<br/>Other Normal Forms<br/>Eliminating Redundancy and Resolving Update Anomalies<br/>Another Normalization Example<br/>A Note About Normalization Exceptions<br/>A Note About Denormalization: Normalization versus Performance<br/>A Note About ER Modeling versus Normalization. Note continued: A Note About Designer-Added Entities (Tables) and Keys for Streamlining Database Content<br/>Key Terms<br/>Review Questions<br/>Exercises<br/>ch. 5 SQL<br/>Introduction<br/>SQL Commands Overview<br/>Data Definition Language (DDL)<br/>Data Manipulation Language (DML)<br/>Data Control Language (DCL) and Transaction Control Language (TCL)<br/>SQL Data Types<br/>Brief SQL Syntax Notes<br/>CREATE TABLE<br/>DROP TABLE<br/>INSERT INTO<br/>SELECT<br/>WHERE<br/>DISTINCT<br/>ORDER BY<br/>LIKE<br/>Aggregate Functions<br/>GROUP BY<br/>HAVING<br/>Nested Queries<br/>IN<br/>JOIN<br/>Alias<br/>Joining Multiple Relations<br/>ALTER TABLE<br/>UPDATE<br/>DELETE<br/>CREATE VIEW and DROP VIEW<br/>Set Operators: UNION, INTERSECT, EXCEPT (MINUS)<br/>Additional SQL Examples with Additional SQL Commands<br/>CREATE TABLE (Additional Example)<br/>INSERT INTO (Additional Example)<br/>Constraint Management<br/>SELECT (Additional Examples)<br/>JOIN of a Relation with Itself (Self-JOIN)<br/>OUTER JOIN. Note continued: JOIN without Using a Primary Key/Foreign Key Combination<br/>IS NULL<br/>EXISTS<br/>NOT<br/>Inserting from a Query<br/>Other SQL Functionalities<br/>A Note About Inappropriate Use of Observed Values in SQL<br/>A Note About SQL Standard and SQL Syntax Differences<br/>SQL Syntax Difference Note 1: DATE and TIME Data Types<br/>SQL Syntax Difference Note 2: FOREIGN KEY<br/>SQL Syntax Difference Note 3: Usage of AS Keyword with Aliases<br/>SQL Syntax Difference Note 4: ALTER TABLE<br/>SQL Syntax Difference Note 5: Set Operators<br/>SQL Syntax Difference Note 6: FULL OUTER JOIN<br/>SQL Syntax Difference Note 7: Constraint Management<br/>SQL Syntax Difference Note 8: GROUP BY<br/>Key Terms<br/>Review Questions<br/>Exercises<br/>Mini Cases<br/>ch. 6 Database Implementation And Use<br/>Introduction<br/>Referential Integrity Constraint: Delete and Update Implementation Options<br/>Delete Options<br/>Update Options<br/>Implementing Delete and Update Options. Note continued: Implementing User-Defined Constraints<br/>CHECK Clause<br/>Other Mechanisms for Implementing User-Defined Constraints<br/>Indexing<br/>Database Front-End<br/>Data Quality Issues<br/>A Note About Assertions and Triggers<br/>Key Terms<br/>Review Questions<br/>Exercises<br/>ch. 7 Data Warehousing Concepts<br/>Introduction<br/>Analytical versus Operational Information<br/>Data Makeup Differences<br/>Technical Differences<br/>Functional Differences<br/>The Data Warehouse Definition<br/>Structured Repository<br/>Integrated<br/>Subject Oriented<br/>Enterprise-Wide<br/>Historical<br/>Time Variant<br/>Retrieval of Analytical Information<br/>Detailed and/or Summarized Data<br/>Data Warehouse Components<br/>Source Systems<br/>Data Warehouse<br/>ETL<br/>Data Warehouse Front-End (BI) Applications<br/>Data Marts<br/>Steps in Development of Data Warehouses<br/>Requirements Collection, Definition, and Visualization<br/>Data Warehouse Modeling<br/>Creating the Data Warehouse. Note continued: Creating ETL Infrastructure<br/>Developing Front-End (BI) Applications<br/>Data Warehouse Deployment<br/>Date Warehouse Use<br/>Data Warehouse Administration and Maintenance<br/>The Next Version of the Data Warehouse<br/>Key Terms<br/>Review Questions<br/>ch. 8 Data Warehouse And Data Mart Modeling<br/>Introduction<br/>Dimensional Modeling: Basic Concepts<br/>Initial Example: Dimensional Model Based on a Single Source<br/>Characteristics of Dimensions and Facts and the Analysis of the Initial Example<br/>Expanded Example: Dimensional Model Based on Multiple Sources<br/>Additional Possible Fact Attributes<br/>Transaction Identifier in the Fact Table<br/>Transaction Time in the Fact Table<br/>Multiple Fact Tables in a Dimensional Model<br/>Detailed versus Aggregated Fact Tables<br/>Detailed Fact Table<br/>Aggregated Fact Table<br/>Detailed versus Aggregated Fact Table<br/>Granularity of the Fact Table<br/>Line-Item versus Transaction-Level Detailed Fact Table. Note continued: Slowly Changing Dimensions and Timestamps<br/>Type 1 Approach<br/>Type 2 Approach<br/>Type 3 Approach<br/>Additional Dimensional Modeling Issues<br/>Snowflake Model<br/>Cubes<br/>Data Warehouse (Data Mart) Modeling Approaches<br/>Normalized Data Warehouse<br/>An Example of a Normalized Data Warehouse<br/>Dimensionally Modeled Data Warehouse<br/>An Example of a Dimensionally Modeled Warehouse<br/>Independent Data Marts<br/>A Note About Comparing Dimensional Modeling and ER Modeling as Data Warehouse/Data Mart Design Techniques<br/>Key Terms<br/>Review Questions<br/>Exercises<br/>Mini Cases<br/>ch. 9 Data Warehouse Implementation And Use<br/>Introduction<br/>Creating a Data Warehouse<br/>ETL: Extraction, Transformation, Load<br/>Online Analytical Processing (OLAP)<br/>OLAPIBI Tools<br/>OLAPIBI Tools Functionalities<br/>Slice and Dice<br/>Pivot (Rotate)<br/>Drill Down and Drill Up<br/>Additional OLAP/BI Tools Functionality Notes<br/>OLAPIBI Tools Purpose. Note continued: Data Warehouse/Data Mart Front-End (BI) Applications<br/>Executive Dashboard<br/>Data Warehouse Deployment<br/>A Note About OLAP/BI Tools Database Models<br/>A Note About OLAP/BI Tools Data Architecture Options<br/>MOLAP<br/>ROLAP<br/>HOLAP<br/>Key Terms<br/>Review Questions<br/>Exercises<br/>ch. 10 Overview Of DBMS Functionalities And Database Administration<br/>Introduction<br/>DBMS Components<br/>Database Administration Overview<br/>Monitoring and Maintaining the Database System<br/>Data Dictionary<br/>Securing the Database Against Unauthorized Access<br/>Providing Database Backup and Recovery<br/>Ensuring Database Integrity<br/>Optimizing Database Performance<br/>Developing and Implementing Database Policies and Standards<br/>Key Terms<br/>Review Questions<br/>Appendix A Enhanced ER<br/>Appendix B Further Notes On Normalization And Higher Normal Forms<br/>Appendix C Enterprise Resource Planning (ERP)<br/>Appendix D Data Governance And Master Data Management. Note continued: Appendix E Object-Oriented Databases<br/>Appendix F Distributed Databases, Parallel, Databases And Cloud Computing<br/>Appendix G Data Mining<br/>Appendix H XML<br/>Appendix I NOSQL Databases<br/>Appendix J Big Data<br/> |
| 546 ## - LANGUAGE NOTE | |
| Language note | eng |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | Databases. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | Database management. |
| 700 ## - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Vrbsky, Susan |
| 700 ## - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Nestorov, Svetlozar |
| 942 ## - ADDED ENTRY ELEMENTS | |
| Item type | Book |
| Withdrawn status | Lost status | Damaged status | Not for loan | Permanent Location | Current Location | Date acquired | Source of acquisition | Full call number | Accession Number | Copy number | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mzumbe University Main Campus Library | Mzumbe University Main Campus Library | 03/10/2015 | FST MU | 005.74 JUK | 0079465 | 1 | 12/12/2022 | Book |