Welcome to P K Kelkar Library, Online Public Access Catalogue (OPAC)

Inside Relational Databases with Examples in Access (Record no. 501202)

000 -LEADER
fixed length control field 04952nam a22004695i 4500
001 - CONTROL NUMBER
control field 978-1-84628-687-2
003 - CONTROL NUMBER IDENTIFIER
control field DE-He213
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20161121230612.0
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
fixed length control field cr nn 008mamaa
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 100301s2007 xxk| s |||| 0|eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781846286872
-- 978-1-84628-687-2
024 7# - OTHER STANDARD IDENTIFIER
Standard number or code 10.1007/978-1-84628-687-2
Source of number or code doi
050 #4 - LIBRARY OF CONGRESS CALL NUMBER
Classification number QA76.9.D3
072 #7 - SUBJECT CATEGORY CODE
Subject category code UN
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code UMT
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code COM021000
Source bisacsh
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.74
Edition number 23
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Whitehorn, Mark.
Relator term author.
245 10 - TITLE STATEMENT
Title Inside Relational Databases with Examples in Access
Medium [electronic resource] /
Statement of responsibility, etc. by Mark Whitehorn, Bill Marklyn.
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Place of production, publication, distribution, manufacture London :
Name of producer, publisher, distributor, manufacturer Springer London,
Date of production, publication, distribution, manufacture, or copyright notice 2007.
300 ## - PHYSICAL DESCRIPTION
Extent XIV, 372 p.
Other physical details online resource.
336 ## - CONTENT TYPE
Content type term text
Content type code txt
Source rdacontent
337 ## - MEDIA TYPE
Media type term computer
Media type code c
Source rdamedia
338 ## - CARRIER TYPE
Carrier type term online resource
Carrier type code cr
Source rdacarrier
347 ## - DIGITAL FILE CHARACTERISTICS
File type text file
Encoding format PDF
Source rda
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note A simple, single-table database -- to Part 1 -- Tables -- Queries/Views -- Forms -- Reports -- Summary of Part 1 -- A multi-table database -- to Part 2 -- Serious problems with single tables -- Multiple tables cure serious problems -- Making multiple tables work together -- Getting the data into the correct tables -- Relationships in the real world -- How are relationships modeled? -- Revisiting the big four — the synergy begins -- Integrity -- Summary of Part 2 -- Database Design & Architecture -- Database design -- The seven layers of wisdom -- Database architecture -- Related database topics -- What exactly is a relational database? -- 22 Triggers and stored procedures -- Transactions, logs, backup, locking and concurrency -- Codd’s rules -- Normalization -- More about normalization -- The system tables -- More on queries: data manipulation -- SQL -- Domains -- What does null mean? -- Primary keys -- Speeding up your database -- Hardware considerations -- Indexing -- More on optimization -- Denormalization.
520 ## - SUMMARY, ETC.
Summary, etc. Inside Relational Databases was first published in 1997 and, rather to our surprise, rapidly reached the status of a classic work in the database field. Translated into three other languages and sold all over the world, it has helped thousands of people to understand the relational model that underpins all modern databases. Inside Relational Databases has never been about how to use a particular database engine (Access, SQL Server, MySQL, whatever). Instead, it’s about the underlying way in which relational databases work. However it is very convenient if the book illustrates the relational model using the reader’s favorite product – such as Access. So, for the new edition we produced several different versions of the same book, each version based on a different database engine. The version in your hand is based around Access (hence the title). There are other versions based around SQL Server and MySQL. You shouldn’t buy this book if you are looking for a book about how to use Access. You should buy this book if you have created databases but they don’t seem to work very well. Perhaps you: •can’t retrieve the information that you want. •have to type in the same information over and over again. •type in data and it appears to go missing. •ask questions and get answers that you know are wrong. •can use Access but you don’t know exactly what to do with it. •know that a relational database lets you create multiple tables in the database but you are uncertain why this is to your advantage. Or perhaps you hear words in connection with databases like: •normalization •functional dependency •inner join •union •redundant data •data dictionary •meta-data •ER modeling •transaction •concurrency •locking You haven’t got the faintest idea what they mean and there is no one you can ask. We have also taken the opportunity of the new edition to restructure the book significantly. I (Mark) continue to teach database design and practice, both to undergraduates and in the commercial world. Without doubt the most popular topic in the commercial world is how to make databases run faster (no great surprise there) so we have added an entire section of brand new material (more than 10% of the entire book) on that topic. The section on designing databases has been reorganized and expanded and we also re-read the entire book (several times) and brought it all up to date.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Computer science.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Computers.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Database management.
650 14 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Computer Science.
650 24 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Database Management.
650 24 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Models and Principles.
650 24 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Information Systems and Communication Service.
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Marklyn, Bill.
Relator term author.
710 2# - ADDED ENTRY--CORPORATE NAME
Corporate name or jurisdiction name as entry element SpringerLink (Online service)
773 0# - HOST ITEM ENTRY
Title Springer eBooks
776 08 - ADDITIONAL PHYSICAL FORM ENTRY
Relationship information Printed edition:
International Standard Book Number 9781846283949
856 40 - ELECTRONIC LOCATION AND ACCESS
Uniform Resource Identifier http://dx.doi.org/10.1007/978-1-84628-687-2
912 ## -
-- ZDB-2-SCS
Holdings
Withdrawn status Lost status Damaged status Not for loan Permanent Location Current Location Date acquired Barcode Date last seen Price effective from Koha item type
        PK Kelkar Library, IIT Kanpur PK Kelkar Library, IIT Kanpur 2016-11-21 EBK1489 2016-11-21 2016-11-21 E books

Powered by Koha