I would like you to create a SQL Oracle Script based on the following description
The restaurant “Coffee123” in their growth processes have as a project creating a web application that can be used by mobile devices for customer registration, creation of purchase orders, payment control and online surveys to know your opinion of their customers.
The idea is to develop a system that has an option to record the general customer data such as the number DUI(Document Unique ID) , names , surnames, direction , telephone and email .
In addition, it is required that the system allows you to make an order based on the list of products they offer. The products they offered range from breakfast, lunch and dinner.
For each plate offered there is a picture showing the product to customers with the price and a short description. The system user may choose to buy one or more products based on the list of products offered.
You need to keep track of orders and payments made by customers through credit cards. A posteriori the system may link to online payment systems.
Finally, the system should have the option to conduct customer surveys each month. This will be in order to determine the quality of the service offered.
As you can see, if you have the Oracle SQL skills, it will take just perhaps one hour to make the creation of the CREATE statements and the logic for a couple of tables.
Please tell me if you have any questions,
Happy to help you out.
Oracle Expert here interested in your project.
I work on Oracle 11g and would be able to provide you the scripts within few hours.
Please communicate to discuss the deliverable
Thanks