Home Ria Christie Collections A Practical Guide to Database Design by Rex Hogan (ISBN: 9780367571931)

A Practical Guide to Database Design

A Practical Guide to Database Design Paperback - 2020

Name: A Practical Guide to Database Design
Price: 131.88 AUD
Availability: InStock
Author: Rex Hogan
ISBN: 9780367571931

by Rex Hogan

Add to wish list

New
Paperback

New

Description

Paperback. New. New Book; Fast Shipping from UK; Not signed; Not First Edition; This book contains a major update to the previous edition. It covers how to implement and manage the Database Management System (DBMS) itself, how to write scripts to extract and load data from source files, and how to develop user inte

Ask the seller a question Add to wish list

A$131.88

A$15.63 Delivery to USA
Standard delivery: 7 to 12 days

More delivery options

Ships from Ria Christie Collections (Greater London, United Kingdom)

The BIBLIO Guarantee

Details

Title A Practical Guide to Database Design
Author Rex Hogan
Binding Paperback
Condition New
Pages 430
Volumes 1
Language ENG
Publisher CRC Press
Publication date 2020-06-30
Bookseller's Inventory # ria9780367571931_inp
ISBN 9780367571931 / 0367571935
Weight 1.67 lbs (0.76 kg)
Dimensions 9.9 x 6.9 x 1 in (25.15 x 17.53 x 2.54 cm)
Category Computers - Data Base Management
Dewey Decimal Code 005.743
Quantity available 988

About Ria Christie Collections Greater London, United Kingdom

Specialising in: Books, Calendars, Fiction Books, Non- Fiction Books, Textbooks

Biblio member since 2014

Hello We are professional online booksellers. We sell mostly new books and textbooks and we do our best to provide a competitive price. We are based in Greater London, UK. We pride ourselves by providing a good customer service throughout, shipping the items quickly and replying to customer queries promptly. Ria Christie Collections

Terms of Sale:

30 day return guarantee, with full refund including original shipping costs for up to 30 days after delivery if an item arrives misdescribed or damaged.

Browse books from Ria Christie Collections

Reader reviews for A Practical Guide to Database Design

Write a review for this book

Important Terms and Guidelines

Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
Reviews must be at least 140 characters in length.
Please do not reveal critical plot elements.
This is not a help line. Contact customer support if you need help.

Your review must not include:

Obscenities, discriminatory language, or other insulting language not suitable for public domain
Advertisements, “spam” content, or references to other products, offers or websites.
Email addresses, URLs, phone numbers, physical addresses or other contact information.
Overly critical comments about other reviews or reviewers
Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
Availability, price, or alternative ordering/shipping information

From the publisher

Fully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition is intended for those involved in the design or development of a database system or application. It begins by illustrating how to develop a Third Normal Form data model where data is placed "where it belongs". The reader is taken step-by-step through the Normalization process, first using a simple then a more complex set of data requirements. Next, usage analysis for each Logical Data Model is reviewed and a Physical Data Model is produced that will satisfy user performance requirements. Finally, each Physical Data Model is used as input to create databases using both Microsoft Access and SQL Server.

The book next shows how to use an industry-leading data modeling tool to define and manage logical and physical data models, and how to create Data Definition Language statements to create or update a database running in SQL Server, Oracle, or other type of DBMS.

One chapter is devoted to illustrating how Microsoft Access can be used to create user interfaces to review and update underlying tables in that database as well as tables residing in SQL Server or Oracle.

For users involved with Cyber activity or support, one chapter illustrates how to extract records of interest from a log file using PERL, then shows how to load these extracted records into one or more SQL Server "tracking" tables adding status flags for analysts to use when reviewing activity of interest. These status flags are used to flag/mark collected records as "Reviewed", "Pending" (currently being analyzed) and "Resolved". The last chapter then shows how to build a web-based GUI using PHP to query these tracking tables and allow an analyst to review new activity, flag items that need to be investigated, and finally flag items that have been investigated and resolved. Note that the book has complete code/scripts for both PERL and the PHP GUI.

About the author

Rex Hogan has over 40 years experience as a database administrator and as a software engineer. This includes over 17 years of experience with Southwestern Bell/AT&T where he became their lead database specialist. During this period, he also taught various undergraduate and graduate classes at Washington University's Center for the Study of Data Processing in St. Louis, MO. He then worked for TRW/Northrop Grumman for 16 years, primarily as a DBA/senior software engineer where he became a specialist in the rapid design and development of database systems and applications. Finally, he worked for five years as a computer scientist for the Air Force Office of Special Investigations, where he developed computer systems to monitor usage of USAF internet traffic. He has authored and co-authored several books, including A Practical Guide to Database Design (first edition), Diagnostic Techniques for IMS DataBases, and Managing IMS Databases.

BIBLIO is the largest independent book marketplace in the world, with over 100 million books.