This course takes you through the steps required to create a good relational database design from concept to implementation. A relational database is one where data is organised into tables by subject, related by common fields. Before even starting to build, it is essential to work out a design which properly models your project. You will learn to analyse scenarios, choosing suitable fields where data can be stored. You will learn the principles of good design for a database. You will consider why fields should be organised into separate tables, and how they can be related. You will look at different kinds of relationships (joins) and when to use them. The course includes plenty of worked examples and practice activities. The course does not use any particular software, so it will help you create a well-designed database structure which you can build later using the database software of your choice.
|Intended audience||Those who need to create a new database, designing the structure for a data collection and analysis project. Also those who need to work on an existing database, revising the structure for changing requirements.|
|Prior knowledge||No previous experience of database design or building is required. No software knowledge is required.|
|Resources||Notes and resources will be available online|
|Software||Suitable for building a database using a range of software|
|Format||Presentation, practical exercises and some group work|
|Where next?||Access: Building a database|
Frequency: Every term. Express an interest in future dates for this course.