MODERN DATABASE MANAGEMENT (Record no. 1493)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 02005nam a2200109Ia 4500 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 978-8131761434 |
| 100 ## - MAIN ENTRY--AUTHOR NAME | |
| Personal name | HOFFER JEFFREY A |
| 245 #0 - TITLE STATEMENT | |
| Title | MODERN DATABASE MANAGEMENT |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Name of publisher | PEARSON |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | THE DATA BASE ENVIRONMENT AND DEVELOPMENT PROCESS. THE CONTEXT OF DATABASE MANAGEMENT.DATABASE ANALYSIS. MODELING DATA IN THE ORGANIZATION.MODELING ENTRIES AND ATTRIBUTES. THE ENHANCED E-R MODEL DATABASE DESIGN. LOGICAL DATABASE design and the relational model.. implementation. ADVANCED SQL. DATABASE APPLICATION DEVELOPMENT. DATA WAREHOUSING.ADVANCED DATABASE TOPICS. DATA QUALITY AND INTEGRATION.DATA AND DATABASE ADMINISTRATION.DISTRIBUTE DATABASE. OBJECT -ORIENTED DATA MODELING .USING RELATIONAL DATABASE TO PROVIDE OBJECT PERSISTENCE. DATA MODELING TOOLS AND NOTIFICATION. ADVANCED NORMAL FORMS.. DATA STRUCTURE. DISTRIBUTED DATABASE. OBJECT ORIENTED DATA MODELING.USING RELATIONAL DATABASE TO PROVIDE OBJECT. |
| Form subdivision | Inserting, Updating, and Deleting Data. Batch Input . Deleting Database Contents. Updating Database Contents. Internal Schema Definition in RDBMSS. Creating Indexes . Processing Single Tables . Clauses of the SELECT Statement . Using Expressions. Using Functions. Using Wildcards. Using Comparison Operators. Using Null Values. Using Boolean Operators. Using Ranges for Qualification . Using Distinct Values . Using IN and NOT IN with Lists. Sorting Results: The ORDER BY Clause. Categorizing Results: The GROUP BY Clause . Qualifying Results by Categories: The HAVING . Using and Defining Views . MATERIALIZED VIEWS. . .. CASE: Mountain View Community Hospital . Advanced SQL . Learning Objectives . . Processing Multiple Tables. Equi-join . Natural Join . Outer Join . Union Join . Sample Join Involving Four Tables . Self-Join. Subqueries . Correlated Subqueries . Using Derived Tables. Combining Queries . Conditional Expressions . More Complicated SQL Queries . Tips for Developing Queries. Guidelines for Better Query Design . Ensuring Transaction Integrity |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Text book |
| Withdrawn status | Lost status | Damaged status | Not for loan | Permanent Location | Current Location | Shelving location | Date acquired | Cost, normal purchase price | Full call number | Accession Number | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MIIMLIBRARY | MIIMLIBRARY | RACK -REF 2 | 11.02.2019 | 525.00 | 005.74 | 1493 | 11.02.2019 | Reference Books |