Logical Design
Beginner
- 11 Videos | 1h 17m 39s
- Includes Assessment
- Earns a Badge
The logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. Explore the entities, attributes, and relationships that exist in the logical model.
WHAT YOU WILL LEARN
-
describe the logical data model and its advantagesdefine entities in the logical data model for designing a databaseidentify the different categories of attributes that are used in a logical data modeldefine the data types for attributes in a logical data modeldefine DEFAULT and CHECK constraints and nullibility for attributes in a logical data modeldescribe the different keys used in a logical data model
-
describe referential integrity and foreign key constraints for a logical data modeldefine relationships in a logical data model for designing a databasedefine advanced relationships in a logical data modelmodel entity supertypes and subtypes in a logical data modelresolve many-to-many relationships when building a logical data model
IN THIS COURSE
-
1.Overview of the Logical Database Design3m 49sUP NEXT
-
2.Defining Entities7m 5s
-
3.Defining Attributes8m 17s
-
4.Defining the Data Type7m 8s
-
5.Defining Constraints and Nullibility7m 27s
-
6.Defining Keys for Tables9m 3s
-
7.Defining Referential Integrity6m 21s
-
8.Defining Relationships6m 28s
-
9.Advanced Relationship Modeling7m 51s
-
10.Modeling Entity Supertypes and Subtypes9m 3s
-
11.Resolving Many-to-many Relationships5m 9s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.