Logical Design
11 Videos | 1h 23m 9s - 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 advantages
define entities in the logical data model for designing a database
identify the different categories of attributes that are used in a logical data model
define the data types for attributes in a logical data model
define DEFAULT and CHECK constraints and nullibility for attributes in a logical data model
describe the different keys used in a logical data model -
describe referential integrity and foreign key constraints for a logical data model
define relationships in a logical data model for designing a database
define advanced relationships in a logical data model
model entity supertypes and subtypes in a logical data model
resolve 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.
