INFS1603 Introduction to Business Databases - 2018

Subject Code
INFS1603
Study Level
Undergraduate
Commencing Term
Semester 1
Total Units of Credit (UOC)
6
Delivery Mode
On Campus
School
Info Systems & Tech Mgmt

1. Course Details

Summary of Course

This is a foundational (Level 1) Information Systems (IS) course that introduces students to the concepts, techniques, and technologies relevant for creating and managing business databases. It will explain the major components of IS, which are critical to capturing, transmitting, storing, retrieving, manipulating and displaying information used in business processes. Through this course, students will be exposed to the fundamental knowledge of business databases, which are foundational for many advanced courses. Students will be given tasks and assignments to help them acquire the ability to create and manage business databases.

In particular, topics include introduction to techniques and technologies for the storage and management of data, fundamentals of relational modelling and SQL, object-oriented modelling, the database development lifecycle and the role of the Database Administrator (DBA). The course includes a substantial laboratory component using an industrial-strength Database Management System (DBMS).

Teaching Times and Locations

Please note that teaching times and locations are subject to change. Students are strongly advised to refer to the Class Timetable website for the most up-to-date teaching times and locations.

View course timetable

Course Policies & Support

Course Aims and Relationship to Other Courses

The course aims to give students the background of, and a process for, database development. Furthermore, the course aims to develop students’ conceptual and logical database design skills. Finally, the course aims to develop students’ skills in using and managing databases. Students will practice self-directed work in groups that will help them develop their interpersonal communication, project management and quality assurance skills.

The course does not have any prerequisite courses.

2. Staff Contact Details

Position Title Name Email Location Phone Consultation Times
Lecturer in Charge (LIC)DrDaniel SchlagweinQ2114, Quadrangle building – Ref E15+61 2 9385 6487Wed 3 pm, by appointment.
Lead Tutor    Rena Zhou
Tutor    Erica Soon
Tutor    Karen Huang
Tutor    Gavin Chiem
Tutor    Jeremy Fu
PASS Leader    Sao Kham Mo Kyaw TunSquare House 208 | QUAD G040
11:00am - 12:00pm Monday (Square House 208); 1:00pm - 2:00pm Friday (QUAD G040)

​If you need to contact the school urgently, ring 9385-5320 or email istm@unsw.edu.au. For messages to the LIC or the school, please use your UNSW email address (do not use external email addresses, Moodle messaging or emails). Start email subjects with the course code, INFS1603, and sign the email with your full name and student number. Emails not meeting these conditions may not be answered.

3. Learning and Teaching Activities

Approach to Learning and Teaching in the Course

​The lecture and the lab provide students with a chance to learn fundamental database knowledge and skills. There will be several course activities to foster critical thinking, develop problem-solving skills and prepare students to work effectively with databases. We provide practical assistance through hands-on exercises in the labs. However, students need to take the initiative to self-learn the practical components throughout the course. Lectures, labs, and the textbook can only provide the context, structure and resources for their learning. Students' practical engagements with the material in self-study or peer groups are the crucial elements of their learning. The major assignment is a project concerning the design and development of a business database, which students will solve in a group. In this course, students will learn to use Chen’s Entity Relationship (ER) notation and the Oracle SQL query language.

Learning Activities and Teaching Strategies

At university, the focus is on self-study and self-directed search for knowledge. Lectures, labs, textbooks, exams and other resources are provided to structure students’ self-learning. Students are expected to attend all lectures, complete all lab exercises, and read all required readings so to fully grasp and appreciate the concepts of business databases.

Self-Study

Students need to take the initiative to self-learn the relevant contents throughout the course. Learning is not achieved through attending formal lectures and labs but is nearly exclusively achieved through self-initiated learning. Formal lectures, labs, and the textbook can only provide the context, structure, and resources for this learning. The practical engagements with the material in self-study or in group work and informal communications with peers are the crucial elements of the learning. Students need to revise lectures; complete assignments and study for exams. Students are responsible for their learning style and goals and to make a concerted and timely effort to study for this course.

