Synopsis: Metadata Tribbles

In this lesson, you will see a case showing how a database design creates more work.

Creating the Customers table

My friend worked for years as a programmer in Oracle PL/SQL and Java. She described a case that showed how a database design that was intended to simplify work instead created more work.

The Sales division at her company maintained a table Customers that kept data such as customers’ contact information, their business type, and how much revenue had been received from each customer:

Get hands-on with 1200+ tech skills courses.