sql, er diagrams,relationship table

CSCI 340 Final Group Project

Natalie Warden, Arturo Gonzalez, Ricky Gaji

Introduction

As our world continues to rely on technology to store our information, issues concerning data storage and organization will arise

Association of Computing Machinery (ACM) has asked us to prepare a database through which they can easily and effectively access this information

In this project we have created a tier system of entities, established the relationships between them, and decreased redundancy by eliminating repeating attributes

Software Used:

Analysis:

Google Docs - helped to bring the group together and organize all our information to make sure we were on the same page.

Google Slides- served as the main platform in which to come up with our presentation and visualize what we are going to do.

Draw.io- used to build our many ER diagrams

Database Design:

x10 web hosting- hosted our website and had the tools necessary to get started on the database

phpMyAdmin- here we created our database tables and made sure all the attribute’s data types and entity’s primary key, foreign keys, and attributes were correct.

mySQL Databases- used as relational database management system

generatedata.com-used to create “dummy” data to incorporate in the SQL testing

Analysis and Findings