Lecture

Each lecture will provide an overview of the topic at hand and will focus on explaining topics, concepts, and issues. The role of the lecture is to help students understand the context of the topic as well as walk them through difficult points. There will continuous opportunities to ask questions and actively participate in the lectures. In this course, the lecture focuses on conceptual knowledge regarding the creation of relational databases. The lecture notes also include exercises that students can solve in class or at home.

Lab

The labs provide practical assistance through hands-on work on databases. The labs focus on using and managing database us an industry standard DBMS such as Oracle (or equivalent). There will be hand-out material supporting the lab. The database design assignment of this course is closely linked to the lab and includes an oral presentation in the lab. The lab tutors are responsible for all lab sessions and technical questions regarding the database design project. Students should always refer to their lab tutor first with problems regarding the lab or the database design project. For this course and assignment, students need to use Chen’s Entity Relationship (ER) notation and the Oracle SQL query language.

5. Course Resources

  • Coronel, Morris, Rob (2017) Database Systems [12e]. Cengage Learning, Independence, KY, USA. (ISBN-13: 9781305627482) (for the lectures)
  • Casteel – Oracle 12c SQL [or Oracle 11g SQL]. Cengage Learning, Independence, KY, USA. (ISBN-13: 978-1305268029) (for the labs)
Both books are relevant for the course. Coronel et al. supports the lecture; Casteel supports the lab. The latest edition is recommended. However, students typically find older editions of the books sufficient for the course. Additional course materials may be provided in class and on the course website on UNSW Moodle.

6. Course Evaluation & Development

Each year feedback is sought from students and other stakeholders about the courses offered in the School and continual improvements are made based on this feedback. UNSW's myExperience survey is one of the ways in which student evaluative feedback is gathered. In this course, we will seek your feedback myExperience responses and through direct feedback from students to the LIC in class.

7. Course Schedule

Week 1: 26 Feb
Topic

Introduction

NO LABS

Assessment/Other

Course admin; Ass. A + B released

Week 2: 05 Mar
Topic

ER Modelling 1

Lab: Basic SQL Statements

Assessment/Other

Group setup

Week 3: 12 Mar
Topic

ER Modelling 2

Lab: Restricting Rows and Sorting Data

Assessment/Other

Additional advice ass. A

Week 4: 19 Mar
Topic

Relational Modelling

Lab: Selected Single-Row Function

Assessment/Other

Week 5: 26 Mar
Topic

Normalization 1

Lab: Joining Data from Multiple Tables

Assessment/Other

Ass. A due

Mid Semester Break: 02 Apr
Topic

MID SEMESTER BREAK

Week 6: 09 Apr
Topic

Normalization 2

Lab: Group Functions

Assessment/Other

Peer review ass. A due

Additional advice ass. B

Week 7: 16 Apr
Topic

Quiz A (ER Modelling and Normalization)

Lab: Table Creation and Management, Constraints

Assessment/Other

Quiz A (ER Modelling and Normalization) in Lecture

Week 8: 23 Apr
Topic

SQL

Lab: Data Manipulation and Transaction Control

Assessment/Other

Week 9: 30 Apr
Topic

OO Modelling 1

Lab: Sub Queries and Merge Statements

Assessment/Other

Week 10: 07 May
Topic

OO Modelling 2

Lab: Views

Assessment/Other

Week 11: 14 May
Topic

Database Development in Context

Lab: Quiz B (SQL)

Assessment/Other

Quiz B (SQL)

Ass. B due

Week 12: 21 May
Topic

Review, Exam Preparation

Lab: Group Presentations

Assessment/Other

Group Presentations

Peer review ass. B

additional exam advice

Week 13: 28 May
Topic

NO LECTURES

Lab: Group Presentations

Assessment/Other

Group Presentations

Exam consultation

8. Policies

Information about UNSW Business School protocols, University policies, student responsibilities and education quality and support.

