Designing your database in pdf

Aims and Learning Objectives

By the end of this document, you will be able to:

• explain the three types of logical relationship that can be identified in database design and point out the only relationship that should be used in logical design;
• explain how to resolve many-to-many relationships;
• explain where primary and foreign keys must be located in any logical design;
• capture data requirements from paper forms or spreadsheets;
• draw simple data structure models with correctly-placed primary and foreign keys.