|
Learn to Design Databases |
|
ER (Entity-Relationships)
List of various Free or Almost free or Regular ER design Tools. Overview of this method for designing relational databases and developing a conceptual schema. Introduction to Data Modelling Informal introduction to data modeling using the Entity-Relationship Visio Download Site with lots of database diagrams. Many Links on Database Design.
Normalization Windows Media Player Presentation (Slides and Voice) Covers the different steps and rules to create a relational database. Good Introduction ! Understanding Relational Database Design Downloadable Word document (Reldes.doc—20 pages ) that shows you how to plan and design a database from the ground up. It contains design examples of the Northwind sample database included in the Ms-Access and Ms-SQL Server. Access 2002 version, links to Access 97 and 2000 versions.
Sessions on Relational Database Design Downloadable Word document (AC101.DOC-23 pages ) "Fundamentals of Relational Database Design" and a sample ms-Access database DESIGN.MDB This excellent guide covers Keys, Domains,Normalization with lots of understandable examples.
Database Design Considerations Msdn Online course covering database creation steps. Covers Normalization.
Database Services (Data Modeling ..) This online HTML book is an informal introduction to graphical data modeling using the Entity-Relationship (ER) approach. Not only covers Primary Keys,Attributes, Hierarchies and Integrity Rules, but also an in-depth review of the Normalization rules.
PDF presentation about data modeling
Access Database Design and Normalization Article issued by Sams Publishing, covering amongst others Codd’s Normalization rules including lots of examples.
step-by-step guides to using databases Easy to understand online database tutorial including design.
French Links Conception de bases de données Première approche destinée à préciser la démarche et les concepts nécessaires pour construire des bases de données cohérentes. Site de Witold Litwin (professeur d’Université) avec nombre de présentations powerpoint. Site microsoft avec div. liens conception bdd Access Où trouver des informations relatives à la conception d'une base de données dans Access
Les bases de données relationelles Informations complête sur les bases de données, le SQL, etc..
Dutch Links Wikipedia over het ER model.
Gegevensmodel omzetten naar relationele database Word document
Books Database Design for Mere Mortals A Hands-On Guide to Relational Database Design. |
|
Learn To Design |