Program Learning Goals and Outcomes

The Business School Program Learning Goals reflect what we want all students to BE or HAVE by the time they successfully complete their degree, regardless of their individual majors or specialisations. For example, we want all our graduates to HAVE a high level of business knowledge and a sound awareness of ethical, social, cultural and environmental implications of business. As well, we want all our graduates to BE effective problem-solvers, communicators and team participants.

You can demonstrate your achievement of these goals by the specific outcomes you achieve by the end of your degree (i.e. Program Learning Outcomes—henceforth PLOs). These PLOs articulate what you need to know and be able to do as a result of engaging in learning. They embody the knowledge, skills and capabilities that are identified, mapped, taught, practised and assessed within each Business School program.

All UNSW programs and courses are designed to assess the attainment of program and/or course level learning outcomes, as outlined in the UNSW Assessment Design Procedure. It is therefore important that you become familiar with the Business School PLOs, as they constitute the framework which informs and shapes the course components and assessments of the courses within your program of study.

Program Learning Outcomes

  • Undergraduate
  • Postgraduate Coursework
Knowledge You should be able to identify and apply disciplinary knowledge to business situations in a local and global environment.
Critical thinking and problem solving You should be able to identify and research issues in business situations, analyse the issues, and propose appropriate and well-justified solutions.
Written communication You should be able to prepare written documents that are clear, concise and coherent, using appropriate style and presentation for the intended audience, purpose and context.
Oral communication You should be able to prepare and deliver oral presentations that are clear, focussed, well-structured, and delivered in a professional manner.
Teamwork You should be able to participate collaboratively and responsibly in teams, and reflect on your own teamwork, and on the team’s processes and ability to achieve outcomes.
Ethical, social and environmental responsibility
  1. You should be able to identify and assess ethical, environmental and/or sustainability considerations in business decision-making and practice.
  2. You should be able to identify social and cultural implications of business.
Workplace skills (Co-op programs only) You should be able to conduct yourself in a professional manner in the work environment, communicate effectively in diverse workplace situations and be able to apply discipline knowledge and understanding to real business problems with initiative and self-direction.
Related PLO Documents View the Undergraduate Honours PLOs (pdf)
Knowledge You should be able to identify and apply current knowledge of disciplinary or interdisciplinary theory and professional practice to business in local and global environments.
Critical thinking and problem solving You should be able to identify, research and analyse complex issues and problems in business and/or management, and propose appropriate and well-justified solutions.
Written communication You should be able to produce written documents that communicate complex disciplinary ideas and information effectively for the intended audience and purpose.
Oral communication You should be able to produce oral presentations that communicate complex disciplinary ideas and information effectively for the intended audience and purpose.
Teamwork You should be able to participate collaboratively and responsibly in teams, and reflect on your own teamwork, and on the team’s processes and ability to achieve outcomes.
Ethical, social and environmental responsibility
  1. You should be able to identify and assess ethical, environmental and/or sustainability considerations in business decision-making and practice.
  2. You should be able to identify social and cultural implications of business.
Related PLO Documents View the Master of Philosophy PLOs (pdf)
View the Doctor of Philosophy PLOs (pdf)

UNSW Graduate Capabilities

The Business School PLOs also incorporate UNSW graduate capabilities, a set of generic abilities and skills that all students are expected to achieve by graduation. These capabilities articulate the University’s institutional values, as well as future employer expectations.

UNSW Graduate CapabilitiesBusiness School PLOs
Scholars capable of independent and collaborative enquiry, rigorous in their analysis, critique and reflection, and able to innovate by applying their knowledge and skills to the solution of novel as well as routine problems.
  • Critical thinking and problem solving
  • Knowledge
  • Oral communication
  • Research capability
  • Teamwork
  • Workplace skills
  • Written communication
Entrepreneurial leaders capable of initiating and embracing innovation and change, as well as engaging and enabling others to contribute to change
  • Critical thinking and problem solving
  • Knowledge
  • Oral communication
  • Workplace skills
  • Written communication
