Get up to 80 % extra points for free! More info:

Lesson 17 - E-shop in PHP - Designing the person database

In the previous tutorial, E-shop in PHP - Finishing the product administration, we finished the product administration by implementing product images. For the next features, we're going to need database tables for storing persons. In today's tutorial, we're going to design it.


Our e-shop will, obviously, work with people because we need to store addresses to ship to, and we'll need them for bookkeeping as well. However, before we start working on database tables, we'll have to think about its design for a bit.

A person (or entity if you will) can be either legal (a company), or physical (a customer or entrepreneur). To keep tables normalized, we'll store addresses and bank accounts in separate tables. We'll need these as well since a person can have two different addresses (billing and shipping).

We'll also have to consider the fact that a person's details may change from time to time, but the old invoices must remain unchanged. That's why the "person" table will


...End of the preview...
Continue further

You will gain knowledge worth hundreds of thousands for a few crowns

You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.

Buy this course

Buy all currently available lessons with exercise submitting and other features for just $91.44
Current account balance $0
By buying this package, you'll have access to all 46 articles (46 lessons) in this course.

Before buying this article, you have to buy the previous one

This article is licensed: Premium no-reselling, by buying this article, you agree with the terms of use.

Commercial article (licence no-reselling)

Commercial article (licence no-reselling)

This article is based on many years of experience in the IT field, and describes how to develop a professional commercial product or parts, that can be directly used to generate profit or to get as a gate into the industry.

This knowledge is only for the members of our community who are working their way up to become IT professionals. Therefore, this knowledge is only available in exchange for credits. You can use the source code from this article for one commercial project. However, you will not be able to resell it. Simply put, you can't buy our article once and then sell our code multiple times. If you need to use this code a bit more extensively, we are ready to discuss Commercial licence options with you. You can find more info on this in the following article Licence.

Are you ready to become a professional? All you have to do is click here!.

Article description

Requested article covers this content:

In this tutorial, we'll design the database structure that stores people. The main goal is to keep historical data without creating redundant entries.

You gain credits by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.

Article has been written for you by David Capka
The author is a programmer, who likes web technologies and being the lead/chief article writer at He shares his knowledge with the community and is always looking to improve. He believes that anyone can do what they set their mind to.
Unicorn university David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.