Practical Guide to Database Design

✍ Scribed by Hogan, Rex

• Publisher: CRC Press LLC
• Year: 2018
• Tongue: English
• Leaves: 431
• Edition: 2nd edition
• Category: Library

✦ Table of Contents

1. Overview of Databases1.1 What's a "Database"? 1.2 Guranteed Accuracy and Availability of Data1.3 Dynamic alteration of design1.4 Dynamic Queries - any data, any time1.5 Referential Integrity Enforcement1.6 Backup/Recovery1.7 Failover1.8 Typical Installation2. Normalization2.1 Introduction2.2 The "Language of Normalization"2.3 Creating the Entity/Attribute List2.4 Cleaning Up the Entity/Attribute List2.5 Normalization2.6 Creating the Data Model2.7 Fourth Normal Form2.8 Fifth Normal Form 3. Database Implementation3.1 Logical to Physical Design3.2 Usage Path Analysis3.3 Table Key and Column Data Types3.4 Indexes3.5 Table Creation4. Normalization and Physical Design Exercise4.1 Introduction4.2 Creating the Entity/Attribute List4.3 First Normal Form4.4 The Logical Data Model4.5 Second Normal Form4.6 Third Normal Form4.7 The Physical Data Model5. The erwin Data Modeling Tool5.1 What is a Data Modeling Tool? 5.2 Why do I need a Data Modeling Tool? 5.3 Reverse Engineering5.4 Change Management5.5 Download and Install erwin Trial Software5.6 Create the University Logical Data Model5.7 Create the University Physical Data Model5.9 Create a SQL Server University Database6. Using Microsoft Access6.1 Overview6.2 Modifications to the Database Design6.3 Loading Data Into Tables6.4 Creating Queries6.5 Using Forms6.6 Generating Reports6.7 Deploying Access for a Team of Users6.8 The Role of Pass-Thru Queries7. Using SQL Server7.1 Overview7.2 Database Creation/Installation7.3 Creating Databases7.4 User Roles7.5 Authorized Users7.6 Backup/Recovery7.7 Loading Data Into Tables7.8 Creating Views7.9 Manual Queries and Edits7.10 Using Stored Procedures7.11 Using SQL Server Agent8. Using Perl to Extract and Load Data8.1 Why Perl? 8.2 Perl vs. Python8.3 Windows vs Unix8.4 Review key matching features8.5 Monitor SQL Server logs8.6 Monitoring Windows Logs8.7 Other Applications and Uses8.8 Loading Data into Tables8.9 Summary9. Building User Interfaces9.1 Used in Typical Office Environment9.2 Use Microsoft Access as GUI9.3 .NET Framework9.4 PHP9.5 JAVA10. Creating the University Database Application10.1 Create tables for University environment10.2 Create Relationships to Enforce Referential Integrity10.3 Design a Screen to Add New Students10.4 Create a Screen to Enroll Students in a Class10.5 Create a Screen to Assign Grades10.6 Create Screens to Enter Midterm and Final Grades10.7 Create a "Main" Menu10.8 Developing Applications for University Administrators11. PHP Implementation and Used11.1 Why PHP? 11.2 System Components11.3 Design of Web-based Interface11.4 Script Logic

✦ Subjects

COMPUTERS--Data Modeling & Design;COMPUTERS -- Data Modeling & Design