create the project using MySQL

Project description
You are running your own
store. You want to keep track of your customers’ information, merchandise
information, orders, bills, receipts, likings, and feedback, restock-ing your
merchandise, etc. You are free to choose the name of your store and what you sell.
Make sure that you do not share your idea with other students. Similarities
will be flagged as plagiarism and both of you will get an F.
Your store should be
unique and is about something you like or is passionate about.
You will use MySQL to
create your DB. However, you will create two interfaces: one through Java and
the other through PHP to experience the differences between both types.
The following listed
deadlines are for planning purposes only. Following these deadlines will
ensure that you successfully complete the project on time and deal with any
issues that may come up early. Submit Report by 12/6/21.

11/29/21

– Develop a Schema for
DB
– Develop ER/EER
– Mapping into
relational DB scheme (performing the 9 steps)

11/30/21

– create the project
using MySQL ~ create the tables, set up attributes and relations, and
fill them with data. Make sure to use appropriate names, etc.
– List the queries of
your system. For example, print customer info, print receipts, etc. You
will need to write them as English sentences and in SQL

12/01/21

– Implement and Run
Project through an interface using Java
– Implement and
Run the same Project through an interface using PHP

12/03/21

– Write Project
report ~ check next section

Project Report
sections:
o (2 points) Title page
(your name, project title, semester, course name and number, instructor name)
and Name of store
o (6 points) Project
description. Also list the software, tools, programming languages, etc. used
and version.
o (6 points) DB schema
o (6 points) ER/EER
model/diagrams
o(30 points) Print
screens of DB of MySQL ( show tables, relations, attributes, etc.) Your grade
will depend on the amount of information you will show.
o ( 10 points) List of
queries both as English sentences and in SQL
o (15 points) Print
screens of empty and full interfaces/forms/output windows of your Java GUI (
Pictures of all the different components of your project, both empty and
running when using Java )
o (15 points) Print
screens of empty and full web page forms of your PHP pages (Pictures of all the
different components of your project, both empty and running when using PHP)
o (5 points) Conclusion.
Reflect on your experience completing this project as an individual. The good
and the bad. The time spent. Anything new you learned on your own. Compare
between using Java and PHP as interfaces.
o (15 points) copy
of Java code
o (15 points) copy
of PHP code

Last Completed Projects