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: building front end mysql database, building mysql database, move database tables mysql, 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, mysql, extract data mysql database display tables html perl, need someone fix mysql database, vba convert access database tables mysql, extract data html tables mysql database, mysql clear database tables wordpress, building relational mysql database, building iphone database app mysql, need edit field mysql database joomla

About the Employer:
( 29 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
(28 Reviews)
5.2

5 freelancers are bidding on average $110 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
(67 Reviews)
6.6
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
(34 Reviews)
5.8
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
(3 Reviews)
3.7
$111 USD in 1 day
(0 Reviews)
0.0