Database application
Database application for products which are manufactured by the companies belonging to the Polish Association Manufacturers of Pipes and Fittings made with Polymers
The aim of this thesis was to design a database application for members of companies of the Polish Association Pipes and Fittings made with Polymers. The database was built in the MySQL Workbench 6.0.
Designed database is used for the main objective of the Association, which is the disse-mination of pipes and fittings manufactured by member companies among users through the promotion and activities which are integrating both communities.
This thesis consists of two main parts: a literature review and a methodology. The litera-ture review provides basic information about databases and SQL and in the methodology was described use of program, was built a relational database schema and was described the process of creating the database in MySQL Workbench.
The database schema consists of eight tables (company, city, voivodeship, product, category, subcategory, description, material). The tables in the majority of cases are connected for many-to-one relationship.
In MySQL Workbench was constructed an entity relationship diagram and the database was tested using a query language SQL.
Search from various English teachers...
Corrections · 4
0
Database application
This database application is for products which are manufactured by the companies belonging to the "Polish Association Manufacturers of Pipes and Fittings made with Polymers" association.
The aim of this thesis was to design a database application for member's of the "Polish Association Pipes and Fittings made with Polymers" association. The database was built in the MySQL Workbench 6.0.
The designed database is used for the main objective of the Association, which is the dissemination of pipes and fittings manufactured by member companies amongst users through the promotion and activities which are integrating both communities.
This thesis consists of two main parts: a literature review and a methodology. The literature review provides the basic information about the databases and SQL statements that are defined in the program. The methodology describes how the program was built using a relational database schema and the MySQL Workbench database software component.
The database schema consists of eight tables (company, city, voivodeship, product, category, subcategory, description, material). The tables in the majority of cases are connected for many-to-one relationship.
The MySQL Workbench was constructed using an entity relationship diagram and the database was tested using a SQL query language.
Want to progress faster?
Join this learning community and try out free exercises!
Don’t miss out on the opportunity to learn a language from the comfort of your own home. Browse our selection of experienced language tutors and enroll in your first lesson now!
Start Learning Today
