I've created a new schema/database in DDL query thing in MySQL Work Bench. (I hope I explain myself well enough since I can't post images without 10 Rep apparently... Like the code below sort of stuff).
CREATE DATABASE IF NOT EXISTS `bicycle_rental`;
USE `bicycle_rental`;
CREATE TABLE `Bicycles`
(
`id_bicycles` int NOT NULL DEFAULT '0',
`bicycle_details` varchar(45),
PRIMARY KEY (`id_bicycles`)
);
But I can't figure out how to make it appear in the visual table like an EER model so I can see the relationships and all that.
Is there a way this can be done?
For MySQL Workbench when you fire the application, there should be a way for you to create a new EER Model from an existing database. Once you choose that option, you should be able to go through a wizard that guides you through the process.
Here is a helpful video.