Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Creating SQL tables for Employees, Inventory, and Sales. I have created a diagram of their relationships, but I need to make them into 3NF and

Creating SQL tables for Employees, Inventory, and Sales. I have created a diagram of their relationships, but I need to make them into 3NF and I am not sure if I can make it past 2NF. Additionally, I need to write a SQL script to build these tables and to add some information to each. See the image for what I have so far, and let me know if I need to explain anything in more detail. image text in transcribed

Product name Employee unit Price Database Product addresu! Inventory Database T Hie Date % of Monthyl sales Price Current Inventory Product Emp Sale must update per TD I Transaction und (P.O. # Database - Customer Transaction Code Date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions

Question

List the advantages and disadvantages of the pay programs. page 505

Answered: 1 week ago