Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 25, 2024

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

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students also viewed these Databases questions

Question

2. Bankruptcy and Collective Bargaining. The Bildisco decision is a landmark Supreme Court case dealing with bankruptcy and collective bargaining. Use the Oyez Web site to read the opinion and...

Answered: 1 week ago

Question

★★★★★

During its first year of operations, Collin Raye Corporation had the following transactions pertaining to its common stock . Jan. 10 Issued 80,000 shares for cash at $6 per share. Mar. 1 Issued 5,000...

Answered: 1 week ago

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 -name -desc -price...

Answered: 1 week ago

Question

★★★★★

Case:- Bad monkey Popcorn Recommendation: Clearly identify the target market(s) you recommend the company go after and why. What is the positioning you are recommending? Provide your rationale. o...

Answered: 1 week ago

Question

★★★★★

Serena is a paralegal at a law firm in a small southern town. She studied history in college and completed her paralegal education and certification before moving from a big city to the rural area....

Answered: 1 week ago

Question

★★★★★

Research on laws, programs, best practices of the government, NGOs and communities in response to the challenge of climate change in the Philippines. Make a reflection on how the problems of solid...

Answered: 1 week ago

Question

★★★★★

Thomas Anderson manufactures and sells homemade wine, and he wants to develop a standard cost per litre. The following are required for production of a 150-litre batch: 72.00 litres of grape...

Answered: 1 week ago

Question

★★★★★

A contract in writing was entered into between buyer A and seller B for the sale of 200,000 tons of quartz sand to be delivered in four loads of 50,000 tons per week as required, with each delivery...

Answered: 1 week ago

Question

★★★★★

Part A In the following paragraph, you will read about the study of emerging explorer Prof. Harrison. Conjugate the verbs in parentheses to agree with the subjects. My friends and I ______________...

Answered: 1 week ago

Question

★★★★★

1. Explain how technology has changed the learning environment.

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Previous Question Next Question