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 […]
Category Archives: Database Systems
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 […]