Six-Step Relational Database Design
What you'll learn
- Create Entity Relationship Model diagrams
- Create Crow's Foot Relational Model diagrams
- Knowledge of basic information systems terms and terminology
Database design is the most important task performed by application developers because the resulting database and all applications that access it are based on this design. Therefore, if the data for the application is modeled incorrectly and the resulting database poorly designed, poor and difficult to use applications will result.
Learn how to design databases in six easy steps
- Create implementable database models
- Create Crow's Foot Relational Model (R-M) diagrams
- Create Entity Relationship Model (E-R) diagrams
- Case studies to reinforce the instructions
- Easy to follow, step by step instructions
Learn how to create sturdy, reliable and accurate data models for your databases
A database is the backbone of any application, and therefore it must be sturdy, reliable, and accurate. Having a well-designed database is the key to having your database meet these criteria, and the six-step technique taught by this course ensures that the data model upon which your database is built is sturdy, reliable, and accurate.
The six steps outlined in this course are simple, easy to follow, and precise. It teaches you how to quickly and accurately model the data that your application will use, and shows you how to do so in the shortest possible time. Extensive knowledge of database theory is not required and the theory is kept to a minimum.
Video lectures are used to present the material, and case studies are incorporated into the lectures thus reinforcing the steps of the database design technique taught by this course. There is also a lot of supplemental material that you can download and read, which explains each of the steps in further detail.
Who this course is for:
- This course is meant for IT/Computer Science individuals who, as part of their portfolio, have to develop and implement relational databases.
- This is a database design course and is for persons who need to learn how to design databases and document them using Crow's Foot Relational Model diagrams. It does not teach you how to implement the derived design.
Fidel A. Captain has over fifteen years of experience designing, implementing, and maintaining databases, and over ten years of experience as a lecturer.
He has worked as a systems analyst and systems engineer with the Ministry of Finance in Guyana, as a computer studies lecturer at the H. Lavity Stoutt Community College in the British Virgin Islands, and as a freelance consultant.
Captain has developed several database-based applications that include an online bill- payment system, a logistics and cargo-tracking system, a student-tracking and evaluation system, and a freight and duty calculation system.
He currently lectures at the H. Lavity Stoutt Community College in the British Virgin Islands in areas such as database design and development, website design and development, and Java programming.
Captain is a Queen’s College Guyana Scholar, who received his Bachelor’s of Engineering degree from the University of Manchester Institute of Science and Technology (UMIST) in Computer Systems Engineering and his Master’s in Information Technology from Capella University. He is also a certified MySQL developer and administrator.