From the course: Advanced SQL Project: Design and Manage a Database
Join today to access over 25,600 courses taught by industry experts.
Identifying requirements and purpose - SQL Tutorial
From the course: Advanced SQL Project: Design and Manage a Database
Identifying requirements and purpose
- [Instructor] Now that you've set up the foundation of your music database, let's dive into identifying some specific requirements needed to make it functional and effective. So requirements are gathered from stakeholders. To build a useful database, we need to understand what stakeholders, and that is the iMedia team, expect and require from the database. Now, this takes place in the form of interviews and questionnaires. Interviews are conducted with key stakeholders to gather their needs and expectations. Questionnaires are also used to make sure that all of the important aspects are covered. So questions such as what data needs to be stored or how will users interact with the database, or what reports or queries will be needed. These are all very important in shaping the requirements that we are creating for our database. Equally as important is determining the scope of your database. Here is where you define the boundaries of what your database will cover. Now, specifically for…
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.