[SOLVED] MySQL first database creation


I need to create a database for employees that stores information about their names, salaries, salary status, dates, and messages between the employees. At least 3 users are needed. Foreign keys and an ER diagram. Can I go about creating this database by creating tables, importing data thru code and then just create a diagram by reverse engineering. I have no clue. My main concern is whether it is enough to only use tables or is there more to it?
I’m completely new to MySQL and I hope some of you can help me out.


If you are using phpmyadmin, you can easily create a database and tables. or if you want to create by code you can use like,

CREATE DATABASE databasename;

and table will be created by like,

CREATE TABLE employees (
column1 datatype,
column2 datatype,
column3 datatype,

Answered By – Rashed Zaman

Answer Checked By – Marilyn (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published. Required fields are marked *