Database Design and Development: An Essential Guide for It Professionals
Today's businesses depend on their databases to provide information essential for their day-to-day operations and to help them take advantage of today's rapidly growing and maturing electronic commerce opportunities. The primary responsibility for the design and maintenance of these databases rests with a company's information technology department.
Unlike other IT resources currently available that tend to focus on a particular product, Database Design and Development: An Essential Guide for IT Professionals was created to give today's IT directors and other IT staff a solid basic knowledge of database design and development to help them make educated decisions about the right database environment for their companies. Today's IT professionals must understand the fundamentals in order to determine their next steps for specializing in the vast field of database technology.
Database Design and Development: An Essential Guide for IT Professionals answers such common questions as:
- What is the purpose of a database system?
- What are the components of a database system?
- What type of data does your company need to capture?
- How do you design a database for a particular goal?
- How do you capture information through data modeling?
- How do you determine which database will best meet your business objectives?
- What's involved in effective database management and maintenance?
- How are database systems used to interface with the Internet?
Table of Contents
PART I: BASIC DATABASE CONCEPTS.
1. The Database Approach.
2. Overview of Major Components.
PART II: DATABASE DEVOPMENT PROCESS.
3. Significance of the Database Environment.
4. Database Development Life Cycle.
PART III: CONCEPTUAL DATA MODELING.
5. Data Modeling Basics.
6. Object-Based Data Model: Principles and Components.
7. Entity-Relationship Data Model.
PART IV: THE RELATIONAL DATA MODEL.
8. Relational Data Model Fundamentals.
9. Sematic Data Model to Relational Data Model.
10. Data Normalization Method.
PART V: DESIGN AND IMPLEMENTATION.
11. Completing the Logical Design.
12. The Physical Design Process.
13. Special Implementation Considerations.
PART VI: DATABASE ADMINISTRATION AND MAINTENANCE.
14. Overview of Administration Functions.
15. Data Integrity.
16. Database Security.
17. Ongoing Maintenance and Growth.
PART VII: ADVANCED DATABASE TOPICS.
18. Distributed Database Systems.
19. Database Systems and the Web.
20. Trends in Database Technology.
Appendix A. Legacy System Models: Hierarchical and Network.
Appendix B. Codd's Relational Rules.
Appendix C. Diagramming Conventions and Symbols.
Appendix D. Use of CASE Tools.
Appendix E. Review of Major Commercial DBMSs.
Appendix F. Database Design and Development Summary.
Sign up now »
- FTR&D EngineerSA
- FTFlash / ActionScript Developer - ContractNSW
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTQuality ManagerSA
- FTLead Software EngineerSA
- FTOS Web Applications DeveloperNSW
- FTSenior Python DeveloperNSW
- FTSenior Python Web Applications DeveloperNSW
- FTJob Title: Mac Systems/ Enterprise Systems EngineerNZ
- FTSenior Python DeveloperNSW
Governance for all is more than an IT initiative or a goal written in a plan document; it’s a strategy that unites IT and business content owners to achieve their ...
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
"Too little too late. Spice normally has better standards than this. I ..."
Spiceworks' free management software gets integrated MDM