A Practical Guide to Database Design

A Practical Guide to Database Design (English, Hardcover, Hogan Rex)


A Practical Guide to Database Design  (English, Hardcover, Hogan Rex)

Be the first to Review this product
23% off
Hurry, Only 1 left!
Available offers
  • Bank OfferFlat ₹100 off on first Flipkart Pay Later order of ₹500 and above
  • Bank Offer5% Unlimited Cashback on Flipkart Axis Bank Credit Card
  • Bank Offer20% off on 1st txn with Amex Network Cards issued by ICICI Bank,IndusInd Bank,SBI Cards and Mobikwik
  • Bank Offer10% Instant discount on Canara Bank Credit and Debit Card transactions
  • Delivery
    Enter pincode
      Usually delivered in6 days
      Enter pincode for exact delivery dates/charges
    View Details
    Read More
    • Language: English
    • Binding: Hardcover
    • Publisher: Taylor & Francis Ltd
    • Genre: Computers
    • ISBN: 9781138578067, 9781138578067
    • Pages: 414
    • 7 Days Replacement Policy
    • Cash on Delivery available
    • 7 Days Replacement Policy
  • View more sellers starting from 6,453
  • Description
    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.
    Read More
    Book Details
    • CRC Press
    • 254 mm
    • 178 mm
    • 885 gr
    Have doubts regarding this product?
    Safe and Secure Payments.Easy returns.100% Authentic products.
    You might be interested in
    General Commerce Books
    Min 10% Off
    Shop Now
    Finance and Accounting Books
    Min 10% Off
    Shop Now
    Business and Management Books
    Min 10% Off
    Shop Now
    Electronics and Communications Engineering Books
    Min 60% Off
    Shop Now
    Back to top