Our Team Collaboration & Contribution
S.W.L Priyadarshana - 520261624
- Idea for the case study
- Design the relational database
- Database & SQL support
- Support to design the blog
M.M.L.V Mannapperuma - 620268822
- Identify business scenarios for the system
- Identify Functional & Non-functional requirements
- Database & SQL support
R.D.T Madhushan - 720268530
- Designing the ER Diagram
- Database & SQL with MySQL Workbench
- Design & add content to the blog with blogger.com
K.B.N.M Jayathilaka - 520270531
- Designing the ER Diagram
- Database & SQL support
- Maintaining the workflow according to guidelines
W.M.P.S Bandara - 420261671
- Normalization with explanations
- Writing the explanations for sub tasks
- Database & SQL support
Conclusion
As listed in the above contributions given by the group members, we have gained: communication skills while selecting an Information system for the case study, understanding the entities that should be include in the database, normalization procedures, SQL skills, how to design relational database and ERD and at last getting familiar with MySQL Workbench to create & manage the database.