Preview Practical SQL Database Design for an Online Survey web application

1. Course Introduction

About this course

2. Database design for a Online Survey website- Getting Started

Course Resources - Notes & SQL Scripts

1.Understand the "functionality" of a web application(Online Survey website) first

2.Next, Gather the "Requirements" based on the functionality

3. Designing the database for the Online Survey website

3.Design the database table for "Survey takers"

4.Design the database table for "Survey questions"

5.Design the database table for "Survey Options"

6.Design the database table for "Website Administrators"

7.Design the database table for "Survey Answers"

4. Validate the Database design

8.Validate the design for table "Survey takers"

9.Validate the design for table "Website Administrators"

10.Validate the design for table "Survey questions"

11.Fix the issue in design for table "Survey questions" - Part 1

11.Fix the issue in design for table "Survey questions" - Part 2

12.Validate the design for table "Survey Options"

13.Fix the issue in design for table "Survey Options"

14.Validate the design for table "Survey Answers"

15.Fix the issue in design for table "Survey Answers" - Part 1

15.Fix the issue in design for table "Survey Answers" - Part 2

15.Fix the issue in design for table "Survey Answers" - Part 3

5. Course completion

Thank You!