Completed

Need assistance building a Mysql Database

I need assistance building a mysql database help manage 263 network monitors... but i've been running into foreign key Constraint failures issues when trying to import records via csv files using workbench.

The CSV files will be attached

Here is a snippet of my code

CREATE TABLE GSTORMAIN (

GID INT NOT NULL AUTO_INCREMENT,

Hostname VARCHAR(40) NOT NULL,

IPAddress VARCHAR(16) NOT NULL,

serial VARCHAR(20) NOT NULL,

model VARCHAR(5) NULL,

Devicetype VARCHAR(20) NULL,

NumberOfDrives int,

Addr_ID INT,

Status_ID INT,

Supman_ID INT,

CardCap_ID INT,

os_ID INT,

SiteContact_ID INT,

ArecaVer_ID INT,

foreign key (Addr_ID) references Address (Addr_ID),

foreign key (Status_ID) references Gstatus (Status_ID),

foreign key (Supman_ID) references Supervisor (Supman_ID),

foreign key (CardCap_ID) references CaptureCard (CardCap_ID),

foreign key (os_ID) references OperatingSystem (os_ID),

foreign key (SiteContact_ID) references SiteContact (SiteContact_ID),

foreign key (Arecaver_ID) references Arecaver (Arecaver_ID),

PRIMARY KEY (GID)

);

CREATE TABLE Lom (

GID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

LomCardSwitch VARCHAR(50),

LomURL VARCHAR(50),

LomIP VARCHAR(50),

LomGW VARCHAR(50),

LomMASK VARCHAR(50),

FOREIGN KEY (GID) REFERENCES GSTORMAIN (GID)

);

CREATE TABLE Monitor (

GID INT PRIMARY KEY,

TransportSwitch VARCHAR(50),

Monitor1_switch VARCHAR(50),

Monitor2_Switch VARCHAR(50),

Monitor3_switch VARCHAR(50),

Monitor4_switch VARCHAR(50),

Monitor5_switch VARCHAR(50),

Monitor6_switch VARCHAR(50),

Monitor7_Switch VARCHAR(50),

Monitor8_Switch VARCHAR(50),

TrafficCopyMethod VARCHAR(20),

FOREIGN KEY (GID) REFERENCES gstormain (GID)

);

CREATE TABLE WINDOWS_KEYS (

GID INT PRIMARY KEY,

Windows_Product_Keys VARCHAR(50),

FOREIGN KEY (GID) REFERENCES gstormain (GID)

);

Delete Table Sitcontact

CREATE TABLE SiteContact (

SiteContact_ID INT AUTO_INCREMENT,

FirstName VARCHAR(20),

LastName VARCHAR(30),

Phone VARCHAR(12),

PRIMARY KEY (SiteContact_ID)

);

CREATE TABLE OperatingSystem (

OS_ID INT NOT NULL AUTO_INCREMENT,

OperationSys VARCHAR(10),

PRIMARY KEY (os_ID)

);

Create Table Supervisor (

Supman_ID INT NOT NULL AUTO_INCREMENT,

SupportManager VARCHAR(40),

PRIMARY KEY (Supman_ID)

);

Create Table GStatus (

Status_ID INT not null auto_increment,

Status VARCHAR(12),

PRIMARY KEY (Status_ID)

);

I am attaching the CSV files i am trying to import into the tables

Skills: Database Administration, Database Programming, MySQL, PHP, SQL

See more: how to use mysql on mac, how to install mysql on windows 10, how to run mysql on mac, how to create database in mysql workbench, mysql command line mac, mysql mac download, how to use mysql on mac terminal, start mysql server mac, I have a database I need updated with missing records. , i need to hire a typist i need to hire typist, i have two million i need to start business so i need advice, i am a building painting contractor i need any painting contract job consulting web mail id, need assistance with building a site with wordpress, i need an architect to do my building in montreal, i have an existing php/mysql script that i need customized with additional functions

About the Employer:
( 22 reviews ) parlin, United States

Project ID: #15532391

Awarded to:

hamzzaamalik

Sir will do it for you and complete on time.I am a full time freelancer, working for more than 3 years now. Have clients from different parts of the world. Relevant Skills and Experience Mysql,sql Proposed Milestones More

$30 USD in 1 day
(0 Reviews)
0.0

6 freelancers are bidding on average $101 for this job

hjr122413

hi thanks for your posting. I have many experiences in mysql database, import/export the csv file to mysql, so if you hire me, i can finish this task perfectly. I have checked address csv file. I am confident. Rel More

$155 USD in 3 days
(23 Reviews)
5.3
pabloramirezdz

Hi, I'm a developer with 10+ years experience. I have good knowdelge of MySql, and i think your ploblem it's easy to fix. Relevant Skills and Experience Database Administration, Database Programming, MySQL, PHP, SQL More

$155 USD in 3 days
(3 Reviews)
2.9
redbanan199066

Hi I read your job very carefully. I have rich experience about (Cake Php, Codeigniter, Laravel, Nodejs, Html, Html5, Css, Css3, Jquery, Bootstrap, Mysql) for 9 years. Stay tuned, I'm still working on this proposal.

$55 USD in 3 days
(0 Reviews)
0.0
$111 USD in 1 day
(0 Reviews)
0.0
marcelofreelance

Hi I can help you with this right now. I have over 10 years experienced with monitorinh using IBM and MySQL enterprise applications Regards

$100 USD in 1 day
(0 Reviews)
0.0