recipessetr.blogg.se - Mysql workbench erd

#MYSQL WORKBENCH ERD HOW TO#

So this means that a school could be a part of an association, but that NASCE may not have partnered with that association before. After talking to my supervisor, she explained that all associations could be partners, and that a partner is someone that NASCE has worked with or made an agreement with. Of all of this information that needed to be included, the aspect that I found the most confusing was the difference between affiliation and associations that the schools had. For the partner organizations, I needed to include their names, contact information (email and phone numbers), communication with the organizations, and history of the partnership. When it came to the schools, I needed to include their names, location, name of their community centers, contact information for the community centers and schools in general (email and phone numbers), past engagement history, communication with the schools, quotes for NASCE’s services offered, next administration information, and school associations. With the given dataset on Google Sheets, I noticed that the main distinction was between the colleges/universities, and the partner organizations they are affiliated with.

#MYSQL WORKBENCH ERD HOW TO#

I was able to accomplish each of these goals except for figuring out how to create forms and reports, since after further research I realized that the only way to do this is through PHP, which I have not had any prior experience in, and due to the time constraints of my internship I decided that I would learn this for my next internship if it is to involve this programming language.

Figuring out if I’d be able to create MySQL forms and reports.

Increasing the efficiency of data preparation and entry into the database, aiming to make more aspects of it automated.

Further improving upon my skills when it comes to data visualization and querying.

Having just completed the final project, I had less than half of the time left in this internship in order to build this database along with adding in all of the data that was currently on Google Sheets.įrom the last time using MySQL, I set myself specific goals to improve upon. Along with this, the techniques I used last time needed to be improved upon to a great extent if it meant finishing this project by the time this internship ended. This database had a wider area of coverage, but the real challenge was that the scale was much bigger compared to the previous one I had built. For this reason, I was really looking forward to exploring new ways of using MySQL.Īfter the completion of my final project on wind energy, I started working on the MySQL database for the National Assessment for Service and Community Engagement (NASCE). I also knew that there were many more areas that I needed to explore, and that I was just scratching the surface as to what MySQL is capable of, even with just having the community edition. Upon completing the MySQL and Python Database for Saratoga PLAN, which was my first real experience using that database management system (used by the likes of Tesla, Netflix, Airbnb, and several other large tech companies), I discovered several ways as to how MySQL stood out compared to MS Access which had been my only prior database experience.