Rumyhub

The place where stuff Happens

First Cut of the Database For the Main Project

I have just finished by first cut design for the main project. The design is not good and I will improve on such in my second cut designs. In the first cut design has:

  •         Client table which has all the client details needed
  •         With two subtypes employee and client
  •         A role table that stores all the privileges of the roles
  •         Profile table that stores all the account related details
  •         And Comment table which stores all the comments of the profile

Here is the ERD (Entity Relational Diagram) ...

 

blog comments powered by Disqus