From the course: Advanced SQL for Application Development
Join today to access over 25,300 courses taught by industry experts.
Designing an ecommerce application database
From the course: Advanced SQL for Application Development
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.