Definition of how the entities within the database relate

Database normalisation and informal guidelines

Database Normalisation and informal design guidelines follows on from “Database planning of modules and mechanisms“, this time I am required to apply Normalisation upon my database design, discuss the Four informal design guidelines that may be used as measures to determine the quality of relation schema design as well as show sample SQL statements. Table […]

Entity-Relational (ER) model

Database planning of modules and mechanisms

You have been contracted to design a database for a car rental company called “Lincoln Vehicle Rent” based in Lincolnshire. The company needs to provide full rental service which includes keeping track of customers, cars, orders and staff. Your database solution should offer the opportunity for customers to specify particular parameters about what they are […]