Class 1 | Week 11 | DAT601

Todays class was Todd drawing a conceptual model on the board and discussing with the class over solving the problems it has, this resulted in a more heated than normal environment but the discussion was insightful none the less.

Comments

Post a Comment

Popular posts from this blog

Class 1 | Week 3 | DAT601

Image
Todd has started the lesson with a short explanation on generalized entities which is looks like we will be revisiting at a later date, then he has started to explain to us two different problems that can be encountered in ER models; Fan traps & chasm traps. The general take I am gathering is that linear built databases cant create errors in your database, generally a database would be build in a more circular fashion. Following this he has moved into discussing generalized & specialized entities, by modeling it with a picture on the board. The concept feels similar to the concept of OO programming with abstract classes and classes below that that then inherit the default attributes of the base class as well as adding their own unique requirements. His diagram on the board is demonstrating the way to model this form of "inheritance" in an ER model diagram, the highest level entity is called the "generalization" and the entities below it are called ...
Read more

Class 1 | Week 2 | DAT601

Image
Todd started his lecture off by getting the point across that the ER diagram is supposed to understood by those not savvy to database terminology and symbols. Upon Todd going in depth about entities, the different types of attributes and keys I have not fully come to grip with understanding it all but I can feel the cogs turning in my brain upon his explanation of a variety of  real world examples. Todd glanced over some familiar concepts but some new stuff as well, the stuff that is sticking out to me that I will need to come to understand will be the different types of attributes as well as different types of keys. Along with this there are a couple new words that I have also popped up within my class notes. Cardinality is still a familiar concept from last years classes so this was easy to understand as he spoke about it, still yet to see if Todd will go into more depth on this although I'm not sure if its something that can offer much more depth considering its simplistic...
Read more

Class 2 | Week 11 | DAT601

 Today's lesson theme pertains to referential integrity which Todd has in part assumed we already are familiar with from our previous level 5 DAT course although he has left resources within the course content for those who need a refresher on this content. CASCADE on delete is mentioned as a form of aiding in referential integrity if a primary key is set to cascade on delete it will remove all rows from other tables that also include this key as a primary key. Constraint checks are our next topic and these are used to constrain an attribute so that an entry into its field must be between or of a specific value or set of values. After viewing a very insightful video on constrains checks we have been assigned the rest of the class has been assigned to assignment work.
Read more