A Practical Guide to Database Design, Second Edition
Hogan, Rex| Author | Hogan, Rex, author. |
| Title | A Practical Guide to Database Design, Second Edition |
| Edition | Second edition. |
| Physical Description | 1 online resource |
| Contents | chapter 1 Overview of Databases / chapter 2 Data Normalization / chapter 3 Database Implementation / chapter 4 Normalization and Physical Design Exercise / chapter 5 The erwin Data Modeling Tool / chapter 6 Using Microsoft Access / chapter 7 Using SQL Server / chapter 8 Using Perl to Extract and Load Data / chapter 9 Building User Interfaces / chapter 10 Creating the University Database Application / chapter 11 PHP Implementation and Use / |
| Summary | "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 focusing on how to create a logical data model where data is stored "where it belongs." Next, data usage is reviewed to transform the logical model into a physical data model that will satisfy user performance requirements. Finally, it describes how to use various software tools to create user interfaces to review and update data in a database.Organized into 11 chapters, the book begins with an overview of the functionality of database management systems and how they guarantee the accuracy and availability of data. It then describes how to define and normalize data requirements to create a logical data model, then map them into an initial solution for a physical database. The book next presents how to use an industry-leading data modeling tool to define and manage logical and physical data models. After that, it describes how to implement a physical database using either Microsoft Access or SQL Server and how to use Microsoft Access to create windows interfaces to query or update data in tables. The last part of the book reviews software tools and explores the design and implementation of a database using as an example a much more complex data environment for a University. The book ends with a description of how to use PHP to build a web-based interface to review and update data in a database. "--Provided by publisher. |
| Subject | COMPUTERSCIENCEnetBASE Database Design & Development Database Management INFORMATIONSCIENCEnetBASE ITECHnetBASE SCI-TECHnetBASE STMnetBASE |
| Multimedia |
Total Ratings:
0
03580cam a2200457Ii 4500
001
vtls001592785
003
VRT
005
20220808223400.0
008
220808s2018 xx a ob 001 0 eng d
020
$a 9781351265485 $q (e-book : PDF)
020
$a 9781351265454 $q (e-book: Mobi)
020
$z 9781138578067 $q (hardback)
024
7
$a 10.1201/b22522 $2 doi
035
$a (OCoLC)1022754337
035
$a 9781351265485
039
9
$a 202208082234 $b santha $y 202206301327 $z santha
040
$a FlBoTFG $c FlBoTFG $e rda
050
4
$a QA76.9.D26 $b H643 2018
072
7
$a COM021000 $2 bisacsh
072
7
$a COM021030 $2 bisacsh
072
7
$a COM051230 $2 bisacsh
100
1
$a Hogan, Rex, $e author.
245
1
2
$a A Practical Guide to Database Design, Second Edition
250
$a Second edition.
264
1
$a Boca Raton, FL : $b CRC Press, $c 2018.
300
$a 1 online resource
336
$a text $2 rdacontent
337
$a computer $2 rdamedia
338
$a online resource $2 rdacarrier
505
0
$t chapter 1 Overview of Databases / $r Rex Hogan -- $t chapter 2 Data Normalization / $r Rex Hogan -- $t chapter 3 Database Implementation / $r Rex Hogan -- $t chapter 4 Normalization and Physical Design Exercise / $r Rex Hogan -- $t chapter 5 The erwin Data Modeling Tool / $r Rex Hogan -- $t chapter 6 Using Microsoft Access / $r Rex Hogan -- $t chapter 7 Using SQL Server / $r Rex Hogan -- $t chapter 8 Using Perl to Extract and Load Data / $r Rex Hogan -- $t chapter 9 Building User Interfaces / $r Rex Hogan -- $t chapter 10 Creating the University Database Application / $r Rex Hogan -- $t chapter 11 PHP Implementation and Use / $r Rex Hogan.
520
2
$a "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 focusing on how to create a logical data model where data is stored "where it belongs." Next, data usage is reviewed to transform the logical model into a physical data model that will satisfy user performance requirements. Finally, it describes how to use various software tools to create user interfaces to review and update data in a database.Organized into 11 chapters, the book begins with an overview of the functionality of database management systems and how they guarantee the accuracy and availability of data. It then describes how to define and normalize data requirements to create a logical data model, then map them into an initial solution for a physical database. The book next presents how to use an industry-leading data modeling tool to define and manage logical and physical data models. After that, it describes how to implement a physical database using either Microsoft Access or SQL Server and how to use Microsoft Access to create windows interfaces to query or update data in tables. The last part of the book reviews software tools and explores the design and implementation of a database using as an example a much more complex data environment for a University. The book ends with a description of how to use PHP to build a web-based interface to review and update data in a database. "--Provided by publisher.
650
0
4
$a COMPUTERSCIENCEnetBASE
650
0
4
$a Database Design & Development
650
0
4
$a Database Management
650
0
4
$a INFORMATIONSCIENCEnetBASE
650
0
4
$a ITECHnetBASE
650
0
4
$a SCI-TECHnetBASE
650
0
4
$a STMnetBASE
776
0
8
$i Print version: $z 9781138578067
856
4
0
$u https://www.taylorfrancis.com/books/9781351265485 $z Click here to view.
999
$a VIRTUA
No Reviews to Display
| Summary | "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 focusing on how to create a logical data model where data is stored "where it belongs." Next, data usage is reviewed to transform the logical model into a physical data model that will satisfy user performance requirements. Finally, it describes how to use various software tools to create user interfaces to review and update data in a database.Organized into 11 chapters, the book begins with an overview of the functionality of database management systems and how they guarantee the accuracy and availability of data. It then describes how to define and normalize data requirements to create a logical data model, then map them into an initial solution for a physical database. The book next presents how to use an industry-leading data modeling tool to define and manage logical and physical data models. After that, it describes how to implement a physical database using either Microsoft Access or SQL Server and how to use Microsoft Access to create windows interfaces to query or update data in tables. The last part of the book reviews software tools and explores the design and implementation of a database using as an example a much more complex data environment for a University. The book ends with a description of how to use PHP to build a web-based interface to review and update data in a database. "--Provided by publisher. |
| Contents | chapter 1 Overview of Databases / chapter 2 Data Normalization / chapter 3 Database Implementation / chapter 4 Normalization and Physical Design Exercise / chapter 5 The erwin Data Modeling Tool / chapter 6 Using Microsoft Access / chapter 7 Using SQL Server / chapter 8 Using Perl to Extract and Load Data / chapter 9 Building User Interfaces / chapter 10 Creating the University Database Application / chapter 11 PHP Implementation and Use / |
| Subject | COMPUTERSCIENCEnetBASE Database Design & Development Database Management INFORMATIONSCIENCEnetBASE ITECHnetBASE SCI-TECHnetBASE STMnetBASE |
| Multimedia |