From the course: Learning Relational Databases
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Move from planning to construction
From the course: Learning Relational Databases
Move from planning to construction
- [Instructor] If we've done our job well and we're methodical in the application of the database development life cycle, then at this point we should have a fairly good plan for how the database should be put together. Before we dive into the relational database management system, let's quickly review how we got to this point. We started with a well defined mission statement that has guided the overall process and made sure we stayed true to the task that we set out to accomplish. Then we broke the mission statement into smaller, more specific components called mission objectives. These spoke directly to the types of tasks that need to be performed in order to meet the overall project goals. We then identified the actors or the stakeholders in the project and matched them with subject matter experts within the organization and interviews were conducted to find out what they would need in order to accomplish the mission objectives.…
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.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Move from planning to construction3m
-
(Locked)
Solution: Create the tables with CoderPad4m 19s
-
(Locked)
Solution: Establish relationships with CoderPad3m 16s
-
(Locked)
Solution: Write queries in CoderPad4m 6s
-
(Locked)
Create the tables in Access8m 24s
-
(Locked)
Establish relationships in Access4m 41s
-
(Locked)
Write queries in Access3m 59s
-
(Locked)
Create the tables in SQL Server9m 22s
-
(Locked)
Establish relationships in SQL Server5m 48s
-
(Locked)
Create views in SQL Server4m 43s
-
(Locked)
-