From the course: Database Design Fundamentals
Join today to access over 24,700 courses taught by industry experts.
Final project walkthrough: Design your own database
From the course: Database Design Fundamentals
Final project walkthrough: Design your own database
(soft upbeat music) - [Instructor] I hope you enjoyed working through the final project and designing your own database. Now, let's go through how I would approach this. The first steps are to review the product and salesperson. The salesperson only briefly noted in this form is a tricky concept. This is the one where the discovery process with a user and subject matter expert is very important. There is only a single field on the form, and it appears to be only a name field or maybe even a salesperson number field. It's up to the architecture designer to extrapolate that additional information that will be required and add in a few fields like name, email, phone number, and address that relate to the salesperson. The product characteristics are a bit easier to determine as they are listed on the order form in the details. Things such as size, price, quantity, variety, and status. Using the rules of the first normal form for the salesperson, we eliminate the repeating groups and…
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.
