Introduction to Databases for Business Analytics
Week 1 Introduction
Term 2 2022
Lecturer: Kam-Fung (Henry) -mail:
Copyright By PowCoder代写 加微信 powcoder
• There are some file-sharing websites that specialise in buying and selling academic work to and from university students.
• If you upload your original work to these websites, and if another student downloads
and presents it as their own either wholly or partially, you might be found guilty of collusion — even years after graduation.
• These file-sharing websites may also accept purchase of course materials, such as copies of lecture slides and tutorial handouts. By law, the copyright on course materials, developed by UNSW staff in the course of their employment, belongs to UNSW. It constitutes copyright infringement, if not academic misconduct, to trade these materials.
Acknowledgement of Country
UNSW Business School acknowledges the Bidjigal (Kensington campus) and Gadigal (City campus) the traditional custodians of the lands where each campus is located.
We acknowledge all Aboriginal and Islander Elders, past and present and their communities who have shared and practiced their teachings over thousands of years including business practices.
We recognise Aboriginal and Islander people’s ongoing leadership and contributions, including to business, education and industry.
UNSW Business School. (2022, May 7). Acknowledgement of Country [online video]. Retrieved from https://vimeo.com/369229957/d995d8087f
COMM1822 Lecture and Tutorial
ER Rel. Normal. SQL SQL Model Model DDL DML
Plan: W1 Learnings
• Data vs. information
• Data stored in databases
• Database management system (DBMS)
• Database design defines database structure
• The next big thing: big data
Chapter 1 Database Systems 1-1 to 1-7
Data vs Information
Have not yet been processed to reveal their meaning to the end user
Building blocks of information
Information
• Produced by processing raw data to reveal its meaning
• Requires context
• Bedrock of knowledge
• Should be accurate, relevant, and timely to enable good decision making
e.g., WAM (Weighted Average Mark) -> How you did at UNSW
e.g., marks for your quiz, assignment, …, in a course
Introducing Database
A shared, integrated computer structure that stores a collection of:
End-user data – Raw facts of interest to end user
Metadata: “Data about data”, which the end-user data are integrated and managed
❑ Describe data characteristics and relationships Database management system (DBMS)
Interested in
e.g., a set of dates → Start of a project, Evaluation of the progress, End of the project, …
▪ Collection of programs
▪ Manages the database structure
▪ Controls access to data stored in the database
Like a steward
Metadata (Data Dictionary) Example
Alphanumeric
CourseID and Name
Class Number
Alphanumeric
Semester and Year
Alphanumeric
Student Name
Student ID
Alice Tomson (zID: 1234567) takes COMM1822 Introduction to Databases for Business Analytics (Class: 1) in Term 2 2022.
Data in Context: Google
Data in Context: Apple
Basic Terminology
• Character: Most basic element of data.
• Field: Contains data (composed of characters).
• Record: Set of related fields.
• Database: Collects related records.
• DBMS: Manages the database.
Source: psu.edu
History of Handling Data
not efficient
• Manual filing systems.
• Computerised filing systems via data files.
• Database systems.
more efficiently
Source: bizfluent.com
Advantages of Database Systems
• Reduced data inconsistency and anomalies.
• Reduced data redundancy and improved data sharing.
• Increased application development productivity.
• Reduced data structural dependency problems.
• Easier to create, access, modify and delete data.
• Standardized backup and recovery.
• Concurrency handling.
e.g. data storage
• Enforcement of standards.
e.g., Marketing & Business Analytics Departments using the same dataset • Central security. e.g. who can access what data – someone can write/modify data; someone can only read data
Recap: W1 Learnings
• Data vs. information
• Data stored in databases
• Database management system (DBMS)
• Database design defines database structure
• The next big thing: big data
Source: tryinteract.com
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com