Home /
Expert Answers /
Computer Science /
create-sql-code-to-create-all-the-tables-including-primary-and-foreign-keys-region-begin-tabular-pa430
(Solved): . Create SQL code to create all the tables including primary and foreign keys Region \\begin{tabular ...
. Create SQL code to create all the tables including primary and foreign keys
Region \\begin{tabular}{|c|c|} \\hline RegionID & RegionName \\\\ \\hline 101 & North \\\\ \\hline 102 & South \\\\ \\hline 103 & East \\\\ \\hline 104 & West \\\\ \\hline 105 & Central \\\\ \\hline \\end{tabular} Supplier \\begin{tabular}{|c|c|c|c|} \\hline SuppID & SuppName & SuppPhone & regionID \\\\ \\hline 1 & Cost Company & \\( 111-222-7895 \\) & 101 \\\\ \\hline 2 & Wallflower & \\( 222-333-1236 \\) & 105 \\\\ \\hline 3 & Sam Central & \\( 333-444-4569 \\) & 105 \\\\ \\hline 4 & Glamazon & \\( 444-555-1597 \\) & 103 \\\\ \\hline \\end{tabular} Item \\begin{tabular}{|c|c|c|c|c|} \\hline ItemID & ItemDescription & ItemPrice & ItemOnHand & SuppID \\\\ \\hline 1001 & Lamp & 15.00 & 10 & 1 \\\\ \\hline 1002 & Shoes & 30.00 & 5 & 3 \\\\ \\hline 1003 & Shirt & 20.00 & 12 & 2 \\\\ \\hline 1004 & Table & 50.00 & 13 & 4 \\\\ \\hline 1005 & Socks & 5.00 & 20 & 2 \\\\ \\hline \\end{tabular}
Expert Answer
Based on the data provided, I can help you create SQL code to define the tables Region, Supplier, an...