Relational Database Design BeginnersPrerequisites
This course gives a simple introduction to organizing your data in a relational database. It aims to explain the arranging of your data. It does not deal with specific relational databases systems such as Access, Oracle or SQL Server, or the technical tools that you would or could use to set up your database. The course aims to provide you with enough information to sit down and design your database, regardless of the database product that you intend to use. Exercises will be done on paper, without using computers.
- All current University members (departments and colleges)
- Further details regarding eligibility criteria are available
Although the exercises will not involve using a computer, basic IT literacy/awareness will be helpful.
Number of sessions: 1
# | Date | Time | Venue | Trainer | |
---|---|---|---|---|---|
1 | Fri 27 Apr 2018 09:00 - 13:00 | 09:00 - 13:00 | University Information Services, Roger Needham Building, Ely Training Room 1 | map | Lynn Foot |
- Entity-Relationship Diagrams
- Tables and Fields
- Keys and Joins
- A practical understanding of normalisation
A mixture of presentations and pencil-and-paper exercises.
One half day session
- Access 2016: Creating a Simple Database
- Access 2016: Fast Track Introduction
- Access 2016: Further Use
Booking / availability