Professionals capable of ethical, self- directed practice and independent lifelong learning
  • Ethical, social and environmental responsibility
  • Workplace skills
Global citizens who are culturally adept and capable of respecting diversity and acting in a socially just and responsible way.
  • Ethical, social and environmental responsibility
  • Oral communication
  • Written communication

The Business School strongly advises you to choose a range of courses that assist your development against these PLOs and graduate capabilities, and to keep a record of your achievements as part of your portfolio. You could use these records for work or further study. For support with selecting your courses contact the UNSW Business School Student Centre.

Academic Integrity and Plagiarism

Academic Integrity is honest and responsible scholarship. This form of ethical scholarship is highly valued at UNSW. Terms like Academic Integrity, misconduct, referencing, conventions, plagiarism, academic practices, citations and evidence based learning are all considered basic concepts that successful university students understand. Learning how to communicate original ideas, refer sources, work independently, and report results accurately and honestly are skills that you will be able to carry beyond your studies.

The definition of academic misconduct is broad. It covers practices such as cheating, copying and using another person’s work without appropriate acknowledgement. Incidents of academic misconduct may have serious consequences for students.

Plagiarism

UNSW regards plagiarism as a form of academic misconduct. UNSW has very strict rules regarding plagiarism. Plagiarism at UNSW is using the words or ideas of others and passing them off as your own. All Schools in the Business School have a Student Ethics Officer who will investigate incidents of plagiarism and may result in a student’s name being placed on the Plagiarism and Student Misconduct Registers.

Below are examples of plagiarism including self-plagiarism:

Copying: Using the same or very similar words to the original text or idea without acknowledging the source or using quotation marks. This includes copying materials, ideas or concepts from a book, article, report or other written document, presentation, composition, artwork, design, drawing, circuitry, computer program or software, website, internet, other electronic resource, or another person's assignment, without appropriate acknowledgement of authorship.

Inappropriate Paraphrasing: Changing a few words and phrases while mostly retaining the original structure and/or progression of ideas of the original, and information without acknowledgement. This also applies in presentations where someone paraphrases another’s ideas or words without credit and to piecing together quotes and paraphrases into a new whole, without appropriate referencing.

Collusion: Presenting work as independent work when it has been produced in whole or part in collusion with other people. Collusion includes:

  • Students providing their work to another student before the due date, or for the purpose of them plagiarising at any time
  • Paying another person to perform an academic task and passing it off as your own
  • Stealing or acquiring another person’s academic work and copying it
  • Offering to complete another person’s work or seeking payment for completing academic work

Collusion should not be confused with academic collaboration (i.e., shared contribution towards a group task).

Inappropriate Citation: Citing sources which have not been read, without acknowledging the 'secondary' source from which knowledge of them has been obtained.

Self-Plagiarism: ‘Self-plagiarism’ occurs where an author republishes their own previously written work and presents it as new findings without referencing the earlier work, either in its entirety or partially. Self-plagiarism is also referred to as 'recycling', 'duplication', or 'multiple submissions of research findings' without disclosure. In the student context, self-plagiarism includes re-using parts of, or all of, a body of work that has already been submitted for assessment without proper citation.

To see if you understand plagiarism, do this short quiz: https://student.unsw.edu.au/plagiarism-quiz

Cheating

The University also regards cheating as a form of academic misconduct. Cheating is knowingly submitting the work of others as their own and includes contract cheating (work produced by an external agent or third party that is submitted under the pretences of being a student’s original piece of work). Cheating is not acceptable at UNSW.

If you need to revise or clarify any terms associated with academic integrity you should explore the 'Working with Academic Integrity' self-paced lessons available at: https://student.unsw.edu.au/aim.

For UNSW policies, penalties, and information to help you avoid plagiarism see: https://student.unsw.edu.au/plagiarism as well as the guidelines in the online ELISE tutorials for all new UNSW students: http://subjectguides.library.unsw.edu.au/elise. For information on student conduct see: https://student.unsw.edu.au/conduct.

