Data modeling and Relational database design
Data modeling and Relational database design
Modern database and applications development software is so easy to use that many people can quickly learn to implement a simple database and develop simple applications within a week or so, without giving design much thought. As data volume grows and when users request addition functionality, they might incorrectly add columns in table since appropriate database design is not available. This not only causes data redundancy in database but also can cause performance issue to application and database as well. Ultimately, due to poor database design, the business would be the loser.
A good database design not only avoids data redundancy but also improves database performance over period of time as the database volume grows and when business changes are requested , it would be far more easier to understand as where to make the appropriate changes in the Database. The data modelling and database design is like a building blue print and ultimately it would make application users happy and business would benefit.
This course uses the Oracle SQL Data modeler extensively to discuss and demonstrate Database modelling and Database design.
Oracle SQL Data modeler is a tool, which make learning Data modelling and Database design much easier and also provides you with a professional approach design database for business application effectively to plan, develop, implement and maintain them on an ongoing process.
In this course you would learn:
Process Modelling
Develop a Data Flow Diagram by identifying processes, external agents, information stores and information flows that show how the information flows Business flow Diagram
Logical Model
Create an Entity Relationship Diagram by identifying entities, attributes, relationships.
Normalize the Entity Relationship Diagram to third Normal form
Relational Model
Validate Logical and Relational Model through Design rules
Engineer the Entity Relationship Model into an relational database design
Complete the Physical Model and generate the DDL scripts
Finally, at the end of the course, you would understand the importance of data modelling and database design.
Happy Learning!!
Use Oracle SQL Data modeler for Data modeling and Database design. Professional approach to design and maintain Database
Url: View Details
What you will learn
- Process Models - Understand and develop business process models( data flow diagrams) through Oracle SQL modeler.
- Logical Models - Easily understand and create Entity relationship Diagram through Oracle SQL Modeler
- Relationship - One to Many, Many to Many, Recursive relationship
Rating: 3.3
Level: Beginner Level
Duration: 3 hours
Instructor: Guha Rajan M., B.Engg, MBA, PMP
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap