I am having trouble creating SQL code to put this data in a database. Could someone help me with a couple of examples of how I can implement this data properly? Here is what I have so far.

/* ADVSQLDBINIT.SQL */ /* Advanced SQL */ /* Script file for MS SQL Server DBMS */ /* This script file creates the following tables: */ /* V - default vendor table data */ /* P - default product table data */ /* E /* STORE, SERVICES, CUSTOMER, APPOINTMENTS, WALK-INS, PREFERENCES, PROMOTION, PAYMENT, CREDIT CARD, CHECK, PRODUCTS, VENDOR, CUSTOMER ORDER, CUSTOMER PREFERENCES, ORDER LINE */ /* EMPLOYEE, EMP */ /* and loads the default data rows */

CREATE DATABASE A2ZSalon; USE A2ZSalon;

BEGIN TRANSACTION;

DROP TABLE EMP; DROP TABLE STORE; DROP TABLE SVR; DROP TABLE CUS; DROP TABLE APT; DROP TABLE WKINS; DROP TABLE PREF; DROP TABLE PROMO; DROP TABLE VENDOR; DROP TABLE PRODUCT; DROP TABLE CC; DROP TABLE CHK; DROP TABLE CC_PAYMENT; DROP TABLE CHK_PAYMENT; DROP TABLE PAYMENT; DROP TABLE CUS_ORDER; DROP TABLE CUS_PREF;

CREATE TABLE EMP ( EMP_ID INTEGER PRIMARY KEY, EMP_FNAME VARCHAR(35) NOT NULL, EMP_LNAME VARCHAR (35) NOT NULL, EMP_ADDRESS VARCHAR (35), EMP_DOB DATETIME, EMP_HIRE_DATE DATETIME, STR_ID INTEGER,);

CREATE TABLE STORE ( STR_ID INTEGER PRIMARY KEY, STR_ADDRESS VARCHAR(35) NOT NULL, STR_NAME VARCHAR(35) NOT NULL,);

CREATE TABLE SVR ( SERV_ID INTEGER PRIMARY KEY SERV_NAME VARCHAR (35) NOT NULL, SERV_TYPE VARCHAR (35) NOT NULL, SERV_PRICE NUMERIC (##) NOT NULL,);

CREATE TABLE CUS ( CUS_ID INTEGER PRIMARY KEY, CUS_FNAME VARCHAR (35) NOT NULL, CUS_LNAME VARCHAR (35) NOT NULL, MEM_ID INTEGER NOT NULL, EMP_ID INTEGER NOT NULL, CUS_DOB INTEGER NOT NULL, CUS_ADDRESS VARCHAR (35) NOT NULL,);

CREATE TABLE APT ( APT_ID INTEGER PRIMARY KEY, APT_DATE INTEGER NOT NULL, APT_TIME NUMERIC NOT NULL, FOREIGN KEY (CUS_ID) REFERENCES CUS), FOREIGN KEY (EMP_ID) REFERENCES EMP);

CREATE TABLE WKINS ( WALK_IN INTEGER PRIMARY KEY, WALK_DATE NUMERIC NOT NULL, FOREIGN KEY (CUS_ID) REFERENCES CUS), FOREIGN KEY (EMP_ID) REFERENCES EMP);

CREATE TABLE PREF ( PREF_ID INTEGER PRIMARY KEY, PREF_TYPE VARCHAR (15) NOT NULL, PREF_NAME VARCHAR (15) NOT NULL,);

CREATE TABLE PROMO ( PROM_ID INTEGER PRIMARY KEY, PROM_TYPE VARCHAR(35) NOT NULL, PROM_PRICE NUMERIC NOT NULL, PROM_TYPE VARCHAR (35) NOT NULL,);

CREATE TABLE VENDOR ( VEN_ID INTEGER PRIMARY KEY, VEN_NAME VARCHAR(35) NOT NULL, VEN_ADDRESS VARCHAR(35) NOT NULL,);

CREATE TABLE PRODUCT( PROD_ID INTEGER PRIMARY KEY, PROD_TYPE VARCHAR(35) NOT NULL, PROD_NAME VARCHAR (35) NOT NULL, FOREIGN KEY (VEN_ID) REFERENCES VENDOR);

CREATE TABLE CC ( CC_NUM INTEGER PRIMARY KEY, CC_EXP_DATE DATETIME, CC_NAME VARCHAR(35) NOT NULL, CC_CVV CHAR(3) NOT NULL, FOREIGN KEY (CUS_ID) REFERENCES CUS);

CREATE TABLE CHK ( CHECK_NUM INTEGER PRIMARY KEY, CHECK_DATE DATETIME, CUST_ACCT_NUM INTEGER, CHECK_RT_NUM INTEGER, CHECK_AMT NUMERIC, FOREIGN KEY (CUS_ID) REFERENCES CUS);

