
Identify preliminary blog entities such as post and user, with attributes like text, image, date created, and status, while planning secure access, authors, categories, and date-based queries.
Explore practical database design by modeling blog posts and users, assigning content, image, date created, author, category, status, and user details, using approach one to normalize to 3NF.
Build an event log to audit user actions on blog posts, capturing action type, timestamp, user, and post, while normalizing to third normal form with foreign keys.
Design a blog comment system for authenticated users to create, edit, and delete their own comments, with nested comment levels, status, and moderation flags aligned to 3nf.
Databases or relational database systems have always been a subject with a "steep learning curve". Students tend to find it challenging, and learning takes much more effort than other subjects.
To my surprise, I am one of many people who have observed this trend. There is, in fact, a small niche of research papers written on this topic.
So why is it so challenging? When I think of how we might overcome some challenges when learning databases instantly, I think of one fact that remains true, which goes back to even when I started learning database systems. There needed to be more examples or actual database design in practice.
This course aims to help support anyone starting their journey into relational database systems by establishing underpinning skills and concepts of database and database design by working through practical scenario reasoning and providing the rationale to design decisions. Nothing beats experience in most subjects. That is amplified in the realms of relational database development. With the knowledge and experience gained in the course in hand, I hope that on completion of this course, it will provide the scaffolding, underpinning knowledge to support your endeavours in the world of relational database development.