I'm having trouble with this question with my data modeling class."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." backgroundmịc Chapter 6 Review Questions (Dro XSearch results for 'Jonny is appo* MindTap - Cengage Learning+A ng.cengage.com/static/nb/ui/evo/index.html?elSBN=9781337627924&snapshotld=2299594&id=1119970503&Elizabeth vCENGAGE MINDTAPQ Search this courseA My HomeChapter 6 Critical Thinking ExercisesAddressCharacter 123 Main Street YCoursesCityCharacter New YorkYO Catalog and Study ToolsStateCharacter NYA-Z* Partner OffersZipCharacter10008-212EE Rental OptionsBased on the table structures and business rules, match the following questions with the correct answers. Your answers should be in coordination with concepts discussed in Chapter-6.- College Success TipsJonny created a 2NF-compliant databaseWhich attribute will serve asCareer Success Tipsthe FK in the newly createdLocation table?structure.You are eligible for a FREE 7-day trial of Cengage Unlimitedor Cengage UnlimitedeТextbooksJonny removed City andState from the LocationTransitive Dependencies.table and added a linked Ziptable.Try for FreeThe existing Supplier table isin violation of?Eliminate the RepeatingGroups and create a newLocation table with uniqueLearn morerows.? HelpTo avoid unnormalized dataO Give Feedbackin the Supplier table,reflected by multivaluedattribute:1NF-compliant databasestructure.A functional dependencecriterion is fulfilled:Supplier-ID.If each value of A determinesJonny redesigned theSupplier table to?one and only one value of B.To achieve 3NF--compliantdatabase structure, JonnyJonny placed the Memo fieldin the redesigned Locationshould eliminate:table.Clear All backgroundmịc Chapter 6 Review Questions (Dro XSearch results for 'Jonny is appo* MindTap - Cengage Learning+A ng.cengage.com/static/nb/ui/evo/index.html?elSBN=9781337627924&snapshotld=2299594&id=1119970503&Elizabeth vCENGAGE MINDTAPQ Search this courseA My HomeChapter 6 Critical Thinking ExercisesThe existing (Legacy) Table(s) StructureCoursesO Catalog and Study ToolsSupplier table structure:A-ZAttribute (Field) Data Type| ExampleRequired* Partner OffersSupplier-IDCharacter sUP-112YEE Rental OptionsSupplier-Name Character ACM Medical Supplies, Inc.Y- College Success TipsTel-NumCharacter1-888-666-4444YCareer Success TipsLocation1-IDCharacter SUP-112-L1YLocation2-IDCharacter SUP-112-L2You are eligible for a FREE 7-day trial of Cengage Unlimitedor Cengage UnlimitedeТextbooksLocation3-IDCharacter | SUP-112-L3Rep1Character Hansen, JoeYTry for FreeRep2Character Smith, TiffanyNLearn moreRep3Character? HelpTel#1Character 511-7277-7744YTel#2Character 572-7777-7745O Give FeedbackTel#3CharacterMemoCharacter1. Called Tiffany for Part# 112232. The expected delivery is on or before 2/28/18. N2. Joe reported that the Part# 111232 is out-of-stock.Location table structure:Attribute (Field) Data Type | ExampleRequiredLocation-IDCharacter 112-L2YSupplier-IDCharacter 112YAddressCharacter 123 Main Street YCityCharacter | New YorkYStateCharacter NYY

Here are the answers: 1. Supplier Id ->FK exists in table(location) 2.For redesigning by removing…

Answered: nny is appointed as an intern position,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

I'm having trouble with this question with my data modeling class.

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."

background
mịc Chapter 6 Review Questions (Dro X
Search results for 'Jonny is appo
* MindTap - Cengage Learning
+
A ng.cengage.com/static/nb/ui/evo/index.html?elSBN=9781337627924&snapshotld=2299594&id=1119970503&
Elizabeth v
CENGAGE MINDTAP
Q Search this course
A My Home
Chapter 6 Critical Thinking Exercises
Address
Character 123 Main Street Y
Courses
City
Character New York
Y
O Catalog and Study Tools
State
Character NY
A-Z
* Partner Offers
Zip
Character
10008-212
EE Rental Options
Based on the table structures and business rules, match the following questions with the correct answers. Your answers should be in coordination with concepts discussed in Chapter-6.
- College Success Tips
Jonny created a 2NF-
compliant database
Which attribute will serve as
Career Success Tips
the FK in the newly created
Location table?
structure.
You are eligible for a FREE 7-
day trial of Cengage Unlimited
or Cengage Unlimited
eТextbooks
Jonny removed City and
State from the Location
Transitive Dependencies.
table and added a linked Zip
table.
Try for Free
The existing Supplier table is
in violation of?
Eliminate the Repeating
Groups and create a new
Location table with unique
Learn more
rows.
? Help
To avoid unnormalized data
O Give Feedback
in the Supplier table,
reflected by multivalued
attribute:
1NF-compliant database
structure.
A functional dependence
criterion is fulfilled:
Supplier-ID.
If each value of A determines
Jonny redesigned the
Supplier table to?
one and only one value of B.
To achieve 3NF--compliant
database structure, Jonny
Jonny placed the Memo field
in the redesigned Location
should eliminate:
table.
Clear All

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.