From the course: Learning Oracle Database 12c
Join today to access over 25,500 courses taught by industry experts.
Logical database modeling - Oracle Database Tutorial
From the course: Learning Oracle Database 12c
Logical database modeling
- [Instructor] Let's start out this video by analyzing the components in a logical data model diagram. At this level, you're not as concerned about data types, but instead, what elements of your organization are important from a business perspective. Each blue box is one of the entities, remember, this is also called a relation and data modeling terminology, in this case, employees and departments. You'll use certain conventions in your data modeling tool, to assign characteristics to the attributes of each entity. The entity name is in upper case, the attributes are in lower case, and both are almost always singular. You'll also want to mark certain attributes as being unique, or not knowable, to enforce data integrity. Here, the employee number, and department number, are unique identifiers, and the name attribute in both of those entities, can't be empty. No worries, a lot of these requirements are easy to implement, in…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.