A Practical Guide to Database Design

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


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

Be the first to Review this product
9% off
Available offers
  • Bank OfferFlat ₹100 Instant Cashback on Paytm Wallet. Min Order Value ₹1000. Valid once per Paytm account
  • Bank Offer5% Cashback on Flipkart Axis Bank Card
  • Buy this Product and Get Extra ₹500 Off on Two-Wheelers
  • Partner OfferBuy this product and get upto ₹250 off on Flipkart Furniture
    Know More
  • Delivery
    Enter pincode
      Delivery by31 Jan, Tuesday|Free40
      if ordered before 9:59 PM
    View Details
    Read More
    • Language: English
    • Binding: Paperback
    • Publisher: Taylor & Francis Ltd
    • Genre: Computers
    • ISBN: 9780367571931
    • Pages: 430
    • Cash on Delivery available
    Repro Books on Demand
    • 7 Days Replacement Policy
  • See other sellers
  • 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
    • 789 gr
    Have doubts regarding this product?
    Safe and Secure Payments.Easy returns.100% Authentic products.
    You might be interested in
    Civil Engineering Books
    Min. 50% Off
    Shop Now
    General Fiction Books
    Min. 50% Off
    Shop Now
    Psychology Books
    Min. 50% Off
    Shop Now
    Economics Books
    Min. 50% Off
    Shop Now
    Back to top