Business Process driven Database Design: with Oracle PL/SQL

Business Process driven Database Design with Oracle PL/SQL outlines a fresh approach to database design that is rooted in the concept of business process. Such a database design approach ensures a more robust and integrated database structure that is more closely aligned with business goals and objectives. It also integrates business logic with database design thereby enabling better support for business applications. This book is for anyone (beginner, student, or professional) who desires to understand database design in a way that is more business oriented. It can also be used as a text book in a level 1 database design course. The book covers essential concepts of business process modeling with business rules, conceptual modeling with ER diagrams, relational model with SQL, and Oracle PL/SQL language to ensure proper implementation of business logic. The topics are explained in a simplified way through tutorials and numerous examples for a reader to quickly grasp the material. It is written in a hands-on style for anyone to learn the basics of database design. The book also provides the SQL and PL/SQL source for anyone to install the book database and practice examples to gain understanding of various concepts. Upon completion readers will have learnt the art of database design and have the skills to express it through SQL and PL/SQL.