01047nam a2200313 i 450099100112010970753620020507111543.0970308s1965 us ||| | eng b10176470-39ule_instLE00642483ExLDip.to Fisicaita510.65510.68510.7834QA76.5Kuo, S.463101Numerical methods and computers /S.S. Kuo2nd ed.Reading, MA :Addison-Wesley Publ. Co.,1965x, 341 p. :ill. ;24 cm.Electronic data processingElectronic digital computersFORTRAN (Computer program language).b1017647021-09-0627-06-02991001120109707536LE006 510.62+510.65 KUO12006000023528le006-E0.00-l- 00000.i1021646727-06-02Numerical methods and computers189337UNISALENTOle00601-01-97ma -engus 0111305nam 2200553 450 991015476220332120230808192245.01-292-10764-2(CKB)3710000000623257(MiAaPQ)EBC5185586(MiAaPQ)EBC5187023(MiAaPQ)EBC5833240(MiAaPQ)EBC5483263(MiAaPQ)EBC6401032(Au-PeEL)EBL5483263(OCoLC)1024256400(EXLCZ)99371000000062325720210331d2016 uy 0engurcnu||||||||rdacontentrdamediardacarrierDatabase processing fundamentals, design, and implementation /David M. Kroenke, David AuerFourteenth, global edition.Boston :Pearson,[2016]©20161 online resource (637 pages) color illustrations, graphs1-292-10763-4 Includes bibliographical references and index.Cover -- Title Page -- Copyright Page -- Supplements -- Acknowledgments -- About the Authors -- Contents -- Preface -- Part 1 Getting Started -- Chapter 1: Introduction -- Chapter Objectives -- The Importance of Databases in the Internet and Smartphone World -- The Characteristics of Databases -- A Note on Naming Conventions -- A Database Has Data and Relationships -- Databases Create Information -- Database Examples -- Single-User Database Applications -- Multiuser Database Applications -- E-Commerce Database Applications -- Reporting and Data Mining Database Applications -- The Components of a Database System -- Database Applications and SQL -- The DBMS -- The Database -- Personal Versus Enterprise-Class Database Systems -- What Is Microsoft Access? -- What Is an Enterprise-Class Database System? -- Database Design -- Database Design from Existing Data -- Database Design for New Systems Development -- Database Redesign -- What You Need to Learn -- A Brief History of Database Processing -- The Early Years -- The Emergence and Dominance of the Relational Model -- Post-Relational Developments -- Summary -- Key Terms -- Review Questions -- Project Questions -- Chapter 2: Introduction to Structured Query Language -- Chapter Objectives -- Cape Codd Outdoor Sports -- Business Intelligence Systems and Data Warehouses -- The Cape Codd Outdoor Sports Extracted Retail Sales Data -- RETAIL_ORDER Data -- ORDER_ITEM Data -- SKU_DATA Table -- CATALOG_SKU_20## Tables -- The Complete Cape Codd Data Extract Schema -- Data Extracts Are Common -- SQL Background -- The SQL SELECT/FROM/WHERE Framework -- Reading Specified Columns from a Single Table -- Specifying Column Order in SQL Queries from a Single Table -- Submitting SQL Statements to the DBMS -- Using SQL in Microsoft Access 2013 -- Using SQL in Microsoft SQL Server 2014 -- Using SQL in Oracle Database.Using SQL in Oracle MySQL 5.6 -- SQL Enhancements for Querying a Single Table -- Reading Specified Rows from a Single Table -- Reading Specified Columns and Rows from a Single Table -- Sorting the SQL Query Results -- SQL WHERE Clause Options -- Performing Calculations in SQL Queries -- Using SQL Built-in Aggregate Functions -- SQL Expressions in SQL SELECT Statements -- Grouping Rows in SQL SELECT Statements -- Querying Two or More Tables with SQL -- Querying Multiple Tables with Subqueries -- Querying Multiple Tables with Joins -- Comparing Subqueries and Joins -- The SQL JOIN ON Syntax -- Outer Joins -- Using SQL Set Operators -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Part 2 Database Design -- Chapter 3: The Relational Model and Normalization -- Chapter Objectives -- Relational Model Terminology -- Relations -- Characteristics of Relations -- Alternative Terminology -- To Key, or Not to Key-That Is the Question! -- Functional Dependencies -- Finding Functional Dependencies -- Keys -- Normal Forms -- Modification Anomalies -- A Short History of Normal Forms -- Normalization Categories -- From First Normal Form to Boyce-Codd Normal Form Step by Step -- Eliminating Anomalies from Functional Dependencies with BCNF -- Eliminating Anomalies from Multivalued Dependencies -- Fifth Normal Form -- Domain/Key Normal Form -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Chapter 4: Database Design Using Normalization -- Chapter Objectives -- Assess Table Structure -- Designing Updatable Databases -- Advantages and Disadvantages of Normalization -- Functional Dependencies -- Normalizing with SQL -- Choosing Not to Use BCNF -- Multivalued Dependencies.Designing Read-Only Databases -- Denormalization -- Customized Duplicated Tables -- Common Design Problems -- The Multivalue, Multicolumn Problem -- Inconsistent Values -- Missing Values -- The General-Purpose Remarks Column -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Chapter 5: Data Modeling with the Entity-Relationship Model -- Chapter Objectives -- The Purpose of a Data Model -- The Entity-Relationship Model -- Entities -- Attributes -- Identifiers -- Relationships -- Maximum Cardinality -- Minimum Cardinality -- Entity-Relationship Diagrams and Their Versions -- Variations of the E-R Model -- E-R Diagrams Using the IE Crow's Foot Model -- Strong Entities and Weak Entities -- ID-Dependent Entities -- Non-ID-Dependent Weak Entities -- The Ambiguity of the Weak Entity -- Subtype Entities -- Patterns in Forms, Reports, and E-R Models -- Strong Entity Patterns -- ID-Dependent Relationships -- Mixed Identifying and Nonidentifying Patterns -- The For-Use-By Pattern -- Recursive Patterns -- The Data Modeling Process -- The College Report -- The Department Report -- The Department/Major Report -- The Student Acceptance Letter -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Chapter 6: Transforming Data Models into Database Designs -- Chapter Objectives -- The Purpose of a Database Design -- Create a Table for Each Entity -- Selecting the Primary Key -- Specifying Alternate Keys -- Specifying Column Properties -- Verify Normalization -- Create Relationships -- Relationships Between Strong Entities -- Relationships Using ID-Dependent Entities -- Relationships with a Weak Non-ID-Dependent Entity -- Relationships in Mixed Entity Designs.Relationships Between Supertype and Subtype Entities -- Recursive Relationships -- Representing Ternary and Higher-Order Relationships -- Relational Representation of the Highline University Data Model -- Design for Minimum Cardinality -- Actions when the Parent Is Required -- Actions when the Child Is Required -- Implementing Actions for M-O Relationships -- Implementing Actions for O-M Relationships -- Implementing Actions for M-M Relationships -- Designing Special Case M-M Relationships -- Documenting the Minimum Cardinality Design -- An Additional Complication -- Summary of Minimum Cardinality Design -- The View Ridge Gallery Database -- View Ridge Gallery Database Summary of Requirements -- The View Ridge Data Model -- Database Design with Data Keys -- Minimum Cardinality Enforcement for Required Parents -- Minimum Cardinality Enforcement for the Required Child -- Column Properties for the View Ridge Database Design Tables -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Part 3 Database Implementation -- Chapter 7: SQL for Database Construction and Application Processing -- Chapter Objectives -- The Importance of Working with an Installed DBMS Product -- The View Ridge Gallery Database -- SQL DDL and DML -- Managing Table Structure with SQL DDL -- Creating the VRG Database -- Using SQL Scripts -- Using the SQL CREATE TABLE Statement -- Variations in SQL Data Types and SQL/PSM -- Creating the VRG Database ARTIST Table -- Creating the VRG Database WORK Table and the 1:N ARTIST-to-WORK Relationship -- Implementing Required Parent Rows -- Implementing 1:1 Relationships -- Casual Relationships -- Creating Default Values and Data-Constraints with SQL -- Creating the VRG Database Tables -- The SQL ALTER TABLE Statement -- The SQL DROP TABLE Statement.The SQL TRUNCATE TABLE Statement -- The SQL CREATE INDEX Statement -- SQL DML Statements -- The SQL INSERT Statement -- Populating the VRG Database Tables -- The SQL UPDATE Statement -- The SQL MERGE Statement -- The SQL DELETE Statement -- Using SQL Views -- Using SQL Views to Hide Columns and Rows -- Using SQL Views to Display Results of Computed Columns -- Using SQL Views to Hide Complicated SQL Syntax -- Layering Built-in Functions -- Using SQL Views for Isolation, Multiple Permissions, and Multiple Triggers -- Updating SQL Views -- Embedding SQL in Program Code -- SQL/Persistent Stored Modules (SQL/PSM) -- Using SQL User-Defined Functions -- Using SQL Triggers -- Using Stored Procedures -- Comparing User-Defined Functions, Triggers, and Stored Procedures -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Chapter 8: Database Redesign -- Chapter Objectives -- The Need for Database Redesign -- SQL Statements for Checking Functional Dependencies -- What Is a Correlated Subquery -- How Do I Analyze an Existing Database -- Reverse Engineering -- Dependency Graphs -- Database Backup and Test Databases -- Changing Table Names and Table Columns -- Changing Table Names -- Adding and Dropping Columns -- Changing a Column Data Type or Column Constraints -- Adding and Dropping Constraints -- Changing Relationship Cardinalities -- Changing Minimum Cardinalities -- Changing Maximum Cardinalities -- Adding and Deleting Tables and Relationships -- Forward Engineering -- Summary -- Key Terms -- Review Questions -- Project Questions -- Case Questions -- The Queen Anne Curiosity Shop -- Morgan Importing -- Part 4 Multiuser Database Processing -- Chapter 9: Managing Multiuser Databases -- Chapter Objectives -- The Importance of Working with an Installed DBMS Product.Database Administration.For undergraduate database management courses. Get Students Straight to the Point of Database Processing Database Processing: Fundamentals, Design, and Implementation reflects a new teaching and professional workplace environment and method that gets students straight to the point with its thorough and modern presentation of database processing fundamentals. The Fourteenth Edition has been thoroughly updated to reflect the latest software.Database managementProblems, exercises, etcDatabase management005.7565Kroenke David M.1946-25833Auer David J.MiAaPQMiAaPQMiAaPQBOOK9910154762203321Database processing186891UNINA04507nam 22008175 450 991050058750332120251113182200.03-030-82208-710.1007/978-3-030-82208-8(CKB)5360000000050036EBL6734438(OCoLC)1313882908(AU-PeEL)EBL6734438(MiAaPQ)EBC6734438(oapen)https://directory.doabooks.org/handle/20.500.12854/72239(ODN)ODN0010072164(oapen)doab72239(DE-He213)978-3-030-82208-8(oapen)72239(EXLCZ)99536000000005003620210925d2022 u| 0engur|n|---|||||txtrdacontentcrdamediacrrdacarrierNeighbourhoods in Transition Brownfield Regeneration in European Metropolitan Areas /by Emmanuel Rey, Martine Laprise, Sophie Lufkin1st ed. 2022.Springer Nature2022Cham :Springer International Publishing :Imprint: Springer,2022.1 online resource illustrations (chiefly color)The Urban Book Series,2365-7588Description based upon print version of record.3-030-82207-9 Part 1: Definition and issues -- Introduction -- Urban brownfields: Origin, definition, and diversity -- The multiple potentials of urban brownfields -- Urban brownfield regeneration projects: Complexities and issues -- Sustainability issues at the neighbourhood scale -- Part 2: Project dynamics and support tools -- Key steps of a regeneration process -- Specific skills and adapted support -- Sustainability monitoring: Principles, challenges, and approaches -- An operational monitoring tool -- Application to a case study -- Conclusion -- Appendix.This open access book is focused on the intersection between urban brownfields and the sustainability transitions of metreopolitan areas, cities and neighbourhoods. It provides both a theoretical and practical approach to the topic, offering a thorough introduction to urban brownfields and regeneration projects as well as an operational monitoring tool. Neighbourhoods in Transition begins with an overview of historic urban development and strategic areas in the hearts of towns to be developed. It then defines several key issues related to the topic, including urban brownfields, regeneration projects, and sustainability issues related to neighbourhood development. The second part of this book is focused on support tools, explaining the challenges faced, the steps involved in a regeneration process, and offering an operational monitoring tool. It applies the unique tool to case studies in three selected neighbourhoods and the outcomesof one case study are also presented and discussed, highlighting its benefits. The audience for this book will be both professional and academic. It will support researchers as an up-to-date reference book on urban brownfield regeneration projects, and also the work of architects, urban designers, urban planners and engineers involved in sustainability transitions of the built environment.The Urban Book Series,2365-7588GeographyDevelopment economicsUrban ecology (Biology)Sustainable architectureSociology, UrbanRegional GeographyDevelopment EconomicsUrban EcologySustainable Architecture/Green BuildingsUrban SociologyGeography.Development economics.Urban ecology (Biology)Sustainable architecture.Sociology, Urban.Regional Geography.Development Economics.Urban Ecology.Sustainable Architecture/Green Buildings.Urban Sociology.307.3416094ARC018000BUS092000SCI020000SCI030000SOC026030bisacshRey Emmanuel1018001Rey EmmanuelautLaprise MartineautLufkin SophieautAU-PeELAU-PeELAU-PeELNZ-WeVULBOOK9910500587503321Neighbourhoods in Transition4464713UNINA