Introduction to Databases for Business Analytics
Week 1 Entity Relationship (ER) Modelling Part 1
Term 2 2022
Lecturer: Kam-Fung (Henry) -mail:
Copyright By PowCoder代写 加微信 powcoder
Week 1 Welcome Video (Online Class Manner)
• 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
Ice Breaker
source: LinkedIn
Things you need to know
Attendance
• Please join your class weekly via Teams few minutes before start.
• For On-Campus classes, please be ready in class to class.
• Attendance will be marked virtually (for online classes), if you exit the classroom or do not participate this will be recorded.
• Please attend the correct virtual workshop.
Online classes Etiquettes.
• Please have a working headset or microphone for verbal communication.
• Mute your Microphone but have your camera ON.
• Do not talk over others, please use the “Raise the Hand” function.
• Please minimize background disruptions e.g., barking dog, music, television etc.
Things you need to know
You must only attend the tutorial that you have enrolled in.
Please be prepared!
• Before class:
• Do the activities before joining classes.
• During class:
• Weeks 1 – 2: ER Modelling
• Apply theory taught in lecture
• Go through examples and exercises
• Complete lab exercises on ER modelling
• Week 3 onwards: SQL
• We will run through activities in class
Clarifying Class Participation and lab requirements
Attendance and Class Participation
• To get full attendance, you must attend your class and fully participate.
• Your tutor would take attendance during lab anytime.
• Business School requires 80% minimum attendance. If you are sick or unable to attend the lab, you can
submit a Special Consideration.
• Special consideration: https://student.unsw.edu.au/special- consideration
PASS Class
PASS Class
Friday 10am – 11am (BUS 216 and online) – starting Week 2
PASS Leader:
Group Assignment
You need to solve the assignment in a group of 4 (or 5 if needed) students.
Assign one member of the team as team leader
Submit a signed group cover sheet and enroll in the correct Moodle group by the end of Week 2
Things to consider when choosing group
❑ Do they have the same outcome expectation as you (e.g., are all team members aiming for a HD or a credit)
❑ Time schedule – is everyone available for a meeting to discuss about the assignment together at a specified time every week?
❑ Location – if there are face-to-face meetings, where is everyone situated?
❑ Time Zone – If you are in a different time zone, please tell your peers.
ER Modelling Exercises
Exercise 1
a. What is the PK in Employee?
b. What is the PK in Department?
c. What is the FK?
d. What is the name of Head of Computer Science?
e. List the names of people who work for J. F. Smith.
f. Draw your first ER diagram!
Exercise 2
a) What is the PK for TUTORIAL_CLASS?
b) What is the PK for LOCATION?
c) Can Mr. Parkin use Video and Computer in
his class?
Exercise 3
Examine the ER diagram in this figure and state which of the following statements is true.
1 A course can be on one program only
2 A program has only one course
3 A student does not have to be on any program 4 A student must be on one program only
5 A program may not have any course at all
6 A program may not have any student in it
Exercise 4
❑ Create an ER model in Chen’s Notation for each of the
following descriptions:
a) Each company operates four departments, and each department belongs to one company.
b) Each department in part (a) employs one or more employees, and each employee works for one department.
c) Each of the employees in part (b) may or may not have one or more dependents, and each dependent belongs to one employee.
d) Each employee in part (c) may or may not have an employment history.
e) Represent all the ER models described in (a), (b), (c), and (d) as a single ER model
Exercise 5
Create an ER model for the following requirements:
❑UNSW Fitness Club
• The club offers a number of exercise classes (described by exercise number, exercise type, exercise level)
for its members i.e. staff and students.
• A member can participate in several exercise classes or none at all.
• Each exercise class has one employee assigned as its instructor.
• Each instructor (described by instructor id, name, address) teaches at least one class and may teach up to 5 classes.
• Each exercise class is taught in a specified room, on a specified date and time.
• Rooms can be used for different classes.
Do not use composite entities for now.
Exercise 6
Create the ER diagram (entities, relationship, and key attributes) appropriate to the following description of a university program structure:
Business Rules:
❑ A program contains many courses.
❑ A course can be part of many programs. ❑Students enrol in many courses.
❑Students may enrol in more than one program.
Do not use composite entities for now.
Next week Activities Please check Moodle
Activities of Week 2 must be completed prior to Wednesday 4.00pm of Week 2
Course Outline –
https://www.business.unsw.edu.au/degrees- courses/course- outlines/archives/COMM1822-2022-T2
If there are any other questions, please post your questions on Moodle.
Source: tryinteract.com
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com