Part 2 of tutorial for creating Entity Relationship Diagrams. This is more advanced and addresses Primary Keys, Foreign Keys, and Composite Keys.
Type of Material:
Presentation
Recommended Uses:
It can be used a complementary material in class or self-learning material.
Technical Requirements:
YouTube access
Identify Major Learning Goals:
As mentioned in the YouTube webpage, the video aims to help the viewers to "learn how to create an Entity Relationship Diagram with Primary Keys, Foreign Keys, and Composite Keys in this advanced ERD tutorial" and gives "step-by-step training on how to identify these different keys, as well as helpful information on bridge tables, data types" The specific objectives are:
Creating an Entity Relationship Diagram with Primary Keys, Foreign Keys, and Composite Keys.
Identifying these different types of keys.
Understanding the relationship between an ER Diagram and a database managment system.
Effective use of bridge tables and data types.
Target Student Population:
College Lower Division, College Upper Division, Professional
Prerequisite Knowledge or Skills:
The knowledge of cardinality in database development is needed in understanding, and it is covered in the Part 1 of this video.
Basic introduction to Entity Relationship Diagrams, such as presented in Part 1 of the tutorial that precedes this one.
Content Quality
Rating:
Strengths:
- The concepts about Primary Keys, Foreign Keys, and Composite Keys are presented clearly and it is easy to follow.
- The content on the difference of these keys are complete and appropriate.
- The video is used very nicely in presenting.
In summary, this video is correct, providing valid concepts appropriate to the intended audience.
Potential Effectiveness as a Teaching Tool
Rating:
Strengths:
- Just like the previous video, Part 1, the tone of presentation is enthusiastic so the viewers' interest on the topic is held.
- The idea of the bridge table is also introduced with an illustrative example.
- It is very good that it also describes the SQL statements in creating the tables with PK and FK, which helps the viewers to relate the ERD and the database development.
In summary, the description associated with the video outlines the content well. The presentation is easy to follow and promotes understanding through appropriate ordering and use of concrete examples.
Concerns:
- It seems to be a video for soft-sell on the Lucidchart, but the content and the concept presented is useful and appropriate.
Ease of Use for Both Students and Faculty
Rating:
Strengths:
- The video is very smooth and no mistakes or "step backs" which can be distracting in understanding.
- The layout is professional and the content and the table are shown very visible and of good size.
Creative Commons:
Search by ISBN?
It looks like you have entered an ISBN number. Would you like to search using what you have
entered as an ISBN number?
Searching for Members?
You entered an email address. Would you like to search for members? Click Yes to continue. If no, materials will be displayed first. You can refine your search with the options on the left of the results page.
