Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started