FIT9003 Database Systems Design

FIT9003 Database Systems Design
By Dr Rob Meredith
About this podcast
Designing systems for managing information.

Podcasts like "FIT9003 Database Systems Design"   · View all

By Fashion Dilettante by Jen Cohn
By Drew Andrews
By Greg Matsey
By Janie Lynn Panagopoulos
Latest episodes
Oct. 24, 2013
This unit has taken a different approach to addressing database systems to a typical course, focusing on the design process as opposed to the technology itself.  This has been quite deliberate: the intent of the unit is to teach IT design using databases as the means to do so, rather than teaching database technology per se.In this final lecture of the semester, we step back and take a look at design and design thinking in a general sense.  The lecture consists of three video presentations (not included in the podcast, but available on Moodle for Monash students or ted.com for others) from three different designers talking about the design process.Oh, and we also talk about the exam!
Oct. 17, 2013
As a designer, conceptual and logical modelling techniques are the tools used to communicate design ideas to a variety of stakeholders.  As discussed in Week 1, a model is a communication tool, and just as there are different approaches to communicating in the written word, there are various modelling approaches available to match your message with your audience.We've focussed on using entity-relationship modelling to specify data structures and their relationships.  In this week's lecture we look at some alternative approaches such as dimensional modelling.  We also look at some non-data modelling approaches including UML and data flow diagrams.The more tools you have available to you, the easier it is to do your job more effectively.
Oct. 10, 2013
In this week's tutorial, we discuss assignment 2, especially how it should be submitted. Then some more SQL excerses to practice joining tables together.
Oct. 10, 2013
This week we conclude looking at the design process by going over the physical design process - looking at how the logical design might be re-configured and optimised to ensure efficient, reliable and secure operation of the database system. We cover transaction path map analysis, as well as denormalisation, partitioning, indexing and several other techniques.
Sept. 26, 2013
This week, more SQL at a (slightly) more advanced level than last week.  We cover aggregated funcions, natural joins and outer joins, and the use of sub-queries.
Sept. 19, 2013
In this week's tutorial we look at the normalisation exercises of the homework quiz. Then we move into exploring the MS SQL Server environment and solve basic queries.
Sept. 19, 2013
Structured Query Language (SQL) is a tool used to interact with database management systems.  It can be used to work with databases and database structures, user accounts and permissions as well as working with the data contained within those structures.  In this lecture we introduce the concept of SQL and go over some basic commands.
Sept. 12, 2013
After covering first, second and third normal forms last week, we continue the topic of normalisation by looking at Boyce-Codd, fourth and fifth normal forms. We also do some worked exercises to third normal form at the beginning and end of the lecture to practice recognising repeating groups.
Sept. 12, 2013
In this week's tutorial we continue practicing the normal forms: first, second, and third. We cover the first two excercises of the tutorial and students have the chance to get started with the homwork quiz on normalisation due next week.
Sept. 5, 2013
Worked normalisation exercises, normalising to third normal form (3NF)