Introduction to Databases for Business Analytics
Data Manipulation Language Big Data
Lecturer-in-Charge: Kam-Fung (Henry) 2 2022
Email: Tutors:
Copyright By PowCoder代写 加微信 powcoder
PASS Leader:
Week 8 Welcome Video
• 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
❑ Housekeeping
❑ Discussion of Data Manipulation Language ❑ Week 8 Sandbox Activity
❑ Big Data
Academic Integrity
▪ Information on the dangers of contract cheating can be found here:
Contract cheating | Equity Diversity & Inclusion – UNSW Sydney
▪ Apart from internal services to support students, the only external service officially sanctioned by UNSW is Smarthinking.
▪ In addition to advising you and students of the dangers posed by contract cheating companies, UNSW legal will be taking necessary steps, and UNSW will also assess whether a referral to TEQSA is appropriate.
▪ If you would like any advice or assistance with these conversations, please contact the Conduct and Integrity Office,
COMM1822 Consultation
Consultation with the LiC
Kam-Fung (Henry)
10.00 – 11.00 am (AEST)
Send an email to book a time:
COMM1822 PASS Class
PASS Class
10:00 – 11:00 am (AEST)
Online via
https://au.bbcollab.com/guest/734c9 39b0ddf42d2868fc2304b801d82
Assignment Help
❑ Contact your tutor today if there exist unequal contribution issues within a group.
❑ Groups: Check the Marking Rubric on Moodle.
Assignment – Database Implementation
❑Populate the database with at least ten sample records in each table
❑Ensure your sample data can return the queries as specified in the assignment
❑Do not change your group SQL account login password
❑Disregard the existing DB in the Group account.
❑If more than one person works on a table and makes changes, this might create errors in the DB and the account. Please collaborate within the group who will be what and when!
❑ Housekeeping
❑ Discussion of Data Manipulation Language ❑ Week 8 Sandbox Activity
❑ Big Data
Week 8 Lab Manual Discussion
❑ What is Data Manipulation Language, and what is Data Definition Language (DDL)?
❑ When would we use DML versus DDL? Consider some examples.
❑ What are some examples of DML statements, and what do they do?
❑ Housekeeping
❑ Discussion of Data Manipulation Language ❑ Week 8 Sandbox Activity
❑ Big Data
Week 8 Sandbox Activity
1. The restaurant’s drinks supplier has recently increased the cost price of Peach and to $15 and $17 respectively. Modify the database to reflect these price changes.
2. A new chef has recently been hired by the restaurant. Add a new row in the CHEF table with the following data: Staff_id = C0007, Name = , Gender = M, Salary = 40000, and Phone_number = 425333649.
3. Minimum rates for chefs have increased. Update the salaries for all Chefs to be a minimum (i.e. do not update downward) of $62,000.
4. Create a new table of chef assistants with:
• A variable string staff_id (the Primary Key)
• A number containing hourly_rate
• A foreign key chef_id referencing the Chef they assist.
• A hire_date field that automatically populates with the current date when a new entry is inserted.
5. Undoallyourchangesyouhavemadetothedatabase.
Week 8 Sandbox Activity
1. The restaurant’s drinks supplier has recently increased the cost price of Peach and to $15 and $17 respectively. Modify the database to reflect these price changes
Week 8 Sandbox Activity
2. A new chef has recently been hired by the restaurant. Add a new row in the CHEF table with the following data: Staff_id = C0007, Name = , Gender = M, Salary = 40000, and Phone_number = 425333649.
Week 8 Sandbox Activity
3. Minimum rates for chefs have increased. Update the salaries for all Chefs to be a minimum (i.e. do not update downward) of $62,000.
Week 8 Sandbox Activity
4. Create a new table of chef assistants with:
• A variable string staff_id (the Primary Key)
• A number containing hourly_rate
• A foreign key chef_id referencing the Chef they assist.
• A hire_date field that automatically populates with the current date when a new entry is inserted.
Week 8 Sandbox Activity
5. Undo all your changes you have made to the database.
Online Safety – Break
▪ Rest Breaks: https://safety.unsw.edu.au/office-safety-toolkit/rest-breaks
▪ WorkRave at UNSW: https://safety.unsw.edu.au/sites/default/files/documents/UNSW_WorkRave_ V1.0.pdf
▪ Setting up you Workstation : https://safety.unsw.edu.au/setting-your- workstation-video
▪ Online Safety and Wellbeing Tutorial: https://student.unsw.edu.au/safety
▪ SafeWork 6 Simple stretches: https://www.safework.nsw.gov.au/resource- library/six-simple-stretches
Take a 5 minutes break
❑ Housekeeping
❑ Discussion of Data Manipulation Language ❑ Week 8 Sandbox Activity
❑ Big Data
1. What do you know about “Big Data”?
2. Give some examples on Big Data?
3. What are the 3Vs of Big Data?
4. How can data analytics help businesses execute their strategy more efficiently? And increase return on investment (ROI)?
5. Research a company of your choice (could be social media) and propose a Big Data strategy? How they will use it, and how it will help their business (considering the 3Vs). (30 min in breakout rooms / groups)
6. Present your work in groups (2 min per group)
Source: https://blog.hootsuite.com/simon-kemp-social-media/
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com