For information on how to acknowledge your sources and reference correctly, see: https://student.unsw.edu.au/referencing. If you are unsure what referencing style to use in this course, you should ask the lecturer in charge.

Student Responsibilities and Conduct

Students are expected to be familiar with and adhere to university policies in relation to class attendance and general conduct and behaviour, including maintaining a safe, respectful environment; and to understand their obligations in relation to workload, assessment and keeping informed.

Information and policies on these topics can be found on the 'Managing your Program' website

Workload

It is expected that you will spend at least nine to ten hours per week studying for a course except for Summer Term courses which have a minimum weekly workload of eighteen to twenty hours. This time should be made up of reading, research, working on exercises and problems, online activities and attending classes. In periods where you need to complete assignments or prepare for examinations, the workload may be greater. Over-commitment has been a cause of failure for many students. You should take the required workload into account when planning how to balance study with employment and other activities.

We strongly encourage you to connect with your Moodle course websites in the first week of semester. Local and international research indicates that students who engage early and often with their course website are more likely to pass their course.

View more information on expected workload

Attendance

Your regular and punctual attendance at lectures and seminars or in online learning activities is expected in this course. The Business School reserves the right to refuse final assessment to those students who attend less than 80% of scheduled classes where attendance and participation is required as part of the learning process (e.g., tutorials, flipped classroom sessions, seminars, labs, etc.).

View more information on attendance

General Conduct and Behaviour

You are expected to conduct yourself with consideration and respect for the needs of your fellow students and teaching staff. Conduct which unduly disrupts or interferes with a class, such as ringing or talking on mobile phones, is not acceptable and students may be asked to leave the class.

View more information on student conduct

Health and Safety

UNSW Policy requires each person to work safely and responsibly, in order to avoid personal injury and to protect the safety of others.

View more information on Health and Safety

Keeping Informed

You should take note of all announcements made in lectures, tutorials or on the course web site. From time to time, the University will send important announcements to your university e-mail address without providing you with a paper copy. You will be deemed to have received this information. It is also your responsibility to keep the University informed of all changes to your contact details.

Special Consideration

You must submit all assignments and attend all examinations scheduled for your course. You can apply for special consideration when illness or other circumstances beyond your control, interfere with your performance in a specific assessment task or tasks. Special Consideration is primarily intended to provide you with an extra opportunity to demonstrate the level of performance of which you are capable.

General information on special consideration for undergraduate and postgraduate courses can be found in the Assessment Implementation Procedure and the Current Students page.

Please note the following:

  1. Applications will not be accepted by teaching staff. The lecturer-in-charge will be automatically notified when you lodge an online application for special consideration
  2. Decisions and recommendations are only made by lecturers-in-charge (or by the Faculty Panel in the case of final exam special considerations), not by tutors
  3. Applying for special consideration does not automatically mean that you will be granted a supplementary exam or other concession
  4. Special consideration requests do not allow lecturers-in-charge to award students additional marks

Business School Protocol on requests for Special Consideration

The lecturer-in-charge will need to be satisfied on each of the following before supporting a request for special consideration:

  1. Does the medical certificate contain all relevant information? For a medical certificate to be accepted, the degree of illness and its impact on the student must be stated by the medical practitioner (severe, moderate, mild). A certificate without this will not be valid. Students should also note that only medical certificates issued after physically visiting a registered medical practitioner will be accepted. Medical certificates submitted for Special Consideration should always be requested from a registered medical practitioner that you have seen at a medical practice. Certificates obtained online or via social media may be fraudulent and if relied upon could result in a breach of the UNSW Student Code.
  2. Has the student performed satisfactorily in the other assessment items? To understand what Satisfactory Performance means in this course, please refer to the 'Formal Requirements' section in Part A of your Course Outline

Special Consideration and the Final Exam in undergraduate and postgraduate courses

