Case Scenario: Jonny is appointed as an intern position, which might lead to a junior database architect role in TechTrend Corporation (TTC). Jonny is assigned to redesign two legacy tables related to "Suppliers," to be normalization compliant. The following business rules are provided. Business Rules:
1. Suppliers can be local or national, thus can have multiple locations.
2. Any location can supply items to TechTrend.
3. Any location manager can have a separate pricing deal with TechTrend, based on production process specific to that location and localization efficiency.
4. Each location has a contact person assigned to TechTrend.
5. Traditionally, TechTrend dealt with a singular location, at the most two. With rapid growth in business, the TTC officials are finding better leverage possibilities to negotiate beneficial terms with suppliers in multiple locations.
6. The DB administrator has specifically requested Johnny to keep in mind the strategic business needs, while restructuring the tables.
7. There are other tables within the database, which are beyond the context of this exercise.