Landing : Athabascau University

Activity

  • Liliana Tang uploaded the file Project Portfolio December 9, 2018 - 2:47pm
  • Liliana Tang commented on a wiki page titled Week 12 - Project Week 4 December 9, 2018 - 9:10am
    Hey Sarah! Thanks for all the kind words! You don't know how much they mean to me! Yes learning is a journey, not a destination. I often remind myself that if there is no pain, there will be no gain. I've sent a request to connect on Linkedin along...
  • Liliana Tang created a wiki page Week 12 - Project Week 4 December 8, 2018 - 11:41pm
    This week I have the privilege to present and listen to amazing presentations from my classmates. They are all very knowledgable and passionate in whatever they are doing. I have learned quite a bit about cloud computing, queries optimization,...
    Comments
    • Sarah Camsell

      Hey Liliana! Great to meet you, and I'm sure we'll see each other again! I too, work a full-time job, and I do part-time website development and online conference registration in addition to my government job. During this course, at the end of October, I left my old job, started a new job, moved across the country and had a conference to do :D  It was awful and I'm sure my course work suffered. When I moved to my new place, in the Arctic, I couldn't even get internet hooked up at my house until the ice road was in, so I missed a lot of time.

      I know how you feel! We do it because we love it, I guess. Learning will never end, and I love Athabasca, and the freedom it gives.

      Sarah Camsell December 9, 2018 - 1:50am

    • Hey Sarah! Thanks for all the kind words! You don't know how much they mean to me! Yes learning is a journey, not a destination. I often remind myself that if there is no pain, there will be no gain. I've sent a request to connect on Linkedin along your way! I hope to stay in touch with like-minded people like you! Good luck with the rest of your Masters journey at Athabasca!

      Liliana Tang December 9, 2018 - 9:10am

  • Liliana Tang created a wiki page Week 11 - Project Week 2 November 29, 2018 - 12:57pm
    This week has been very busy and overwhelming sometimes as I really want to end my first term of Masters degree with good grades; plus we have a performance review at work tomorrow so instant noodles have been my best friends so far, but I am quite...
    Comments
    • I feel your pain on how busy you ave been! Between work, my kids activities and trying to balance the remainder of this course with the other course that I am doing (which includes an exam this week) it's been a little overwhelming. But we are finally in the home stretch!

      Shallen Dam December 3, 2018 - 6:05pm

  • Liliana Tang commented on a wiki page titled Week 10 - Project Week 1 November 29, 2018 - 12:23pm
    Hi Shallen,  Thanks for your reply. It is always a great feeling to hear that I could help sombody one way or another. Yes, I was very surprised too as I have been using SQL as main programming lanaguages for all data mining prospects at work,...
  • Liliana Tang created a wiki page Week 10 - Project Week 1 November 23, 2018 - 12:36pm
    This week was a busy week. Although most of the time was spent on compiling the foundations portfolio, I managed to spare sometime learning data mining technqiues and tools by reading a book called Introduction to Data Mining by Tan, Steinbach, and...
    Comments
    • That's really interesting that SQL is not the top laguage for data mining, I never would have thought. I am taking the individual data mining course starting January 1, now that you have posted this I think I will start looking to R and Python to maybe use that course as an opportunity to learn a couple of new languages, so thank you for posting this!

      Shallen Dam November 25, 2018 - 9:00am

    • Hi Shallen, 

      Thanks for your reply. It is always a great feeling to hear that I could help sombody one way or another. Yes, I was very surprised too as I have been using SQL as main programming lanaguages for all data mining prospects at work, but it's time for me to learn something new. R has challenged me much so far! I will take Data Mining class in Winmter 2019 too, so see you again soon :)

      Liliana Tang November 29, 2018 - 12:23pm

  • Liliana Tang created a wiki page Week 7 - Fault Prevention Techniques November 18, 2018 - 12:43pm
    Identify recovery strategies for Input error discovered after some weeks Multiple means to deal with problems with inserting and updating records in PostgreSQL PostgreSQL provides rule qualification which decide where and when UPDATE and...
  • Liliana Tang uploaded the file FInal ER diagram November 16, 2018 - 12:39am
  • Liliana Tang uploaded the file Phase II NF2 ER Diagram November 15, 2018 - 9:35pm
  • Liliana Tang created a wiki page Week 6 - Performance (to be continued) October 25, 2018 - 12:49pm
    Partitioning: I think partitioning is important in any big database system, especially a POS System with many heavily accessed records like popular grocery items and a few items only used for special occasions, according to PostgreSQL user manual,...
  • Liliana Tang uploaded the file Week 6 - Indexing.pdf October 24, 2018 - 11:37pm
  • Liliana Tang created a wiki page Week 5 - SQL October 16, 2018 - 12:34am
    Files submitted: https://landing.athabascau.ca/file/view/3607595/week-5-sql-evidence Reflections: I would consider this week as the most challenging time ever since I started my MSc at Athabasca. Although I was quite confident in my ability...
  • Liliana Tang uploaded the file Week 5 - SQL Evidence - Final October 16, 2018 - 12:02am
  • Liliana Tang created a wiki page Reflections - Week 4 October 8, 2018 - 4:32pm
    This week I have had a chance to fix my ER diagram from last week. There are a few interesting points I have explored that weretotally worth my time and effort in terms of researching and thinking over the week. 1) There is really no many-to-many...
  • Liliana Tang uploaded the file Normalization_analysis.xlsx October 8, 2018 - 3:58pm
  • Liliana Tang uploaded the file Normalized_ERDiagram.png October 8, 2018 - 3:56pm
    Comments
    • This is looking good, Liliana. I wonder, though, whether there is another entity lurking in the relationship between an employee and a cash register? Seems to me that a cash register will be used by many employees, and an employee may use many cash registers, which implies to me that there must be an associative entity between them. I've never worked as a sales clerk in a supermarket so am not sure of the terminology but I've noticed the ones doing so talking about 'shifts' on the till: might be a possible entity? Don't forget to draw relationships explicitly, wherever there's a foreign key: there's one between receipt and customer_more_reward, for instance (the foreign key implies that the many end is at the receipt, I think). My own experience of the More Rewards program suggests that the phone number is very important to the system and *might* be a significant index. It also suggests that redemption matters (not in the religious sense!) - quite a lot of products are offered at a reduced price or even free with More Rewards, and that makes a difference on the receipt (and to the customer's reward points - might there be a need to record these?). Beware, too, of complexities around those offers. Some of them are affected by the number of items purchased. This may imply further entities - perhaps including a 'discount' entity that affects a receipt? It would not be a bad idea to look at a real receipt to make sure that you've picked up on all the possible attributes, including those that are implied. Another useful intuition pump might be to think about whether and how the model changes for online customers getting their groceries delivered.

      Jon Dron November 13, 2018 - 7:31pm

  • Liliana Tang commented on the file Liliana Tang - POS System's ER Diagram September 30, 2018 - 7:48am
    Hi Timothy, Thanks for your comments. I will have a look about the "many-to-many" relationships, and see which entities I can come up with to make them become "one-to"many".  
Load More