MySQL first database creation-CodePudding

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.

CodePudding user response：

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,
....
 );