Applications for special consideration in relation to the final exam are considered by a Business School Faculty panel to which lecturers-in-charge provide their recommendations for each request. If the Faculty panel grants a special consideration request, this will entitle the student to sit a supplementary examination. No other form of consideration will be granted. The following procedures will apply:

  1. Supplementary exams will be scheduled centrally and will be held approximately two weeks after the formal examination period.

    Supplementary exams for Semester 1, 2018 will be held during the period 14 - 21 July, 2018. Students wishing to sit a supplementary exam will need to be available during this period.

    The date for all Business School supplementary exams for Summer Term 2017/2018 is Wednesday, 21 February, 2018. If a student lodges a special consideration for the final exam, they are stating they will be available on this date. Supplementary exams will not be held at any other time.

  2. Where a student is granted a supplementary examination as a result of a request for special consideration, the student’s original exam (if completed) will be ignored and only the mark achieved in the supplementary examination will count towards the final grade. Absence from a supplementary exam without prior notification does not entitle the student to have the original exam paper marked, and may result in a zero mark for the final exam.

The Supplementary Exam Protocol for Business School students is available at: http://www.business.unsw.edu.au/suppexamprotocol

For special consideration for assessments other than the final exam refer to the ‘Assessment Section’ in your course outline.

Protocol for Viewing Final Exam Scripts

The UNSW Business School has set a protocol under which students may view their final exam script. Please check the protocol here.

Given individual schools within the Faculty may set up a local process for viewing final exam scripts, it is important that you check with your School whether they have any additional information on this process. Please note that this information might also be included in your course outline.


Student Support and Resources

The University and the Business School provide a wide range of support services and resources for students, including:

Business School EQS Consultation Program
The Consultation Program offers academic writing, literacy and numeracy consultations, study skills, exam preparation for Business students. Services include workshops, online resources, individual and group consultations.
Level 1, Room 1035, Quadrangle Building.
BUS.EQS.Consultations@unsw.edu.au
02 9385 4508

Business School Student Centre
The Business School Student Centre provides advice and direction on all aspects of admission, enrolment and graduation.
Level 1, Room 1028 in the Quadrangle Building
02 9385 3189

UNSW Learning Centre
The UNSW Learning Centre provides academic skills support services, including workshops and resources, for all UNSW students. See their website for details.
Lower Ground Floor, North Wing Chancellery Building.
learningcentre@unsw.edu.au
02 9385 2060

Educational Support Service
Educational Support Advisors work with all students to promote the development of skills needed to succeed at university, whilst also providing personal support throughout the process. Check their website to request an appointment or to register in the Academic Success Program.
John Goodsell Building, Ground Floor.
advisors@unsw.edu.au
02 9385 4734

Library services and facilities for students
The UNSW Library offers a range of collections, services and facilities both on-campus and online.
Main Library, F21.
02 9385 2650

Moodle eLearning Support
Moodle is the University’s learning management system. You should ensure that you log into Moodle regularly.
externalteltsupport@unsw.edu.au
02 9385 3331

UNSW IT
UNSW IT provides support and services for students such as password access, email services, wireless services and technical support.
UNSW Library Annexe (Ground floor).
itservicecentre@unsw.edu.au
02 9385 1333

Disability Support Services
UNSW Disability Support Services provides assistance to students who are trying to manage the demands of university as well as a health condition, learning disability or who have personal circumstances that are having an impact on their studies. Disability Advisers can arrange to put in place services and educational adjustments to make things more manageable so that students are able to complete their course requirements. To receive educational adjustments for disability support, students must first register with Disability Services.
Ground Floor, John Goodsell Building.
disabilities@unsw.edu.au
02 9385 4734

UNSW Counselling and Psychological Services
Provides support and services if you need help with your personal life, getting your academic life back on track or just want to know how to stay safe, including free, confidential counselling.
Level 2, East Wing, Quadrangle Building.
counselling@unsw.edu.au
02 9385 5418


INFS1603-2018-S1