I need a fact

$\_$

table with columns of Store

$\_$

ID

$,$

$$Perscription ID

$,$

$$Brand

$\_$

ID and Quanity ordered. How do I script that to create it and how do I script the data to insert How do I put it together I am lost. I have the data but I can't seem to figure out how to do it I have done this but I can't add it to a fact table. CREATE TABLE $[3$NF$\_$PATIENT$]($

ID INT PRIMARY KEY,

NAME VARCHAR$(100),$

ADDRESS VARCHAR$(100),$

CITY VARCHAR$(50),$

STATE CHAR$(2))$;

INSERT INTO $[3$NF$\_$PATIENT$]($ID$,$ NAME, ADDRESS, CITY, STATE$)$ VALUES

$(1258,$ 'Matt Smith', $\text{'}203$ Norht Hazel', 'Glenwood', $\text{'}$IA$\text{'}),$

$(2258,$ 'John Blue', $\text{'}40$ South', 'Omaha', $\text{'}$NE$\text{'}),$

$(2245,$ 'Pete Jones', $\text{'}78$ North Maple', 'Chicago', $\text{'}$IL$\text{'}),$

$(2236,$ 'Bill Powers', $\text{'}10$ Dodge', 'Chicago', $\text{'}$IL$\text{'}),$

$(2367,$ 'Mark Bagg', $\text{'}234$ Elm', 'Manhattan', $\text{'}$KS$\text{'}),$

$(5523,$ 'Jim Dau', $\text{'}445$ Oak Street', 'New York', $\text{'}$NY$\text{'}),$

$(3335,$ 'Luke stier', $\text{'}999$ Maple', 'Tabor', $\text{'}$IA$\text{'}),$

$(3369,$ 'Emma Dier', $\text{'}3349$ Happs', 'Omaha', $\text{'}$NE$\text{'}),$

$(2228,$ 'Colleen Riek', $\text{'}3999$ Sams', 'Carroll', $\text{'}$I$\text{'})$;

SELECT $*$ FROM $[3$NF$\_$PATIENT$]$

CREATE TABLE $[3$NF$\_$DRUG$]($

ID INT,

DRUG$\_$NAME VARCHAR$(255),$

CODE$\_1$ VARCHAR$(10),$

CODE$\_2$ VARCHAR$(10),$

YEAR INT,

DEPARTMENT VARCHAR$(255),$

CODE$\_3$ VARCHAR$(10),$

CATEGORY VARCHAR$(255),$

VALUE$\_1$ DECIMAL$(10,2),$

VALUE$\_2$ INT,

VALUE$\_3$ DECIMAL$(10,2),$

PRIMARY KEY $($ID$,$ CODE$\_1,$ CODE$\_2,$ YEAR$)$

$)$;

$--$ Insert data into the 'medications' table

INSERT INTO $[3$NF$\_$DRUG$]($ID$,$ DRUG$\_$NAME, CODE$\_1,$ CODE$\_2,$ YEAR, DEPARTMENT, CODE$\_3,$ CATEGORY, VALUE$\_1,$ VALUE$\_2,$ VALUE$\_3)$ VALUES

$(12958,$ 'Heart Clear', $\text{'}2345\text{'},\text{'}$B$4456\text{'},1995,$ 'Cardiology', $\text{'}$F$4456\text{'},$ 'Whole Body', $34\mathrm{.}56,10,78\mathrm{.}56),$

$(12958,$ 'Heart Clear', $\text{'}2345\text{'},\text{'}$B$4444\text{'},1995,$ 'Cardiology', $\text{'}$F$4456\text{'},$ 'Whole Body', $34\mathrm{.}56,40,78\mathrm{.}56),$

$(12958,$ 'Heart Clear', $\text{'}5555\text{'},\text{'}$B$1111\text{'},1995,$ 'Cardiology', $\text{'}$F$4456\text{'},$ 'Whole Body', $34\mathrm{.}56,5,78\mathrm{.}56),$

$(13333,$ 'Lung Guard', $\text{'}2345\text{'},\text{'}$B$1452\text{'},1556,$ 'Pulmonary', $\text{'}$B$3458\text{'},$ 'Lung Health', $10\mathrm{.}56,234,123\mathrm{.}56),$

$(13333,$ 'Lung Guard', $\text{'}5555\text{'},\text{'}$B$3333\text{'},1556,$ 'Pulmonary', $\text{'}$B$3458\text{'},$ 'Lung Health', $10\mathrm{.}56,34,123\mathrm{.}56),$

$(13333,$ 'Lung Guard', $\text{'}1111\text{'},\text{'}$B$4444\text{'},1556,$ 'Pulmonary', $\text{'}$B$3458\text{'},$ 'Lung Health', $10\mathrm{.}56,12,123\mathrm{.}56),$

$(15555,$ 'Lung Work', $\text{'}2345\text{'},\text{'}$B$5674\text{'},1556,$ 'Pulmonary', $\text{'}$B$3458\text{'},$ 'Lung Health', $2\mathrm{.}56,99,34\mathrm{.}11),$

$(15555,$ 'Lung Work', $\text{'}1111\text{'},\text{'}$B$5677\text{'},1556,$ 'Pulmonary', $\text{'}$B$3458\text{'},$ 'Lung Health', $2\mathrm{.}56,44,34\mathrm{.}11),$

$(15555,$ 'Lung Work', $\text{'}2345\text{'},\text{'}$B$5671\text{'},1556,$ 'Pulmonary', $\text{'}$B$3458\text{'},$ 'Lung Health', $2\mathrm{.}56,17,34\mathrm{.}11),$

$(33333,$ 'Nervous Help', $\text{'}2345\text{'},\text{'}$B$5767\text{'},1337,$ 'Nervous', $\text{'}$W$3456\text{'},$ 'Nervous Support', $55\mathrm{.}11,10,44\mathrm{.}11),$

$(33333,$ 'Nervous Help', $\text{'}3345\text{'},\text{'}$B$5769\text{'},1338,$ 'Nervous II$\text{'},\text{'}$W$3456\text{'},$ 'Nervous Support', $22\mathrm{.}11,14,44\mathrm{.}11)$;

SELECT $*$ FROM $[3$NF$\_$DRUG$]$

$--$ Create a table called 'records'

CREATE TABLE $[3$NF$\_$PERSCRIPTIONS$]($

CODE VARCHAR$(10),$

DATE DATE,

ID INT,

VALUE$\_1$ INT,

VALUE$\_2$ INT

$)$;

$--$ Insert data into the 'records' table

INSERT INTO $[3$NF$\_$PERSCRIPTIONS$]($CODE$,$ DATE, ID$,$ VALUE$\_1,$ VALUE$\_2)$ VALUES

$(\text{'}$B$4456\text{'},\text{'}2015-04-15\text{'},1258,12,35),$

$(\text{'}$B$4443\text{'},\text{'}2015-01-13\text{'},2258,40,78),$

$(\text{'}$B$1111\text{'},\text{'}2015-02-13\text{'},2245,5,78),$

$(\text{'}$B$1452\text{'},\text{'}2015-03-01\text{'},2236,10,123),$

$(\text{'}$B$3333\text{'},\text{'}2015-06-12\text{'},2236,34,123),$

$(\text{'}$B$4444\text{'},\text{'}2015-08-01\text{'},2236,10,12),$

$(\text{'}$B$5674\text{'},\text{'}2015-07-14\text{'},2367,2,99),$

$(\text{'}$B$5677\text{'},\text{'}2015-07-16\text{'},5523,2,44),$

$(\text{'}$B$5671\text{'},\text{'}2015-04-01\text{'},3335,17,34),$

$(\text{'}$B$5767\text{'},\text{'}2015-12-12\text{'},3369,10,11),$

$(\text{'}$B$5769\text{'},\text{'}2015-11-23\text{'},2228,55,441)$;

SELECT $*$ FROM $[3$NF$\_$PERSCRIPTIONS$]$

$--$ Create a table called 'stores'

CREATE TABLE $[3$NF$\_$STORES$]($

CODE INT,

STORE$\_$NAME VARCHAR