CREATE TABLE CC_PAYMENT ( CC_NUM INTEGER PRIMARY KEY, FOREIGN KEY (CC_NUM) REFERENCES CUS), CUS_ORDER_ID PRIMARY KEY, FOREIGN KEY (CUS_ORDER_ID) REFERENCES CUS), CC_PAY_DATE DATETIME, CC_PAY_AMT NUMERIC, CC_CONF_NUM INTEGER,);

CREATE TABLE CHK_PAYMENT ( CHECK_NUM INTEGER PRIMARY KEY, FOREIGN KEY (CHECK_NUM) REFERENCES CHK, CHECK_PAY_DATE DATETIME, CHECK_PAY_AMT NUMERIC, CHECK_PAY_CONF_NUM INTEGER,);

CREATE TABLE CUS_ORDER ( CUS_ORDER_ID INTEGER PRIMARY KEY, CUS_ORDER_DATE DATETIME, CUS_ORDER_AMT NUMERIC,);

CREATE TABLE CUS_PREF ( CUS_ID INTEGER PRIMARY KEY, FOREIGN KEY (CUS_ID) REFERENCES CUS, CUS_PREF_NOTES VARCHAR(35) NOT NULL,); EDIT: Basically I want to take the data from that ERD diagram and put it into a data base in SQL using Microsoft Visual Studio.

CUSTOMER EMPLOYEES PK EMP ID FNAME LNAME MEM ID EMP FNAME EMP LNAME EMP ADDRESS EMP DOB EMP HIRE DATE SERVICES FK1 EMP ID NUM PK SERV ID PROMOTION CUS DOB CUS ADDRESS SERV NAME SERV TYPE PK PROM ID FK1 STR ID APPOINTMENTS SERV PRICE PROM TYPE PROM PRICE PROM TYPE PK APPT ID CUSTOMER PREFERENCES APPT DATE APPT TIME PK,FK1 CUS ID PK,FK2 PREE ID has FK1 CUS ID FK2 EMP ID NUM CUS PREF_NOTES STORE SERVICE LINE has PK STR ID PK,FK1 EMP ID PK,FK2 SERV ID STR ADDRESS STR NAME PREFRENCES has WALK INS PK PREF ID PREF TYPE PREF NAME has CREDIT PAYMENT WALK DATE WALK TIME FK1 CUS ID FK2 EMP ID NUM CUSTOMER ORDER CC PAY DATE CC PAY AMT CC CONF_NUM CUS ORDER DATE CUS ORDER AMT PRODUCTS has FK1 CUS_ID FK2 PROO ID PK PROD ID has PROD TYPE PROD PRICE PROD NAME CHECK FK1 VEN ID CHECK PAYMENT CHECK DATE CUST ACCT NUM CHECK RT NUM CHECK AMT VENDOR CREDIT CARD PK CC NUM PK VEN ID CHECK PAY DATE FK1 CUS ID CHECK PAY_AMT CHECK PAY CONF NUM VEN NAME VEN ADDRESS CC EXP DATE CC NAME FK1 CUS ID CUSTOMER EMPLOYEES PK EMP ID FNAME LNAME MEM ID EMP FNAME EMP LNAME EMP ADDRESS EMP DOB EMP HIRE DATE SERVICES FK1 EMP ID NUM PK SERV ID PROMOTION CUS DOB CUS ADDRESS SERV NAME SERV TYPE PK PROM ID FK1 STR ID APPOINTMENTS SERV PRICE PROM TYPE PROM PRICE PROM TYPE PK APPT ID CUSTOMER PREFERENCES APPT DATE APPT TIME PK,FK1 CUS ID PK,FK2 PREE ID has FK1 CUS ID FK2 EMP ID NUM CUS PREF_NOTES STORE SERVICE LINE has PK STR ID PK,FK1 EMP ID PK,FK2 SERV ID STR ADDRESS STR NAME PREFRENCES has WALK INS PK PREF ID PREF TYPE PREF NAME has CREDIT PAYMENT WALK DATE WALK TIME FK1 CUS ID FK2 EMP ID NUM CUSTOMER ORDER CC PAY DATE CC PAY AMT CC CONF_NUM CUS ORDER DATE CUS ORDER AMT PRODUCTS has FK1 CUS_ID FK2 PROO ID PK PROD ID has PROD TYPE PROD PRICE PROD NAME CHECK FK1 VEN ID CHECK PAYMENT CHECK DATE CUST ACCT NUM CHECK RT NUM CHECK AMT VENDOR CREDIT CARD PK CC NUM PK VEN ID CHECK PAY DATE FK1 CUS ID CHECK PAY_AMT CHECK PAY CONF NUM VEN NAME VEN ADDRESS CC EXP DATE CC NAME FK1 CUS ID