Question: Please ,i need a php/sql database that has the following tables. 1)User table -Username -Password -Name -Surname -Address -Email -Tel no 2)Products -prod_code -brand -model

Please ,i need a php/sql database that has the following tables.

1)User table

-Username

-Password

-Name

-Surname

-Address

-Email

-Tel no

2)Products

-prod_code

-brand

-model

-name

-desc

-price

3)Purchases

-user_id

-prod_id

-quantity

-date_time

-purchased(boolean)

-invoice_no(optional)

4)Invoice

-invoice_no

-product

-price

-amount

-vat

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

rumal of Information Technology Teaching Cases 2011 CNC Mac 2016/1 Teaching case From theme park to resort: customer information management at Port Aventura Mariano A Hervs, Joan Rodon, Marc Planell,...

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

What metrics does the company track (or should track)? How do business models and stages of growth drive metrics this company tracks? In your opinion, what is the OMTM for this company? What should...

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

the last image is what I have so far and may help you figure out what libraries and such were used as he did not give us a specific list. The main ones he said in class were matplotlib and tkinter. I...

Hi Sara, Please find my attachments for your information. Thank you Masoumeh P 3-2 P 3-2 The following information was obtained from the accounts of Lukes, Inc., as of December 31, 2012. It is...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Please help me with the questions below, I am using Oracle Data Modeler for this assignment: The objective of the assignment is to develop a database to support an on-line auction site called Nifty...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

Write a Python program that repeatedly asks the user to enter a list of numbers or strings. The items do not need to be all the same type. If the user does not enter a list of a length that is not a...

Rextesla Industrial is a company which wants to raise 4 billion CHF by means of equity issuance. Using the last available financial statements, its free cash flow stands at 1 billion, and without the...

What is the NPV of a 6 - year project that costs $ 1 0 8 , 0 0 0 , has annual revenues of $ 5 3 , 2 0 0 , and annual costs of $ 1 5 , 8 0 0 ? Assume the investment can be depreciated for tax purposes...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. Explain how technology has changed the learning environment.

2. Trainees are geographically dispersed and travel costs related to training are high.

6. Current training methods allow limited time for practice, feedback, and assessment.