SPE10117 Foundations in Information Systems


Part 1 HUB Case Study

  1. What is meant by the followings
    • Private Banking
    • personalized customer service
    • AS/400
    • API
  2. What are the Key Business objectives that the newly expanded International Banking unit could have formulated in addressing its core business via business information technology i.e. Kisco Inforamtion System , explaining how each addresses the business needs.
  3. List and describe the feature, content or service that you think would be required.

When finished, each group submits a one page report with member list and Part 1 answers to Canvas under Assignments - Lab 7 HUB Case Study.

Part 2 Review Exercises
  1. What is the difference between data, information, and knowledge?
  2. What is the difference between a spreadsheet and a database? List three differences between them.
  3. What are the characteristics of a relational database?
  4. Why is it important to define the data type of a field when designing a relational database?
  5. What is metadata and open data ?
  6. Review the design of the School database in Data and Databases Chapter. Reviewing the lists of data types given, what data types would you assign to each of the fields in each of the tables. What lengths would you assign to the text fields?
  7. Select one dataset that interests you from DATA.GOV.HK. Discuss how the dataset could be used.
  8. Conduct some independent research on the latest technologies being used for knowledge management. Using at least two scholarly or practitioner sources, write a two-page paper giving examples of software applications or new technologies being used in this field.