Landing : Athabascau University
Log in to see any non-public content on this page
Athabasca University | AU Student/Staff Login |  Invited Guest Login
 
Menu

Activity

  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam uploaded the file DBDiagram.png May 17, 2012 - 8:45pm
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam replied on the discussion topic Dickson Lam's Data Model Proposal May 15, 2012 - 5:25pm
    Hi all, This is my attempt to articulate the process I took according the course note to normalize the my db into 3NF. I wouldn’t go into detail into all of the entities as to simply illustrate the steps I am only using Suite, Resident and...
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam uploaded the file DBDiagram.png May 15, 2012 - 5:24pm
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam published a blog post COMP 602 - Week 2 - Reflection May 15, 2012 - 2:29pm
    This week’s main task was to come up with a scenario in which a database is needed to capture, organize and maintain data with a minimal of 6 significant entities. I wanted to do something that is relevant not only to my interest but also...
    Comments
    • Jon Dron
      Jon Dron May 15, 2012 - 3:01pm

      I'm glad to hear that PostgreSQL is not too scary - I'm still learning the ropes myself. I think that, on balance, I prefer the management console to those available for Oracle and MySQL and I'm really appreciating the comprehensive help system. 

      I wonder what the attributes would be for Parking, Feature and Price Band? Would this system also handle the rentals themselves? If so, then I guess there's at least one more entity here (rental) and probably at least one entity relating to billing and payments. I think that might make it a bit more interesting!

    • Dickson Wai Hei Lam
      Dickson Wai Hei Lam May 21, 2012 - 7:09pm

      Hi Professor Dron,

      At the moment, I concern only with the inventory management and marketing information aspect of the system. Initially I thought the payment portion should be taken care of by other invoicing system, however, the system is still evolving so I would certainly consider that possibility.
      Thanks for your comment!

      Dickson

  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam replied on the discussion topic Dickson Lam's Data Model Proposal May 14, 2012 - 8:50pm
    Hi class, This is my first cut of the ERD which I think is in 3NF. I will provide additional details tomorrow. Any comment is welcome.   The significant entities are: Resident Management Company Building Suite Feature (Such as Bedroom...
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam replied on the discussion topic Dickson Lam's Data Model Proposal May 10, 2012 - 4:34pm
    Hi Rahim, Thanks for you comment! I think you are right about no. 5 but I still think no.6 is a seperate entity. I am seeing a many to many relationship between suite and feature. ie. One suite can have many bedrooms, a feature (ie. bathroom) can...
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam added a new discussion topic Dickson Lam's Data Model Proposal May 10, 2012 - 3:10pm
    It took me some time to come up with an idea to pursue in this exercise and I wanted to do something that is relevant not only to my interest but also representative in a real life usage. So I settled on this: Apartment Rental Database Here are...
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam published a blog post COMP 602 - Week 1 - Reflection May 6, 2012 - 2:36pm
    This is an introductory week to the comp 602 and so I have been getting my feet wet on the course. I’ve been to other professor Dron’s class before, comp 650 and so I am already familiar with the course format, the landing site, and the social...
  • Dickson Wai Hei Lam
    Dickson Wai Hei Lam bookmarked Week 1 - Task 3 - The DIKW hierarchy May 5, 2012 - 10:33pm
    I recall a conversion I had with a friend regarding the mental capability and age. He told me that our brain deteriorates with age but increase in wisdom. I don’t know if people become wiser as we age but I thought about the conflicting nature of...
    http://wisdomresearch.org/forums/storage/26/220/rowley_jis_042007.pdf
    Comments
    • Jon Dron
      Jon Dron May 14, 2012 - 2:03pm

      Great paper! Covers the issues well. I think the mapping of DIKW to information systems suffers the same flaws that all such models suffer from, inasmuch as the divisions are rather artificial, overlapping and arbitrary, but the paper is suitably cautious about this and provides a useful framework for understanding the richer issues of information system construction that puts people well and truly in the centre of things.

Load More