Harsha Tharuka

This is an project detail

The main purpose of the project is to design a database for the ABC community portal in the current module.

Here, a database named “abc_community_portal“ was created for that. MySQL was used as the DBMS. Tables were created to store the data of all the web pages available in ABC. All of them were created as a table based on the user. That is, the primary key of the user table. By using the U_ID as a foreign key in all other tables.

Before creating the database, the ER diagram was created from the ERDplus online platform, There the basic design for the database was created. The ER diagram was created using the entity, attributes and relationship properly. Then the relation schema was created from the ER diagram platform.

After that, the database was created based on the logical relational schema and using MySQL.