From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Designing an ecommerce application database

Designing an ecommerce application database

From the course: Advanced SQL for Application Development

Start my 1-month free trial

Designing an ecommerce application database

“

- [Narrator] Let's take a look at Designing an Ecommerce Application Database. Now we're going to be working with a relational database, so the question that we first have to address is what's the design of our database? Well, when we approach a database application, there are a number of questions we need to answer. Specifically, we need to know what data needs to be collected and stored. We need to understand how that data's going to be used. For example, will we be looking up specific records or will we be looking up a number of records of costs, of range, of time, maybe across different types of products, and then doing some kind of aggregate calculation, like averaging a sales price. We also need to know how much data will be stored and how fast it will grow. Now, often times transactional databases, like the kind we're designing here, are used to support an interactive application, for example, with end users making…

Contents