Tuesday, February 11, 2020

B5-Relational Database Mynaugh

So here we are, Blog post number 5, and as a part of Group A, we have to explore what Relational Database Theory. Just a forewarning before reading up on the subject, I had no background knowledge of databases(but hey, that's why we're here). So like what many others have said, a database is a collection of information that can be accessed freely and updated over time. Now focussing on Relational databases, it takes the stored information and puts them in categories or tables that then put relations between them according to their attributes. The times I've used something similar was in my construction management classes when coming up with a work breakdown structure. This is fed by collecting data from certain aspects of each task. This includes resources, time, location, and responsibility. So if I were pouring foundations for a gymnasium going by a Relational Database method by connecting the aspects that are needed to complete the task. Firstly I would first identify who is completing (ie, what subtractor) then determine when that work will be done and how long it'll stake. From there on i can see what other tasks are related to this work being completed and how that would affect my scheduling. I guess in other words of saying relational databases in a way are in a way how the information gathered is organized by means on the effect of the data to other information. 
https://dvikan.no/ntnu-studentserver/kompendier/an-introduction-to-relational-database-theory.pdf



Comments

Hey Stephen,

I've found your blog to very inciteful perhaps this is due to my lack of background with databases, not to mention Structured Query Language. Now, as you stated that this a type of coding that companies use to find data rapidly, I can see why companies slike amazon and Facebook value people who are well versed in its use. I can't say if ever I'll be using it, but its good to know that it is relatively easy to pick up.


Hey Reece,

All the points you picked out as to why this is relevant to construction were talking points for my CMGT 467 class that I take Wednesday nights. The most important one that stood out to me is that of Job responsibility. From my estimating job, it was crucial to find subcontractors quickly by having them sorted by their appropriate fields. Having a way to sort through hundreds of subs was greatly mitigated by able to sort for the trade I wanted.

Hey Madeleine,

Reading over your blog helped me connect the dots and spurred my interest in how design firms need to have a well-managed database.
Just thinking of how much time will be saved in seeing how projects of the relatively same scope can be designed if you had success in the past. Also, connecting your blog to construction was a nice tie in on how both design and construction rely the quick access of information to deliver quality content in a timely manner.

2 comments:

Liam Ossenfort said...

Brian, that is what were all here for, to learn! I think you gave a very useful explanation on the manner. I have no prior knowledge to the subject either, but this provided me with information that I can use in the upcoming Project/Assignment. I believe working effectively with databases can be greatly beneficial as I continue advancing in my field of study.

Andre Morris said...

Hey,

I appreciate how you brought the topic into your own experiences and made it something more tangible. RElating this to work we've done definitely helped create a better understanding of the topic.