Sales Amount is dependent both on Sales Person and Customer SALESPERSON ID 3462 SALESPERSON_NAME Waters SALESPERSON CITY

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Sales Amount is dependent both on Sales Person and Customer SALESPERSON ID 3462 SALESPERSON_NAME Waters SALESPERSON CITY

Post by answerhappygod »

Sales Amount Is Dependent Both On Sales Person And Customer Salesperson Id 3462 Salesperson Name Waters Salesperson City 1
Sales Amount Is Dependent Both On Sales Person And Customer Salesperson Id 3462 Salesperson Name Waters Salesperson City 1 (43.26 KiB) Viewed 26 times
Move the tables step by step to 3NF.
I want to see all your steps. Name your tables and identify the
Primary key in each table
please don't handwrite the answers.
Sales Amount is dependent both on Sales Person and Customer SALESPERSON ID 3462 SALESPERSON_NAME Waters SALESPERSON CITY Philadelphia SALESPERSON MANAGER Anne Waters MANAGER PHONE 215-987-1900 CUSTOMER_NUMBER 18765, 18830 CUSTOMER BALANCE 450.50, 101.98 SALES_AMOUNT 1500, 2589 CUSTOMER NAME Delta Systems, Seward Systems R.W Food Inc, A.Levy and Sons, Iron Mountain Inc 3593 Dryne Princeton Phil Dryne 267-456-0987 18841, 18899, 19056 11.67, 342,0.00 776, 1987
Student_ID 9110 9112 9114 Student_Name Chloe Kim Elizabeth Hawthorn Charlie Williams Student City Ambridge Beaver Clinton Student_ZipCode Course_ID 15001 2101, 2134, 2145 15009 2109, 2145 15026 2101, 2109, 2876 Course_Name Glassblowing, Drawing ii, Photography Painting ii, Photography Glassblowing, Painting ii, 3D Arts Course_Campus Main, Main, UBC LBC, UBC Main, LBC, Main Course Rooms Main 10, Main11, UBC13 LBC22, UBC13 Main 10, LBC22, Main34 Grade A, B, B C, B B, A, A
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply