Recent Question/Assignment
ITC114 - Database Management Systems
Session 2 2015
Faculty of Business
School of Computing and Mathematics Internal Mode
Subject Overview
This subject aims to provide a solid grounding in database management theory and application, and its place within the implementation of computer based applications. There will be an emphasis on conceptual modeling to design the database that is implemented and queried using Structured Query Language (SQL).
Learning outcomes
On successful completion of this subject, you should
be able to apply database theory to the design and implementation of relational databases; be able to analyse and model business database requirements using Entity Relationship Diagrams (EDR);
be able to analyse a database design and apply normalisation theory and techniques; be able to implement a database design using Structured Query Language (SQL); be able to explain the use of transaction processing, security and database integrity in relation to relational databases.
Lecturer Details
Subject Coordinator Rajasekaran Lakshmiganthan Email rlakshmiganthan@studygroup.com Phone To be advised.
Campus To be advised.
Building/Room number To be advised.
About your lecturer
Lecturer Name: Dr Sarwar Tapan
Lecturer Email Address: STapan @studygroup.com (mailto:MBaron@studygroup.com)
Sarwar Tapan obtained PhD in Computer Science degree from La Trobe University, Melbourne, Australia in 2013 on Data Mining. His PhD research focused on investigating advanced computational approaches for mining subtle regulatory motifs in DNA sequences. He received Master of Science degree in Cognitive Sciences with major in Artificial Intelligence from University Malaysia Sarawak, Malaysia in 2008 and Bachelor of Computer Science degree from University of Wollongong, Australia in 2004. His current research area includes data mining, machine learning, cluster analysis, fuzzy-systems, data visualization and Bioinformatic topics with emphasis on Self-Organizing Maps ( SOM)-based approaches for regulatory motif discovery in the promoters of co-regulated genes. His teaching interest includes data mining, computational intelligence, database systems and other computer science and IT subjects.
Learning, Teaching and Support Strategies
Class times and location
Lecture 1: Tuesdays 5.00pm-8.00pm, Room 3.01 & 3.02
Lecture 2: Wednesdays 9.00am-12.00pm, Room 3.01 & 3.02
Compusory workshop or Residential School
There is no compulsory workshop or residential school for this subject.
How to contact your lecturer
Any questions concerning the teaching of this subject can be made by contacting your Subject Lecturer.
Dr Sarwar Tapan
Email : STapan @studygroup.com (mailto:MBaron@studygroup.com)
Email is the best option. Please send a brief message regarding the issue and include the subject name and code in your email –it really helps to know which class you belong to, before I respond to your query. If you prefer to phone me that is fine, but please leave a message if I am not there at the time – I will give you a call back as soon as I can.
How you are expected to engage with the subject
All of your subject materials are available on the Interact site under the Topics link in the left hand side menu. I suggest that for each topic you read the learning objectives carefully, read the overview, have a quick skim of the text and then watch the interactive tutorial. Once you have got a feel for what the topic is about try and make a good set of notes under each of the topic review questions in that topic. You can do this by watching the tutorial and consulting the text again in a more considered way. These questions have been designed to give you focus in the topic, so it really helps to prepare a useful set of answers to them.
In this subject there are also lots of opportunities for you to engage with me, with your peers and with the subject. I will be holding 12 regular sessions where we can discuss content issues and assessment items. As part of your assessment in this subject you are required to work alone for all the assessment items.
It is helpful to have a small task to complete early in the session, so that you have a focus in the subject from the very first day, and so I have set a small assessment item in week 4, as part of your assessment. If you don’t complete the assessment, I may contact you by phone or email to have a chat about study and if there are any issue that I can help with.
The study guide and/or subject materials for this subject have been written specifically to guide you through the sections (and questions) of the prescribed textbook relevant to each topic.
You should check the Interact Site at least weekly for postings, announcements, lecture information and other resources that will assist your studies or additional information and resources vital to your success in the subject.
Studying at university does not mean studying alone. Take advantage of collective wisdom and post your questions to the subject forum.
Use the subject schedule to plan your studies over the session.
The first assessment task in this subject is designed to identify students who are not engaged in the subject and are therefore at risk of failure or withdrawal
Information on effective time management is available on the CSU Learning Support website via the following link: student.csu.edu.au
Visit the Learning Support website for advice about assignment preparation, academic reading and note taking, referencing, effective time management and preparing for exams at: student.csu.edu.au You can also contact an adviser through Student Central on the following number: 1800 275 278 (or +61 2 6933 7507 from outside Australia).
Library services
You can find on the Library Services web site full details of how we can help you find books, articles, Australian and international databases, full-text newspapers and journals, electronic reference collections as well as links to other libraries and their catalogues:
The Library website provides access to print and online material, such as books, reports, journals, articles, dissertations, newspapers, and other reference tools. You will also find guides and assistance to help you use the Library's resources. http://www.csu.edu.au/division/library/
You can find Library Services on both the CSU website and the SGA library catalogue website including access to a wide range of electronic books, electronic journals, as well as textbooks available for loan in the Darlinghurst campus library. You can also access reports, journals, articles, dissertations, full text newspapers, and online reference resources (e.g. ABS statistics, Australian standards, encyclopaedias, dictionaries), as well as links to other libraries and their catalogues:
http://aleph.unilinc.edu.au/sga - SGA Melbourne library catalogue including electronic books and electronic journals online.
http://www.csu.edu.au/division/library/ - CSU Library Services including Primo Search catalogue, online tutorials and video tutorials in research skills, finding articles for assignments, topic analysis, Endnote referencing program and many other online library services to help you successfully complete your assignments for all CSU courses.
http://trove.nla.gov.au/ - Powerful search engine from National Library of Australia to access many different online resources on any subject from one search.
Contact Details for renewing loans, locating books and other information:
SGA Melbourne Library:
Marian Lees – Director, Library Services
Email: MLees@studygroup.com
Library Help
Friendly and quick assistance available. Ask for help finding information and navigating the library's extensive eResources.
http://www.csu.edu.au/division/library/help/ask
Online Tutorials
Learn how to:
•use Primo Search to find eReserve material and journal articles.
•identify appropriate sources of information and peer reviewed material, and evaluate resources.
•search journal databases and web resources for information for your assessments. http://www.csu.edu.au/division/library/how-to/watch-it
Bookmark your Subject Library Guide
Subject Library guides are a great way to get started with research. Each online guide is tailored to a specific area of study, outing how to research in your area and where to look for information.
http://libguides.csu.edu.au/
Academic learning support assistance
Visit the learning support website for advice about assignment preparation, academic reading and note-taking, referencing, and preparing for exams at: http://student.csu.edu.au/study
You may also contact:
Ann Ahn
Email: aahn@studygroup.com Phone: (03) TBA
For appointments, please see Reception.
Queries regarding the content of this subject should be directed to your subject lecturer.
Your workload in this subject
CSU Academic Senate policy states that a standard 8 point subject should require you to spend a total of 140-160 hours engaged in the learning and teaching activities. This means an average of 10 to 12 hours each week.
Text and Learning Materials
Prescribed text(s)
Students must have access to a copy of the prescribed textbook.
Coronel, C., Morris, S. (2015) Database Systems: Design, implementation and management (11th ed.). ISBN-13: 978-1-285-19614-5, Cengage Learning.
Assessment Information
Introduction to assessment
To protect the academic integrity of the subject, you may be asked to complete an additional test ( which may be verbal) if I or another member of the teaching staff have doubts that the work that you have submitted for an assessment item is your own. This test would be held within 4 weeks of the submission of the assessment.
Detailed information regarding:
Sample exam (for subjects with a formal exam)
Pass requirements
Grades
Presentation
Submissions
Extensions
Penalties for late submission
Assignment return
Resubmission Plagiarism
are included in Appendix 1.
* due date is the last date for assessment items to be received at the University
** applies only to assessment items submitted by the due date
Assessment item 1
Online Quiz 1
Value: 7 %
Due date: 14- Aug -2015
Return date: 04- Sep -2015
Submission method options Interact2 Test
Task
Complete the online quiz in Interact 2 Test Centre.
Rationale
This assignment will assess your knowledge of the fundamentals of database systems and data models. Marking criteria
This assignment is a series of multiple choice questions. Each correct answer will score 1 mark. Marks will not be deducted for incorrect answers.
Assessment item 2
Modelling
Value: 15 %
Due date: 28- Aug -2015
Return date: 18- Sep -2015
Submission method options Alternative submission method
Task
Overview of business case:
Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the available models online so to order they must visit one of the showrooms. A&B has been using an Excel spreadsheet to track their business activities; however, this has caused many redundancies and inefficiency.
With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly, they hired you to design a relational database to better track and record their operational data.
A&B business rules and instructions for creating your ERD:
1. A&B can get boats from several different manufacturers. Each manufacturer produces one or more different types of boats. Each and every type is produced by only one manufacturer. Every manufacturer is identified by a manufacturer code. The company name, street, city, state, postcode, phone number, and account number are kept in the system for every manufacturer. For each type, the type name (i.e. Paddle, Inflatable, Jet Ski, etc.) and purpose (i.e. fishing, day boating, etc.) are kept in the system.
Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule
2. Every type has one or more models. Every model is produced as part of a type. For each model, the model number, engine, length, beam, suggested retail price, A&B retail price and dry weight must be kept in the system.
Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1.
3. Each type’s models are stored in a specific warehouse. Each warehouse stores the models of only one type. Each warehouse is identified by a warehouse ID. For each warehouse address, postcode, phone number are kept in the system.
Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1 and business rule 2.
NOTE
Use Flow Chart Maker & Online Diagram Software (https://www.draw.io) to create your ERD
Use Crows Foot notations
Any M:N relationship is to be resolved to a 1:M relationship
Manually drawing the ERD is NOT acceptable.
Rationale
This assessment item is designed to test your understanding of basic database design and modelling concepts, and your ability to interpret business rules into an Entity Relationship Diagram.
Additionally, your ability to apply correct relationships, cardinalities, optionalities, and the use of Crows Foot modelling notations are tested.
Marking criteria
The marking criteria for this assignment is:
Task HD DI CR PS
Create an The ERD accurately The ERD The ERD accurately The ERD
ERD that identifies and correctly accurately identifies and correctly identifies represents shows all entities, PKs, identifies shows most entities, and shows the entities, attributes, relationships, and correctly PKs, attributes, but some attributes, associative entities (if shows all some of the entities, PKs, the applicable), cardinalities entities, PKs, relationships, associative attributes, relationshipsand optionalities attributes, entities (if applicable), but most of
between relationships,cardinalities and the entities, and and optionalities are relationships, the associative incorrect cardinalities cardinality entities (if and and applicable) optionalities optionality but some of are incorrect
of each the
relationship cardinalities
that are and
described by optionalities
the three are incorrect business rules
Assessment item 3
Normalisation
Value: 15 %
Due date: 11- Sep -2015
Return date: 02- Oct -2015
Submission method options Alternative submission method
Task
Using Table 1: GRADE REPORT relation above
1. Draw a dependency diagram to show the functional dependencies in the relation
2. Decompose GRADE REPORT into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
NOTE
Manually drawing the dependency diagram or the relational schema is NOT acceptable.
Rationale
1 . This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy. 2 . Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.
Marking criteria
The marking criteria for this assignment are shown below:
Task HD DI CR PS
Draw a The dependency The dependency The dependency The dependency diagram diagram diagram identifies dependency diagram to show accurately accurately and shows most diagram the functional identifies and identifies and PKs and some identifies dependencies in correctly shows correctly shows functional, partial, and shows the relation all PKs and all all PKs and most and transitive few PKs and
functional, partial, functional, partial, dependencies few
and transitive and transitive functional, dependencies dependencies partial, and
transitive dependencies
Decompose The set of 3NF The set of 3NF The set of 3NF The set of
GRADE relations relations relations identifies 3 NF
REPORT into a accurately accurately and shows most relations set of 3NF identifies and identifies and PKs and some of identifies relations correctly shows correctly shows the relevant and shows all PKs and all the all PKs and most attributes few PKs and relevant attributes of the relevant few of the
attributes relevant
attributes
Draw a relational The relational The relational The relational The schema for your schema accurately schema accurately schema identifies relational 3NF relations and identifies and identifies and and shows some schema show the correctly shows correctly shows of the referential identifies
referential all of the most of the integrity and shows integrity referential referential constraints few of the constraints integrity integrity referential constraints constraints integrity
constraints
Assessment item 4
Online Quiz 2
Value: 8 %
Due date: 25- Sep -2015
Return date: 16- Oct -2015
Submission method options Interact2 Test
Task
Complete the online quiz in the Interact 2 Test Centre.
Rationale
This assignment will assess your knowledge of business requirements, database design and normalisation.
Marking criteria
This assignment is a series of multiple choice questions. Each correct answer will score 1 mark. Marks will not be deducted for incorrect answers.
Assessment item 5
Query and update databases using SQL
Value: 15 %
Due date: 09- Oct -2015
Return date: 30- Oct -2015
Submission method options Alternative submission method
Task
NOTES
This assignment encourages you to use SQLite to complete the tasks listed below.
The instructions listed below relate to SQLite.
For guidance on how to install SQLite, watch this short YouTube video:
https://www.youtube.com/watch?v=YZQuQ6jael8
For guidance on how to create tables using SQLite, watch this short YouTube video:
https://www.youtube.com/watch?v=Ev2JnjavvmE
You are welcome to use MySQL . The instructions for using MySQL will be placed in the Students Resources Folder.
To use other packages, please seek the approval of your subject coordinator. Typing the SQL statements or the results is NOT acceptable.
Instructions
From Resources under Main Menu in Interact 2 go to Students Resources Folder
Copy sqlite3.exe and cmd.exe files from the Students Resources Folder into a folder in your machine
Copy a5.txt from the Students Resources Folder into the folder in your machine where your SQLite file is located
Open a5.txt in Notepad
Replace your studentid in line .output your studentid .txt in a5.txt with your actual studentid i.e.
for example 45446667.txt
From the Command Prompt type sqlite3.exe your studentid.db
Note: From the Command Prompt call the folder in your machine where your SQLite file is located before you type sqlite3.exe yourstudentid.db
At the SQLite Command Line type .read a5.txt [to create the tables you will use to answer this assignment’s questions]
At the SQLite Command Line type .quit
Using WordPad open your studentid .txt [to check the tables you created exist]
From the Command Prompt type sqlite3
At the SQLite Command Line type .open your studentid.db
At the SQLite Command Line type .headers on
At the SQLite Command Line type .mode column
Write and run SQL statements to complete the following tasks
1. Show all the details of the products by v_code 21344
2. Locate the record in the vendor table that does not have a value for the attribute V_STATE 3. Find the customers whose balance is greater than 200 but less than 300.
4. What is the max balance?
5. Show the names of the customers for whom we have invoices.
6. Show the CUS_CODE of the customers for whom we DO NOT have invoices.
7. Show the names of the customers for whom we DO NOT have invoices.
8. Find out how many times a customer generated an invoice.
9. List the names of the customers and how many times a customer generated an invoice.
10. Add a new attribute (field) credithistory varchar(6) to the customer table.
11. Update credithistory for customer '10011' to 'Bad'.
12. Delete the employee Leighla Genkazi from the EMP table.
You are required to submit:
1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file
2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file
Rationale
This assignment will assess your knowledge and ability to use SQL to query database tables and update them. It will also test your ability to write both simple and complex queries and run those queries to return the requested data.
Marking criteria
The following criteria will be used to assess Assignment 5:
Task HD DI CR PS
Write and run The SQL The SQL The SQL The SQL
SQL statements to statements retrieve statements retrieve statements retrieve statements complete tasks or update the or update the or update the retrieve or
1-12 above required required required update the
information for all information for information for required assignment tasks most of the some of the information
Assessment item 6
Final Exam
Value: 40 %
Date: To be advised
Duration: 2 hours 10 minutes
Submission method options
N/A - submission not required/applicable
Rationale
Covering all topics, this assessment task has been designed to assess your ability to:
be able to apply database theory to the design and implementation of relational databases; be able to analyse and model business database requirements using Entity Relationship Diagrams;
be able to analyse a database design and apply Normalisation theory and techniques; be able to implement a database design using Structured Query Language (SQL); be able to query a database using SQL.
Requirements
The examination consists of:
Multiple choice questions, short and long answer questions.
The examination is a Closed book examination.
All questions must be answered.
Marking criteria
Question 1 has a similar criteria to Assignment 1 and 4 Question 2 has a similar criteria to Assignment 2.
Question 3 has a similar criteria to Assignment 3.
Question 4 has a similar criteria to Assignment 5.
Material provided by the University
Answer Booklets (1 X 12 page)
General Purpose Answer Sheet GPAS-200R
Material required by the student
Writing implements, including a 2B pencil and an eraser.
Any calculator allowed, including programmable calculators (hand held, no printer). iPads and other hand-held computers are not accepted as calculators.
Appendix 1 Assessment Information
Sample exam
Note: A sample exam paper (with solutions) which is indicative of the structure of the final exam will be provided in the Students Resources Folder of this subject's CSU Interact 2 site.
Pass Requirements
You must obtain at least 50% in both the examination and the total mark in order to pass this subject. You must pass the exam to pass the subject.
Grades
Final grades for this subject are awarded by the Business Faculty Assessment Committee in accordance with the University's Assessment Regulations. (See current Academic Regulations at https://policy.csu.edu.au/view.currect.php?id-00301#s3
(https://policy.csu.edu.au/view.currect.php?id=00301#s3)). University's Assessment Policy: Coursework Subjects (https://policy.csu.edu.au/view.current.php?id=00301).
Your final grade for the subject as a whole will be based on the grading scale outlined in the CSU Assessment Policy: Coursework Subjects https://policy.csu.edu.au/view.current.php?id=00301 ( https:// policy.csu.edu.au/view.current.php?id =00301).
HD High Distinction 85% - 100%
An outstanding level of achievement in relation to the assessment process.
DI Distinction 75% - 84%
A high level of achievement in relation to the assessment process.
CR Credit 65% - 74%
A better than satisfactory level of achievement in relation to the assessment process.
PS Pass 50% - 64%
A satisfactory level of achievement in relation to the assessment process.
FL Fail 0 - 49%
An unsatisfactory level of achievement.
The percentages specified above should be viewed only as guidelines for the award of final grades.
The Faculty has an obligation to ensure that grades are equitable across different cohorts of the same subject offering and will undertake appropriate moderation processes to ensure that grades are awarded consistently in accordance with the University’s Moderation Policy.
For further information please consult the CSU Assessment Policy: Coursework Subjects http://policy.csu.edu.au/view.current.php?id=00301
Presentation
The following points are a general guide for presenting assessment items.
Assessment items should be typed.
Use 1.5 spacing.
Use a wide left margin. Markers need space to be able to include their comments.
Use a standard 12pt font such as Times New Roman, Calibri or Arial.
Left- justify body text.
Include a separate title page with your name, student number, subject code, assessment
number and assessment question. Include class time and tutor’s name if applicable.
Number your pages (except the cover page).
Use a header or footer with your name and student number on each page.
Always keep a copy of your assessments. Both a hard copy and an electronic copy. Most importantly, always use your spelling and grammar checker, but remember that this does not pick up all errors. You must still manually and carefully edit your work.
Submission
Online Submission
Submit your assignments using EASTS
Extensions
In order to ensure that other students who hand their assignments in on time are not disadvantaged, and to enable me to comply with the requirement to return assignments to the class within 15 working days, the following rules about extensions will be strictly enforced:
1. Extensions cannot be granted for on-line tests, as these have to be done within a specific time frame, after which the answers are released to the class automatically.
2. Computer problems (such as the speed of your computer and the time it may take you to upload assignments onto EASTS) and normal work-related pressures and family commitments do not constitute sufficient reasons for the granting of extensions.
3. If it becomes obvious that you are not going to be able to submit an assignment on time because of an unavoidable problem, you must submit your request for an extension to the Subject Coordinator in writing (email is acceptable) prior to the due date.
Requests for extensions will not be granted on or after the due date so you must make sure that any extension is requested prior to the day on which the assignment is due.
You are expected to do all you can to meet assignment deadlines. Work and family- related pressures do not normally constitute sufficient reasons for the granting of extensions or incomplete grades.
4. If you apply for an extension, you may be asked to email your lecturer on what you have done so far on the assignment.
5. You must be able to provide documentary evidence (such as a certificate from a doctor or counsellor) justifying the need for an extension as soon as practicable - but please note that if the circumstances giving rise to the request for an extension arise on a day when you cannot get documentary evidence, you must still apply for the extension before the due date and submit the documentary evidence afterwards.
6. Given the tight deadlines involved in returning assignments to students and putting feedback on Interact, the maximum extension granted generally will be seven (7) days from the due date.
7. Assignments received more than 10 days after the due date or extension date will not be marked unless the staff member decides otherwise. Items received late will be penalised at 10% of the mark available for the assessment item per day it is late (see below).
8. Note that for purposes of measuring lateness, the 'day' begins just after 00.00 hrs AEST - so an assignment received after midnight of the due date will be penalised 10% for lateness. This rule will be applied to all students uniformly.
Penalties for Late Submission
The Faculty of Business has determined that the penalty for the late submission of an assessment task ( without obtaining the Subject Coordinator's approval for an extension) will be :
10% deduction per day, including weekends, of the maximum marks allocated for the assessment task, i.e. 1 day late 10% deduction, or 2 days late 20% deduction.
An example of the calculation would be:
Maximum marks allocated = 20
Penalty for one day late = 2 marks (so, a score of 18/20 becomes 16/20 and a score of 12/20 becomes 10/20).
If an assignment is due on a Friday but is not submitted until the following Tuesday, then the penalty will be four days (40% deduction or 8 marks in the example above).
Submissions more than 10 days late will be acknowledged as received but will not be marked.
Assignment Return
You should normally expect your marked assignment to be returned to you within three weeks of the due date, if your assignment was submitted on time. If you submitted your assignment on time but not received it back by the return date, you should make enquiries in the first instance to the subject coordinator.
Resubmission
Under normal circumstances resubmission of assessment items will not be accepted for any of the assessments required in this subject.
Assessment Requirements
Assessment at CSU is criterion-referenced and standards-based where students' work is assessed against stated criteria that reflect the expected learning outcomes of the course and subject. Subjects that use a satisfactory/unsatisfactory grading scale will have this clearly identified within the Subject Outline.
For further information please consult the University's Assessment Policy: Coursework Subjects ( https://policy.csu.edu.au/view.current.php?id =00301).
Referencing
Referencing is an important component of academic writing. All CSU assessment tasks should be appropriately referenced. The specific details of the referencing requirements are included in each assessment task description.
For further information and assistance with referencing refer to http://student.csu.edu.au/study/referencing-at-csu
Plagiarism
Charles Sturt University expects that the work of its students and staff will uphold the values of academic honesty and integrity. The Guide to Avoiding Plagiarism is located at:
http://student.csu.edu.au/study/plagiarism. This is an important resource that will help you understand these values and apply them in practice. You should familiarise yourself with these requirements and ensure that all assessments submitted by you are your own work, have not been submitted elsewhere and comply with the University's requirements for academic integrity.
The University has purchased Turnitin software. This software has two functions, a pre-emptive education function which students may use to check their own work prior to submission, and a plagiarism detection function which academics may use to check the student’s work for improper citation or potential plagiarism. Use by students is optional and is not a prerequisite for submission.
You are encouraged to check your work for originality prior to submission. You can register with Turnitin to create a Student Account under the CSU Turnitin Licence at http://www.turnitin.com/login_page.asp. Further information on how to use Turnitin is provided within the Guide to Avoiding Plagiarism: http://student.csu.edu.au/study/plagiarism/checking.
Appendix 2 CSU Learning and Teaching Policies
Minimum standards of consultation
According to the Academic Communication with Students Policy
( https://policy.csu.edu.au/view.current.php?id=00139#s3) (clause 8 in section 3), when a student directly contacts a teaching staff member for information, advice and/or support (except in online teaching spaces) the teaching staff member will respond to the request within 3 working days. Clauses
19-21: Use of Online Discussion and Communication Technologies states that for each subject, the Subject Coordinator will be expected to set up and/or activate an appropriate asynchronous communication technology and respond at least once a week to student messages that request information and advice.
The Higher Degree by Research Candidates Policy - Academic Communication
( https://policy.csu.edu.au/view.current.php?id=00283) states that a Communication Plan, a documented agreement between a HDR candidate and his/her supervisory team that establishes common understandings and expectations of how and when communication will occur during the candidature will be developed. The Plan should then be reviewed regularly throughout candidature.
University Policies and Regulations
Academic matters are defined by, and are subject to, Charles Sturt University policies and regulations. Your Subject Outline should be read in conjunction with all such academic regulations and policies, as some of these may affect the outcome of your studies.
Academic Progress Regulations
The University requires each student to progress through his or her course at a rate that will enable him or her to complete the course in a specified maximum time. This maximum time is intended to ensure the currency of the knowledge within the course and therefore professional suitability of graduates. Failure to complete within the specified maximum time shall lead to the expiry of a student?s enrolment in the course. The University believes that all students have a right to know in advance of study in their course exactly what constitutes satisfactory progress in that course. To this end the University will specify a maximum completion time for each course, and will also provide support to students identified as being at risk of exclusion.
The Academic Progress Policy (https://policy.csu.edu.au/view.current.php?id=00250) sets out the requirements and procedures for satisfactory academic progress, for the exclusion of students who fail to progress satisfactorily and for the termination of enrolment for students who fail to complete in the maximum allowed time.
Variations to Subject Outlines
Should it be necessary to change the content of the Subject Outline during a teaching session, it will be done in consultation with the Head of School and other support services of the University. You then will be notified of the changes in writing by the subject coordinator.
Variations to Assessment
Should it be necessary to vary the assessment in this subject, you will be notified in writing by the Subject Coordinator, or Subject Convenor where one is appointed. The variations to assessment include variations to the assessment tasks and/or assessment procedures for assignments, examinations and any other assessment task published in the Subject Outline. The variations will be communicated only after the Subject Coordinator or Subject Convenor has obtained approval from their Head of School. The overriding principle is that such changes will not disadvantage students and is made in accordance with the Subject Outlines Policy (https://policy.csu.edu.au/view.current.php?id=00267).
Evaluation of Subjects
It is University policy that all subjects are evaluated every time that they are offered. The University's Division of Student Learning administers the Subject Experience Survey through CSU's online evaluation system. Staff in the faculties and schools value your feedback very highly and take account of your comments when reviewing learning and teaching in each subject.
If you are interested in the details of any enhancements to this subject as a result of the latest survey, please contact the subject coordinator. Students can also view overall results for subjects via the Student Subject Experience Survey Results Portal: https://student.csu.edu.au/home/subject-experience-survey-results
Surveys for each of the subjects you are enrolled in for this session will be available for you to complete for a period of 4 weeks from the last week of the teaching session. An email message will alert you to the availability of the surveys online.
Please complete the subject evaluation by following the link:
https://P8.courseval.net/etw/ets/et.asp?nxappid=CS2&nxmid=start (http:// https://P8.courseval.net/etw/ets/et.asp?nxappid=CS2&nxmid=start)
Individual subject results are only reported to the Subject Coordinator and Heads of Schools after grades have been submitted for each teaching session (except where subjects have one student the results are not reported to staff).
Special Consideration
Academic regulations provide for special consideration to be given if you suffer misadventure or extenuating circumstances during the session (including the examination period) which prevents you from meeting acceptable standards or deadlines.
Applications for special consideration must be submitted in writing and include supporting documentary evidence. Such applications should be sent to the Student Administration Office.
For further information about applying for special consideration please refer to Special Consideration Policy (https://policy.csu.edu.au/view.current.php?id=00298).
Assessment Regulations
The assessment practices of all University subjects are conducted in accordance with the University?s Assessment Policy: Coursework Subjects (https://policy.csu.edu.au/view.current.php?id=00301).
Academic Conduct
The University expects that you, as a student, will be honest in your studies and research and that you will not do anything that will interfere with or frustrate the studies and research of other students. In particular, you are expected to:
acknowledge the work of others in your assignments and other assessable work; not knowingly allow others to use your work without acknowledgment;
report honestly the findings of your study and research; and use only permitted materials in examinations.
Details of expected academic conduct are provided in:
the Student Academic Misconduct Policy
( https://policy.csu.edu.au/view.current.php?id=00279);
the Academic Progress Policy (https://policy.csu.edu.au/view.current.php?id=00250);
Students are also expected to be responsible in the use of University facilities and resources and to abide by University rules concerning the Library and electronic resources.
the Library Rule (https://policy.csu.edu.au/view.current.php?id=00280); and the Computing and Communications Facilities Use Policy ( https://policy.csu.edu.au/view.current.php?id =00145).
Copies of the Rule of the Library and Code of Conduct for Users of Electronic Facilities can also be obtained from the Library or the Division of Information Technology (DIT) Service Desk.
Penalties for breaching the above Rule and Policies include suspension or exclusion from the University.
Students also have expectations of the University and of other students in the cooperative endeavour of studying. Details of these expectations are provided in the Student Charter ( https://policy.csu.edu.au/view.current.php?id =00268).
Residential school
There is no residential school for this subject.
Subject Outline as a Reference Document
This Subject Outline is an accurate and historical record of the curriculum and scope of your subject. The Subject Outline Policy (https://policy.csu.edu.au/view.current.php?id=00267) (at clause 16(f)) requires that you retain a copy of the Subject Outline for future use such as for accreditation purposes.
Appendix 3 Support Services
Student Central
Student Central is the first point of contact for currently enrolled students to access all non-teaching services. Student Central liaises closely with Divisions and Schools to ensure the timely and accurate resolution of student enquiries.
You may direct your enquires in person to Student Central staff situated within the Learning Commons found on campus at Albury-Wodonga, Bathurst, Dubbo, Orange, and Wagga Wagga.
You may also contact Student Central through:
ask@csu.edu.au (mailto:ask@csu.edu.au)
1800 ASK CSU (1800 275 278)
Phone from outside Australia: + 61 2 6933 7507
Information on Your Library Services
Finding Information
CSU Library provides you with free access to over 600,000 books and 50,000 journals, and much more. Get an introduction to your library with the Library Orientation Toolbox ( http://www.csu.edu.au/division/library/find-info/toolbox ).
Primo Search
Finding the resources you need is easy with Primo Search
( http://primo.unilinc.edu.au/primo_library/libweb/action/search.do?dscnt=1&dstmp=1328694476534& Search most of the Library’s collections, including online resources, print publications and CSU research. Plus, you can easily place loan requests, view your current loans, and renew items online.
Online Resources
You’ll find journal databases, eBook collections, and other useful online information sources listed under Key Resources (http://student.csu.edu.au/library/find-information).
eReserve
Some subject readings may be held in eReserve
( http://student.csu.edu.au/library/find-info/search-reserve). Online access is encouraged to help reduce CSU’s carbon footprint, however a printed copy of eReserve subject readings can be purchased through CSU Print (http://www.csu.edu.au/division/student-learning/csu-print/home).
Borrowing
Your borrowing privileges depend on your enrolment. Visit Information for Students
( http://student.csu.edu.au/library/help/information-for-students) to find out what you are eligible for. The Library FAQs (http://www.csu.edu.au/division/library/how-to/faq) have more information on borrowing and access to resources.
Need help?
CSU Library staff are available to answer your questions by phone, Live Chat, email, forum, or in person. See Ask a Librarian (http://student.csu.edu.au/library/contacts/ask-a-librarian) for more information.
Keep up to date with what is happening in your Library through Facebook, Twitter and our blog.
CSU Library Facebook (http://www.facebook.com/CSULibrary) CSU Library Twitter
(http://twitter.com/CSU_Library) CSU Library Blogs
( http://student.csu.edu.au/library/about-your-library/library-blog )
Academic Learning Assistance
CSU’s Learning Skills Advisers can help you develop the skills you need to succeed in your studies.
Learning Skills advisers can help you with:
Understanding and preparing assignments
Study skills
Exam preparation
Time management
Notetaking and
Referencing and avoiding plagiarism
Learning Skills also have specialists in English Language, online learning and maths and statistics who can support your development in these areas.
Students can take advantage of online resources and workshops, forums and individual appointments either in person, or online. More information is available at student.csu.edu.au/study ( http://student.csu.edu.au/study ).
STUDYLINK provides access to a variety of short, non-award subjects in preparation for university study. Subjects are available throughout the year through flexible, online delivery, and each is designed to help you gain confidence, skills and knowledge for your university studies ( http://www.csu.edu.au/student/studylink/).
Student Support - http://student.csu.edu.au/support
A wide range of services are provided to support your student academic experience. Services are available on campus with relevant services also available via telephone and online. Services provided include:
Orientation
Student mentoring
Scholarship and financial assistance
Counseling support and referral
Academic appeals and legal advice referral
Disability, welfare and equity support and referral
Health and wellbeing
Social and recreational activities
Graduation
Indigenous student support
International student support
Residential Student Support - http://student.csu.edu.au/campus/residences/residential-advisors
The Residential Support Scheme operates across all campuses to provide for the pastoral care and welfare of residents and actively encourages student participation and involvement in all aspects of residential life. The residential community is supported and structured to provide an environment to support student academic achievement.
For assistance and initial contact go to
Student Central
Email: ask@csu.edu.au (mailto:ask@csu.edu.au) (mailto:ask@csu.edu.au)
Phone: 1800 ASK CSU (1800 275 278)
Phone from outside Australia: + 61 2 6933 7507
Career Development
Career Development (http://student.csu.edu.au/study/careers) includes a range of services, from first through to the final year of study, which support students’ self-assessment, awareness of opportunities, improvements to decision making, and gaining the necessary skills for making successful transitions post-study. This support is available face to face, via telephone and online.
Distance Education Outreach Team
Assistance for students studying by distance education with Charles Sturt University.
The DE Outreach Team is available to all CSU students studying by Distance Education.
We can assist you with:
Your orientation to CSU and DE study;
Study skills;
Preparing assignments;
Time management;
Online learning, and
Any other questions you may have about studying by DE at CSU.
We provide these services in a number of different ways including:
Outreach sessions to locations around Australia including group and individual sessions;
Advice and support via phone, email, and Skype;
Preparing assignments;
Online workshops;
Regional Study Centres, and
Online resources and social media.
Find us at:
http://student.csu.edu.au/study/de-outreach https://www.facebook.com/DistanceEDatCSU
Session 2 2015
Faculty of Business
School of Computing and Mathematics Internal Mode
Subject Overview
This subject aims to provide a solid grounding in database management theory and application, and its place within the implementation of computer based applications. There will be an emphasis on conceptual modeling to design the database that is implemented and queried using Structured Query Language (SQL).
Learning outcomes
On successful completion of this subject, you should
be able to apply database theory to the design and implementation of relational databases; be able to analyse and model business database requirements using Entity Relationship Diagrams (EDR);
be able to analyse a database design and apply normalisation theory and techniques; be able to implement a database design using Structured Query Language (SQL); be able to explain the use of transaction processing, security and database integrity in relation to relational databases.
Lecturer Details
Subject Coordinator Rajasekaran Lakshmiganthan Email rlakshmiganthan@studygroup.com Phone To be advised.
Campus To be advised.
Building/Room number To be advised.
About your lecturer
Lecturer Name: Dr Sarwar Tapan
Lecturer Email Address: STapan @studygroup.com (mailto:MBaron@studygroup.com)
Sarwar Tapan obtained PhD in Computer Science degree from La Trobe University, Melbourne, Australia in 2013 on Data Mining. His PhD research focused on investigating advanced computational approaches for mining subtle regulatory motifs in DNA sequences. He received Master of Science degree in Cognitive Sciences with major in Artificial Intelligence from University Malaysia Sarawak, Malaysia in 2008 and Bachelor of Computer Science degree from University of Wollongong, Australia in 2004. His current research area includes data mining, machine learning, cluster analysis, fuzzy-systems, data visualization and Bioinformatic topics with emphasis on Self-Organizing Maps ( SOM)-based approaches for regulatory motif discovery in the promoters of co-regulated genes. His teaching interest includes data mining, computational intelligence, database systems and other computer science and IT subjects.
Learning, Teaching and Support Strategies
Class times and location
Lecture 1: Tuesdays 5.00pm-8.00pm, Room 3.01 & 3.02
Lecture 2: Wednesdays 9.00am-12.00pm, Room 3.01 & 3.02
Compusory workshop or Residential School
There is no compulsory workshop or residential school for this subject.
How to contact your lecturer
Any questions concerning the teaching of this subject can be made by contacting your Subject Lecturer.
Dr Sarwar Tapan
Email : STapan @studygroup.com (mailto:MBaron@studygroup.com)
Email is the best option. Please send a brief message regarding the issue and include the subject name and code in your email –it really helps to know which class you belong to, before I respond to your query. If you prefer to phone me that is fine, but please leave a message if I am not there at the time – I will give you a call back as soon as I can.
How you are expected to engage with the subject
All of your subject materials are available on the Interact site under the Topics link in the left hand side menu. I suggest that for each topic you read the learning objectives carefully, read the overview, have a quick skim of the text and then watch the interactive tutorial. Once you have got a feel for what the topic is about try and make a good set of notes under each of the topic review questions in that topic. You can do this by watching the tutorial and consulting the text again in a more considered way. These questions have been designed to give you focus in the topic, so it really helps to prepare a useful set of answers to them.
In this subject there are also lots of opportunities for you to engage with me, with your peers and with the subject. I will be holding 12 regular sessions where we can discuss content issues and assessment items. As part of your assessment in this subject you are required to work alone for all the assessment items.
It is helpful to have a small task to complete early in the session, so that you have a focus in the subject from the very first day, and so I have set a small assessment item in week 4, as part of your assessment. If you don’t complete the assessment, I may contact you by phone or email to have a chat about study and if there are any issue that I can help with.
The study guide and/or subject materials for this subject have been written specifically to guide you through the sections (and questions) of the prescribed textbook relevant to each topic.
You should check the Interact Site at least weekly for postings, announcements, lecture information and other resources that will assist your studies or additional information and resources vital to your success in the subject.
Studying at university does not mean studying alone. Take advantage of collective wisdom and post your questions to the subject forum.
Use the subject schedule to plan your studies over the session.
The first assessment task in this subject is designed to identify students who are not engaged in the subject and are therefore at risk of failure or withdrawal
Information on effective time management is available on the CSU Learning Support website via the following link: student.csu.edu.au
Visit the Learning Support website for advice about assignment preparation, academic reading and note taking, referencing, effective time management and preparing for exams at: student.csu.edu.au You can also contact an adviser through Student Central on the following number: 1800 275 278 (or +61 2 6933 7507 from outside Australia).
Library services
You can find on the Library Services web site full details of how we can help you find books, articles, Australian and international databases, full-text newspapers and journals, electronic reference collections as well as links to other libraries and their catalogues:
The Library website provides access to print and online material, such as books, reports, journals, articles, dissertations, newspapers, and other reference tools. You will also find guides and assistance to help you use the Library's resources. http://www.csu.edu.au/division/library/
You can find Library Services on both the CSU website and the SGA library catalogue website including access to a wide range of electronic books, electronic journals, as well as textbooks available for loan in the Darlinghurst campus library. You can also access reports, journals, articles, dissertations, full text newspapers, and online reference resources (e.g. ABS statistics, Australian standards, encyclopaedias, dictionaries), as well as links to other libraries and their catalogues:
http://aleph.unilinc.edu.au/sga - SGA Melbourne library catalogue including electronic books and electronic journals online.
http://www.csu.edu.au/division/library/ - CSU Library Services including Primo Search catalogue, online tutorials and video tutorials in research skills, finding articles for assignments, topic analysis, Endnote referencing program and many other online library services to help you successfully complete your assignments for all CSU courses.
http://trove.nla.gov.au/ - Powerful search engine from National Library of Australia to access many different online resources on any subject from one search.
Contact Details for renewing loans, locating books and other information:
SGA Melbourne Library:
Marian Lees – Director, Library Services
Email: MLees@studygroup.com
Library Help
Friendly and quick assistance available. Ask for help finding information and navigating the library's extensive eResources.
http://www.csu.edu.au/division/library/help/ask
Online Tutorials
Learn how to:
•use Primo Search to find eReserve material and journal articles.
•identify appropriate sources of information and peer reviewed material, and evaluate resources.
•search journal databases and web resources for information for your assessments. http://www.csu.edu.au/division/library/how-to/watch-it
Bookmark your Subject Library Guide
Subject Library guides are a great way to get started with research. Each online guide is tailored to a specific area of study, outing how to research in your area and where to look for information.
http://libguides.csu.edu.au/
Academic learning support assistance
Visit the learning support website for advice about assignment preparation, academic reading and note-taking, referencing, and preparing for exams at: http://student.csu.edu.au/study
You may also contact:
Ann Ahn
Email: aahn@studygroup.com Phone: (03) TBA
For appointments, please see Reception.
Queries regarding the content of this subject should be directed to your subject lecturer.
Your workload in this subject
CSU Academic Senate policy states that a standard 8 point subject should require you to spend a total of 140-160 hours engaged in the learning and teaching activities. This means an average of 10 to 12 hours each week.
Text and Learning Materials
Prescribed text(s)
Students must have access to a copy of the prescribed textbook.
Coronel, C., Morris, S. (2015) Database Systems: Design, implementation and management (11th ed.). ISBN-13: 978-1-285-19614-5, Cengage Learning.
Assessment Information
Introduction to assessment
To protect the academic integrity of the subject, you may be asked to complete an additional test ( which may be verbal) if I or another member of the teaching staff have doubts that the work that you have submitted for an assessment item is your own. This test would be held within 4 weeks of the submission of the assessment.
Detailed information regarding:
Sample exam (for subjects with a formal exam)
Pass requirements
Grades
Presentation
Submissions
Extensions
Penalties for late submission
Assignment return
Resubmission Plagiarism
are included in Appendix 1.
* due date is the last date for assessment items to be received at the University
** applies only to assessment items submitted by the due date
Assessment item 1
Online Quiz 1
Value: 7 %
Due date: 14- Aug -2015
Return date: 04- Sep -2015
Submission method options Interact2 Test
Task
Complete the online quiz in Interact 2 Test Centre.
Rationale
This assignment will assess your knowledge of the fundamentals of database systems and data models. Marking criteria
This assignment is a series of multiple choice questions. Each correct answer will score 1 mark. Marks will not be deducted for incorrect answers.
Assessment item 2
Modelling
Value: 15 %
Due date: 28- Aug -2015
Return date: 18- Sep -2015
Submission method options Alternative submission method
Task
Overview of business case:
Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the available models online so to order they must visit one of the showrooms. A&B has been using an Excel spreadsheet to track their business activities; however, this has caused many redundancies and inefficiency.
With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly, they hired you to design a relational database to better track and record their operational data.
A&B business rules and instructions for creating your ERD:
1. A&B can get boats from several different manufacturers. Each manufacturer produces one or more different types of boats. Each and every type is produced by only one manufacturer. Every manufacturer is identified by a manufacturer code. The company name, street, city, state, postcode, phone number, and account number are kept in the system for every manufacturer. For each type, the type name (i.e. Paddle, Inflatable, Jet Ski, etc.) and purpose (i.e. fishing, day boating, etc.) are kept in the system.
Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule
2. Every type has one or more models. Every model is produced as part of a type. For each model, the model number, engine, length, beam, suggested retail price, A&B retail price and dry weight must be kept in the system.
Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1.
3. Each type’s models are stored in a specific warehouse. Each warehouse stores the models of only one type. Each warehouse is identified by a warehouse ID. For each warehouse address, postcode, phone number are kept in the system.
Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1 and business rule 2.
NOTE
Use Flow Chart Maker & Online Diagram Software (https://www.draw.io) to create your ERD
Use Crows Foot notations
Any M:N relationship is to be resolved to a 1:M relationship
Manually drawing the ERD is NOT acceptable.
Rationale
This assessment item is designed to test your understanding of basic database design and modelling concepts, and your ability to interpret business rules into an Entity Relationship Diagram.
Additionally, your ability to apply correct relationships, cardinalities, optionalities, and the use of Crows Foot modelling notations are tested.
Marking criteria
The marking criteria for this assignment is:
Task HD DI CR PS
Create an The ERD accurately The ERD The ERD accurately The ERD
ERD that identifies and correctly accurately identifies and correctly identifies represents shows all entities, PKs, identifies shows most entities, and shows the entities, attributes, relationships, and correctly PKs, attributes, but some attributes, associative entities (if shows all some of the entities, PKs, the applicable), cardinalities entities, PKs, relationships, associative attributes, relationshipsand optionalities attributes, entities (if applicable), but most of
between relationships,cardinalities and the entities, and and optionalities are relationships, the associative incorrect cardinalities cardinality entities (if and and applicable) optionalities optionality but some of are incorrect
of each the
relationship cardinalities
that are and
described by optionalities
the three are incorrect business rules
Assessment item 3
Normalisation
Value: 15 %
Due date: 11- Sep -2015
Return date: 02- Oct -2015
Submission method options Alternative submission method
Task
Using Table 1: GRADE REPORT relation above
1. Draw a dependency diagram to show the functional dependencies in the relation
2. Decompose GRADE REPORT into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints
NOTE
Manually drawing the dependency diagram or the relational schema is NOT acceptable.
Rationale
1 . This assessment item is designed to test your understanding of more advanced database design, your ability to use an iterative approach to modelling, and to examine data problems due to redundancy. 2 . Specifically you are required to apply the normalisation process to existing data in order to minimise redundancies and data anomalies.
Marking criteria
The marking criteria for this assignment are shown below:
Task HD DI CR PS
Draw a The dependency The dependency The dependency The dependency diagram diagram diagram identifies dependency diagram to show accurately accurately and shows most diagram the functional identifies and identifies and PKs and some identifies dependencies in correctly shows correctly shows functional, partial, and shows the relation all PKs and all all PKs and most and transitive few PKs and
functional, partial, functional, partial, dependencies few
and transitive and transitive functional, dependencies dependencies partial, and
transitive dependencies
Decompose The set of 3NF The set of 3NF The set of 3NF The set of
GRADE relations relations relations identifies 3 NF
REPORT into a accurately accurately and shows most relations set of 3NF identifies and identifies and PKs and some of identifies relations correctly shows correctly shows the relevant and shows all PKs and all the all PKs and most attributes few PKs and relevant attributes of the relevant few of the
attributes relevant
attributes
Draw a relational The relational The relational The relational The schema for your schema accurately schema accurately schema identifies relational 3NF relations and identifies and identifies and and shows some schema show the correctly shows correctly shows of the referential identifies
referential all of the most of the integrity and shows integrity referential referential constraints few of the constraints integrity integrity referential constraints constraints integrity
constraints
Assessment item 4
Online Quiz 2
Value: 8 %
Due date: 25- Sep -2015
Return date: 16- Oct -2015
Submission method options Interact2 Test
Task
Complete the online quiz in the Interact 2 Test Centre.
Rationale
This assignment will assess your knowledge of business requirements, database design and normalisation.
Marking criteria
This assignment is a series of multiple choice questions. Each correct answer will score 1 mark. Marks will not be deducted for incorrect answers.
Assessment item 5
Query and update databases using SQL
Value: 15 %
Due date: 09- Oct -2015
Return date: 30- Oct -2015
Submission method options Alternative submission method
Task
NOTES
This assignment encourages you to use SQLite to complete the tasks listed below.
The instructions listed below relate to SQLite.
For guidance on how to install SQLite, watch this short YouTube video:
https://www.youtube.com/watch?v=YZQuQ6jael8
For guidance on how to create tables using SQLite, watch this short YouTube video:
https://www.youtube.com/watch?v=Ev2JnjavvmE
You are welcome to use MySQL . The instructions for using MySQL will be placed in the Students Resources Folder.
To use other packages, please seek the approval of your subject coordinator. Typing the SQL statements or the results is NOT acceptable.
Instructions
From Resources under Main Menu in Interact 2 go to Students Resources Folder
Copy sqlite3.exe and cmd.exe files from the Students Resources Folder into a folder in your machine
Copy a5.txt from the Students Resources Folder into the folder in your machine where your SQLite file is located
Open a5.txt in Notepad
Replace your studentid in line .output your studentid .txt in a5.txt with your actual studentid i.e.
for example 45446667.txt
From the Command Prompt type sqlite3.exe your studentid.db
Note: From the Command Prompt call the folder in your machine where your SQLite file is located before you type sqlite3.exe yourstudentid.db
At the SQLite Command Line type .read a5.txt [to create the tables you will use to answer this assignment’s questions]
At the SQLite Command Line type .quit
Using WordPad open your studentid .txt [to check the tables you created exist]
From the Command Prompt type sqlite3
At the SQLite Command Line type .open your studentid.db
At the SQLite Command Line type .headers on
At the SQLite Command Line type .mode column
Write and run SQL statements to complete the following tasks
1. Show all the details of the products by v_code 21344
2. Locate the record in the vendor table that does not have a value for the attribute V_STATE 3. Find the customers whose balance is greater than 200 but less than 300.
4. What is the max balance?
5. Show the names of the customers for whom we have invoices.
6. Show the CUS_CODE of the customers for whom we DO NOT have invoices.
7. Show the names of the customers for whom we DO NOT have invoices.
8. Find out how many times a customer generated an invoice.
9. List the names of the customers and how many times a customer generated an invoice.
10. Add a new attribute (field) credithistory varchar(6) to the customer table.
11. Update credithistory for customer '10011' to 'Bad'.
12. Delete the employee Leighla Genkazi from the EMP table.
You are required to submit:
1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file
2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file
Rationale
This assignment will assess your knowledge and ability to use SQL to query database tables and update them. It will also test your ability to write both simple and complex queries and run those queries to return the requested data.
Marking criteria
The following criteria will be used to assess Assignment 5:
Task HD DI CR PS
Write and run The SQL The SQL The SQL The SQL
SQL statements to statements retrieve statements retrieve statements retrieve statements complete tasks or update the or update the or update the retrieve or
1-12 above required required required update the
information for all information for information for required assignment tasks most of the some of the information
Assessment item 6
Final Exam
Value: 40 %
Date: To be advised
Duration: 2 hours 10 minutes
Submission method options
N/A - submission not required/applicable
Rationale
Covering all topics, this assessment task has been designed to assess your ability to:
be able to apply database theory to the design and implementation of relational databases; be able to analyse and model business database requirements using Entity Relationship Diagrams;
be able to analyse a database design and apply Normalisation theory and techniques; be able to implement a database design using Structured Query Language (SQL); be able to query a database using SQL.
Requirements
The examination consists of:
Multiple choice questions, short and long answer questions.
The examination is a Closed book examination.
All questions must be answered.
Marking criteria
Question 1 has a similar criteria to Assignment 1 and 4 Question 2 has a similar criteria to Assignment 2.
Question 3 has a similar criteria to Assignment 3.
Question 4 has a similar criteria to Assignment 5.
Material provided by the University
Answer Booklets (1 X 12 page)
General Purpose Answer Sheet GPAS-200R
Material required by the student
Writing implements, including a 2B pencil and an eraser.
Any calculator allowed, including programmable calculators (hand held, no printer). iPads and other hand-held computers are not accepted as calculators.
Appendix 1 Assessment Information
Sample exam
Note: A sample exam paper (with solutions) which is indicative of the structure of the final exam will be provided in the Students Resources Folder of this subject's CSU Interact 2 site.
Pass Requirements
You must obtain at least 50% in both the examination and the total mark in order to pass this subject. You must pass the exam to pass the subject.
Grades
Final grades for this subject are awarded by the Business Faculty Assessment Committee in accordance with the University's Assessment Regulations. (See current Academic Regulations at https://policy.csu.edu.au/view.currect.php?id-00301#s3
(https://policy.csu.edu.au/view.currect.php?id=00301#s3)). University's Assessment Policy: Coursework Subjects (https://policy.csu.edu.au/view.current.php?id=00301).
Your final grade for the subject as a whole will be based on the grading scale outlined in the CSU Assessment Policy: Coursework Subjects https://policy.csu.edu.au/view.current.php?id=00301 ( https:// policy.csu.edu.au/view.current.php?id =00301).
HD High Distinction 85% - 100%
An outstanding level of achievement in relation to the assessment process.
DI Distinction 75% - 84%
A high level of achievement in relation to the assessment process.
CR Credit 65% - 74%
A better than satisfactory level of achievement in relation to the assessment process.
PS Pass 50% - 64%
A satisfactory level of achievement in relation to the assessment process.
FL Fail 0 - 49%
An unsatisfactory level of achievement.
The percentages specified above should be viewed only as guidelines for the award of final grades.
The Faculty has an obligation to ensure that grades are equitable across different cohorts of the same subject offering and will undertake appropriate moderation processes to ensure that grades are awarded consistently in accordance with the University’s Moderation Policy.
For further information please consult the CSU Assessment Policy: Coursework Subjects http://policy.csu.edu.au/view.current.php?id=00301
Presentation
The following points are a general guide for presenting assessment items.
Assessment items should be typed.
Use 1.5 spacing.
Use a wide left margin. Markers need space to be able to include their comments.
Use a standard 12pt font such as Times New Roman, Calibri or Arial.
Left- justify body text.
Include a separate title page with your name, student number, subject code, assessment
number and assessment question. Include class time and tutor’s name if applicable.
Number your pages (except the cover page).
Use a header or footer with your name and student number on each page.
Always keep a copy of your assessments. Both a hard copy and an electronic copy. Most importantly, always use your spelling and grammar checker, but remember that this does not pick up all errors. You must still manually and carefully edit your work.
Submission
Online Submission
Submit your assignments using EASTS
Extensions
In order to ensure that other students who hand their assignments in on time are not disadvantaged, and to enable me to comply with the requirement to return assignments to the class within 15 working days, the following rules about extensions will be strictly enforced:
1. Extensions cannot be granted for on-line tests, as these have to be done within a specific time frame, after which the answers are released to the class automatically.
2. Computer problems (such as the speed of your computer and the time it may take you to upload assignments onto EASTS) and normal work-related pressures and family commitments do not constitute sufficient reasons for the granting of extensions.
3. If it becomes obvious that you are not going to be able to submit an assignment on time because of an unavoidable problem, you must submit your request for an extension to the Subject Coordinator in writing (email is acceptable) prior to the due date.
Requests for extensions will not be granted on or after the due date so you must make sure that any extension is requested prior to the day on which the assignment is due.
You are expected to do all you can to meet assignment deadlines. Work and family- related pressures do not normally constitute sufficient reasons for the granting of extensions or incomplete grades.
4. If you apply for an extension, you may be asked to email your lecturer on what you have done so far on the assignment.
5. You must be able to provide documentary evidence (such as a certificate from a doctor or counsellor) justifying the need for an extension as soon as practicable - but please note that if the circumstances giving rise to the request for an extension arise on a day when you cannot get documentary evidence, you must still apply for the extension before the due date and submit the documentary evidence afterwards.
6. Given the tight deadlines involved in returning assignments to students and putting feedback on Interact, the maximum extension granted generally will be seven (7) days from the due date.
7. Assignments received more than 10 days after the due date or extension date will not be marked unless the staff member decides otherwise. Items received late will be penalised at 10% of the mark available for the assessment item per day it is late (see below).
8. Note that for purposes of measuring lateness, the 'day' begins just after 00.00 hrs AEST - so an assignment received after midnight of the due date will be penalised 10% for lateness. This rule will be applied to all students uniformly.
Penalties for Late Submission
The Faculty of Business has determined that the penalty for the late submission of an assessment task ( without obtaining the Subject Coordinator's approval for an extension) will be :
10% deduction per day, including weekends, of the maximum marks allocated for the assessment task, i.e. 1 day late 10% deduction, or 2 days late 20% deduction.
An example of the calculation would be:
Maximum marks allocated = 20
Penalty for one day late = 2 marks (so, a score of 18/20 becomes 16/20 and a score of 12/20 becomes 10/20).
If an assignment is due on a Friday but is not submitted until the following Tuesday, then the penalty will be four days (40% deduction or 8 marks in the example above).
Submissions more than 10 days late will be acknowledged as received but will not be marked.
Assignment Return
You should normally expect your marked assignment to be returned to you within three weeks of the due date, if your assignment was submitted on time. If you submitted your assignment on time but not received it back by the return date, you should make enquiries in the first instance to the subject coordinator.
Resubmission
Under normal circumstances resubmission of assessment items will not be accepted for any of the assessments required in this subject.
Assessment Requirements
Assessment at CSU is criterion-referenced and standards-based where students' work is assessed against stated criteria that reflect the expected learning outcomes of the course and subject. Subjects that use a satisfactory/unsatisfactory grading scale will have this clearly identified within the Subject Outline.
For further information please consult the University's Assessment Policy: Coursework Subjects ( https://policy.csu.edu.au/view.current.php?id =00301).
Referencing
Referencing is an important component of academic writing. All CSU assessment tasks should be appropriately referenced. The specific details of the referencing requirements are included in each assessment task description.
For further information and assistance with referencing refer to http://student.csu.edu.au/study/referencing-at-csu
Plagiarism
Charles Sturt University expects that the work of its students and staff will uphold the values of academic honesty and integrity. The Guide to Avoiding Plagiarism is located at:
http://student.csu.edu.au/study/plagiarism. This is an important resource that will help you understand these values and apply them in practice. You should familiarise yourself with these requirements and ensure that all assessments submitted by you are your own work, have not been submitted elsewhere and comply with the University's requirements for academic integrity.
The University has purchased Turnitin software. This software has two functions, a pre-emptive education function which students may use to check their own work prior to submission, and a plagiarism detection function which academics may use to check the student’s work for improper citation or potential plagiarism. Use by students is optional and is not a prerequisite for submission.
You are encouraged to check your work for originality prior to submission. You can register with Turnitin to create a Student Account under the CSU Turnitin Licence at http://www.turnitin.com/login_page.asp. Further information on how to use Turnitin is provided within the Guide to Avoiding Plagiarism: http://student.csu.edu.au/study/plagiarism/checking.
Appendix 2 CSU Learning and Teaching Policies
Minimum standards of consultation
According to the Academic Communication with Students Policy
( https://policy.csu.edu.au/view.current.php?id=00139#s3) (clause 8 in section 3), when a student directly contacts a teaching staff member for information, advice and/or support (except in online teaching spaces) the teaching staff member will respond to the request within 3 working days. Clauses
19-21: Use of Online Discussion and Communication Technologies states that for each subject, the Subject Coordinator will be expected to set up and/or activate an appropriate asynchronous communication technology and respond at least once a week to student messages that request information and advice.
The Higher Degree by Research Candidates Policy - Academic Communication
( https://policy.csu.edu.au/view.current.php?id=00283) states that a Communication Plan, a documented agreement between a HDR candidate and his/her supervisory team that establishes common understandings and expectations of how and when communication will occur during the candidature will be developed. The Plan should then be reviewed regularly throughout candidature.
University Policies and Regulations
Academic matters are defined by, and are subject to, Charles Sturt University policies and regulations. Your Subject Outline should be read in conjunction with all such academic regulations and policies, as some of these may affect the outcome of your studies.
Academic Progress Regulations
The University requires each student to progress through his or her course at a rate that will enable him or her to complete the course in a specified maximum time. This maximum time is intended to ensure the currency of the knowledge within the course and therefore professional suitability of graduates. Failure to complete within the specified maximum time shall lead to the expiry of a student?s enrolment in the course. The University believes that all students have a right to know in advance of study in their course exactly what constitutes satisfactory progress in that course. To this end the University will specify a maximum completion time for each course, and will also provide support to students identified as being at risk of exclusion.
The Academic Progress Policy (https://policy.csu.edu.au/view.current.php?id=00250) sets out the requirements and procedures for satisfactory academic progress, for the exclusion of students who fail to progress satisfactorily and for the termination of enrolment for students who fail to complete in the maximum allowed time.
Variations to Subject Outlines
Should it be necessary to change the content of the Subject Outline during a teaching session, it will be done in consultation with the Head of School and other support services of the University. You then will be notified of the changes in writing by the subject coordinator.
Variations to Assessment
Should it be necessary to vary the assessment in this subject, you will be notified in writing by the Subject Coordinator, or Subject Convenor where one is appointed. The variations to assessment include variations to the assessment tasks and/or assessment procedures for assignments, examinations and any other assessment task published in the Subject Outline. The variations will be communicated only after the Subject Coordinator or Subject Convenor has obtained approval from their Head of School. The overriding principle is that such changes will not disadvantage students and is made in accordance with the Subject Outlines Policy (https://policy.csu.edu.au/view.current.php?id=00267).
Evaluation of Subjects
It is University policy that all subjects are evaluated every time that they are offered. The University's Division of Student Learning administers the Subject Experience Survey through CSU's online evaluation system. Staff in the faculties and schools value your feedback very highly and take account of your comments when reviewing learning and teaching in each subject.
If you are interested in the details of any enhancements to this subject as a result of the latest survey, please contact the subject coordinator. Students can also view overall results for subjects via the Student Subject Experience Survey Results Portal: https://student.csu.edu.au/home/subject-experience-survey-results
Surveys for each of the subjects you are enrolled in for this session will be available for you to complete for a period of 4 weeks from the last week of the teaching session. An email message will alert you to the availability of the surveys online.
Please complete the subject evaluation by following the link:
https://P8.courseval.net/etw/ets/et.asp?nxappid=CS2&nxmid=start (http:// https://P8.courseval.net/etw/ets/et.asp?nxappid=CS2&nxmid=start)
Individual subject results are only reported to the Subject Coordinator and Heads of Schools after grades have been submitted for each teaching session (except where subjects have one student the results are not reported to staff).
Special Consideration
Academic regulations provide for special consideration to be given if you suffer misadventure or extenuating circumstances during the session (including the examination period) which prevents you from meeting acceptable standards or deadlines.
Applications for special consideration must be submitted in writing and include supporting documentary evidence. Such applications should be sent to the Student Administration Office.
For further information about applying for special consideration please refer to Special Consideration Policy (https://policy.csu.edu.au/view.current.php?id=00298).
Assessment Regulations
The assessment practices of all University subjects are conducted in accordance with the University?s Assessment Policy: Coursework Subjects (https://policy.csu.edu.au/view.current.php?id=00301).
Academic Conduct
The University expects that you, as a student, will be honest in your studies and research and that you will not do anything that will interfere with or frustrate the studies and research of other students. In particular, you are expected to:
acknowledge the work of others in your assignments and other assessable work; not knowingly allow others to use your work without acknowledgment;
report honestly the findings of your study and research; and use only permitted materials in examinations.
Details of expected academic conduct are provided in:
the Student Academic Misconduct Policy
( https://policy.csu.edu.au/view.current.php?id=00279);
the Academic Progress Policy (https://policy.csu.edu.au/view.current.php?id=00250);
Students are also expected to be responsible in the use of University facilities and resources and to abide by University rules concerning the Library and electronic resources.
the Library Rule (https://policy.csu.edu.au/view.current.php?id=00280); and the Computing and Communications Facilities Use Policy ( https://policy.csu.edu.au/view.current.php?id =00145).
Copies of the Rule of the Library and Code of Conduct for Users of Electronic Facilities can also be obtained from the Library or the Division of Information Technology (DIT) Service Desk.
Penalties for breaching the above Rule and Policies include suspension or exclusion from the University.
Students also have expectations of the University and of other students in the cooperative endeavour of studying. Details of these expectations are provided in the Student Charter ( https://policy.csu.edu.au/view.current.php?id =00268).
Residential school
There is no residential school for this subject.
Subject Outline as a Reference Document
This Subject Outline is an accurate and historical record of the curriculum and scope of your subject. The Subject Outline Policy (https://policy.csu.edu.au/view.current.php?id=00267) (at clause 16(f)) requires that you retain a copy of the Subject Outline for future use such as for accreditation purposes.
Appendix 3 Support Services
Student Central
Student Central is the first point of contact for currently enrolled students to access all non-teaching services. Student Central liaises closely with Divisions and Schools to ensure the timely and accurate resolution of student enquiries.
You may direct your enquires in person to Student Central staff situated within the Learning Commons found on campus at Albury-Wodonga, Bathurst, Dubbo, Orange, and Wagga Wagga.
You may also contact Student Central through:
ask@csu.edu.au (mailto:ask@csu.edu.au)
1800 ASK CSU (1800 275 278)
Phone from outside Australia: + 61 2 6933 7507
Information on Your Library Services
Finding Information
CSU Library provides you with free access to over 600,000 books and 50,000 journals, and much more. Get an introduction to your library with the Library Orientation Toolbox ( http://www.csu.edu.au/division/library/find-info/toolbox ).
Primo Search
Finding the resources you need is easy with Primo Search
( http://primo.unilinc.edu.au/primo_library/libweb/action/search.do?dscnt=1&dstmp=1328694476534& Search most of the Library’s collections, including online resources, print publications and CSU research. Plus, you can easily place loan requests, view your current loans, and renew items online.
Online Resources
You’ll find journal databases, eBook collections, and other useful online information sources listed under Key Resources (http://student.csu.edu.au/library/find-information).
eReserve
Some subject readings may be held in eReserve
( http://student.csu.edu.au/library/find-info/search-reserve). Online access is encouraged to help reduce CSU’s carbon footprint, however a printed copy of eReserve subject readings can be purchased through CSU Print (http://www.csu.edu.au/division/student-learning/csu-print/home).
Borrowing
Your borrowing privileges depend on your enrolment. Visit Information for Students
( http://student.csu.edu.au/library/help/information-for-students) to find out what you are eligible for. The Library FAQs (http://www.csu.edu.au/division/library/how-to/faq) have more information on borrowing and access to resources.
Need help?
CSU Library staff are available to answer your questions by phone, Live Chat, email, forum, or in person. See Ask a Librarian (http://student.csu.edu.au/library/contacts/ask-a-librarian) for more information.
Keep up to date with what is happening in your Library through Facebook, Twitter and our blog.
CSU Library Facebook (http://www.facebook.com/CSULibrary) CSU Library Twitter
(http://twitter.com/CSU_Library) CSU Library Blogs
( http://student.csu.edu.au/library/about-your-library/library-blog )
Academic Learning Assistance
CSU’s Learning Skills Advisers can help you develop the skills you need to succeed in your studies.
Learning Skills advisers can help you with:
Understanding and preparing assignments
Study skills
Exam preparation
Time management
Notetaking and
Referencing and avoiding plagiarism
Learning Skills also have specialists in English Language, online learning and maths and statistics who can support your development in these areas.
Students can take advantage of online resources and workshops, forums and individual appointments either in person, or online. More information is available at student.csu.edu.au/study ( http://student.csu.edu.au/study ).
STUDYLINK provides access to a variety of short, non-award subjects in preparation for university study. Subjects are available throughout the year through flexible, online delivery, and each is designed to help you gain confidence, skills and knowledge for your university studies ( http://www.csu.edu.au/student/studylink/).
Student Support - http://student.csu.edu.au/support
A wide range of services are provided to support your student academic experience. Services are available on campus with relevant services also available via telephone and online. Services provided include:
Orientation
Student mentoring
Scholarship and financial assistance
Counseling support and referral
Academic appeals and legal advice referral
Disability, welfare and equity support and referral
Health and wellbeing
Social and recreational activities
Graduation
Indigenous student support
International student support
Residential Student Support - http://student.csu.edu.au/campus/residences/residential-advisors
The Residential Support Scheme operates across all campuses to provide for the pastoral care and welfare of residents and actively encourages student participation and involvement in all aspects of residential life. The residential community is supported and structured to provide an environment to support student academic achievement.
For assistance and initial contact go to
Student Central
Email: ask@csu.edu.au (mailto:ask@csu.edu.au) (mailto:ask@csu.edu.au)
Phone: 1800 ASK CSU (1800 275 278)
Phone from outside Australia: + 61 2 6933 7507
Career Development
Career Development (http://student.csu.edu.au/study/careers) includes a range of services, from first through to the final year of study, which support students’ self-assessment, awareness of opportunities, improvements to decision making, and gaining the necessary skills for making successful transitions post-study. This support is available face to face, via telephone and online.
Distance Education Outreach Team
Assistance for students studying by distance education with Charles Sturt University.
The DE Outreach Team is available to all CSU students studying by Distance Education.
We can assist you with:
Your orientation to CSU and DE study;
Study skills;
Preparing assignments;
Time management;
Online learning, and
Any other questions you may have about studying by DE at CSU.
We provide these services in a number of different ways including:
Outreach sessions to locations around Australia including group and individual sessions;
Advice and support via phone, email, and Skype;
Preparing assignments;
Online workshops;
Regional Study Centres, and
Online resources and social media.
Find us at:
http://student.csu.edu.au/study/de-outreach https://www.facebook.com/DistanceEDatCSU
Looking for answers ?
Recent Questions
Program: Master of Information SystemsAssessment 1: Portfolio 1 (Session 2 Topic: Input, Processing andOutput) Semester 2: Block 8-2024Course Code: MBIS4003 Course Title: Software Development Total Marks:...AssessmentAssessment item 2—Assignment 2Due date 11:45pm on Sunday, 24Nov.2024Weighting 35%Length Not applicableObjectivesThis assessment item relates to the unit learning outcomes numbers 1, 2 and 3 as...Plan, construct and write a long-form essay on a particular area of media research that interests you. Using an established theoretical framework, explain how your research offers new insights into the...DescriptionIn this assessment, you are required to demonstrate that you understand how an Older Adult can develop mental health problems associated with cognitive decline leading to cognitive impairment...School of Engineering, Design and Built EnvironmentENGR7008 Fire Engineering Design and AssessmentAssignment 4: Peer Review of Fire Engineering ReportASSIGNMENT 4PEER REVIEW OF A FIRE ENGINEERING REPORTSee...Structural Analysis Etask 5The aim of this assessment task is to evaluate the appropriate use of the Force Method and Moment Distribution Method for structural analysis• Please download the eTask4 from...Purpose:The purpose of this task is for the student to demonstrate how to create a holistic plan of care that is person-centred, trauma-informed, and recovery-oriented in focus.Description:In this written...Show All Questions