In a normalized database, all customer information is stored in a Customer table, invoices are stored in an Invoice table, and related account manager information in an Employee table. Suppose a customer changes their address and then demands old invoices with manager information. Will denormalization be more beneficial? How?
Chapter 8, Review question #48
In a normalized database, all customer information is stored in a Customer table, invoices are stored in an Invoice table, and related account manager information in an Employee table. Suppose a customer changes their address and then demands old invoices with manager information. Will denormalization be more beneficial? How?
This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!
Answer
Reducing the number of tables . Queries to be retrieved can be simpler. Less likely to have bugs…View the full answer
Related Book For 
Modern Database Management
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
ISBN: 9780134773650