Database Design

#	Web Link	Hits
1	Database Design for Mere Mortals by Michael J. Hernandez It is important to have a properly designed database so that accurate information can be provided to an organization. It is much easier to create an effective design initially so that necessary modifications to the database are kept at a minimum. Discovering problems after a database has been put into operation can be detrimental to a business, institution or organization.	163
2	Database Design Primer by William Sproule	88
3	Relational Database Concepts by Wiley This 12 page article provides a very basic overview of relational databases. It is useful for the database novice because it makes comparisons to spreadsheets as well as provides a foundation in the jargon required to navigate through more complicated database articles. [Summary by Stephanie Allen]	151
4	Database Basics Databases offer a convienient and powerful way to organize your information. In Database Basics, you'll learn how to get started in the world of databases, normalize your database according to commonly accepted design principles, add security to your database and use database keys and transactions.	98
5	Entity-Relationship Diagram An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes.	120
6	Creating Relationships in Microsoft Access 2007 The true power of relational databases lies in their ability to track relationships (hence the name!) between data elements. However, many database users don’t understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet. In this tutorial, we’ll walk through the process of creating a relationship between two tables in an Access database.	123
7	Databases Glossary	91
8	Data Modelling A data model is a conceptual representation of the data structures that are required by a database. The data structures include the data objects, the associations between data objects, and the rules which govern operations on the objects. As the name implies, the data model focuses on what data is required and how it should be organized rather than what operations will be performed on the data. To use a common analogy, the data model is equivalent to an architect's building plans.	97

Database Design

Main Menu