In this video, Adam reviews the process taken so far as you've moved through the database development lifecycle. Now it’s time to move into construction, and implement the data model in a DBMS of choice.
- [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.…This led to an initial list of data elements…that the database would need…to store and retrieve efficiently.…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.