database project (computer)
Sam640
CSCI340-PresentationSlides.pptxCSCI 340 Final Team Project
Birendra Bishwakarma, Dhiraj Thing Lama, Surya Pun
Outline
Introduction
Responsibility Assignment Matrix
Analysis
Entity Relationship Diagram
Tables
SQL Database
Conclusion
Introduction
To make any form of information more useful, easy to access and manage the data efficiently many organizations store information or data in their respective database system.
As a part of database project, our team was assigned to manage/maintain chapters and membership information and their relations by one of the largest computing associations in the world, The Association of Computing Machinery (ACM).
Our main task of the project was to update the database system and store its members and complex leadership components of the organization and connect all the entities with each other by their relations to each other and store the data so that it could be retrieved in the future.
Responsibility assignment matrix
RACI MATRIX:
R – Responsible
A – Accountable
C – Consult
I – Inform
ANALYSIS
According to our project team analysis, The Association of Computing Machinery (ACM) the main components of the assigned project can be classified into two main entities which are members and chapters and ACM provides different types of membership to its registered members.
To become a member of ACM, a client must apply for membership and once the payment is received by the organization, a client becomes ACM member.
The Association of Computing Machinery (ACM) mainly has two types of chapter which are state chapters and city chapters and as our entity relationship diagram below suggests, according to the entities ranking each entity is bound to report to its higher ranking entities.
Entity relationship diagram
Tables
Tables
SQL Database
Sql database
Sql database
conclusion
Designing a working and perfect database model for big organizations to store all data is a challenge.
To avoid as much mistakes and make this team project most productive and efficient we did break down process in many stages:
Documented our model.
Gathered all the data to create table and relational database.
Created foreign key to build an associative entity that helps us to efficiently manage the relational database.
To make it easy to fetch and insert data into database we made members as separate table that contains the data of all the members of The Association of Computing Machinery (ACM).
