Creating a data model, ER diagram, Converting the relation to BCNF, for this you have to show the normalization starting from 1 NF, Creating tables, add constraints (PK, FK), etc. More questions in the word file below, 2 case studies to chose from
KING’S OWN INSTITUTE* Success in Higher Education
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 All information contained within this Subject Outline applies to all students enrolled in the trimester as indicated.
1. General Information 1.1 Administrative Details
Associated HE Award(s) Duration Level Subject Coordinator
Bachelor of Information Technology (BIT) 1 trimester Level 2 Mr Utpal Nanavati utpal[email protected] Consultation: via Moodle or by appointment.
1.2 Core / Elective Core subject in the BIT 1.3. Subject Weighting
Indicated below is the weighting of this subject and the total course points.
Subject Credit Points Total Course Credit Points
4 BIT (96 Credit Points)
1.4 Student Workload
Indicated below is the expected student workload per week for this subject
No. timetabled hours/week* No. personal study hours/week**
Total workloa d hours/w
4 hours/week containing 1 x 2 hour Lecture 1 x 2 hour Tutorial
6 hours/week 10 hours/week
* Total time spent per week at lectures and tutorials ** Total time students are expected to spend per week in studying, completing assignments, etc. *** Combination of timetable hours and personal study. 1.5 Mode of Delivery On-campus 1.6 Pre-requisites ICT 103 Systems Analysis and Design 1.7 General Study and Resource Requirements
o Dedicated computer laboratories are available for student use. Normally, tutorial classes are conducted in the computer laboratories.
o Students are expected to attend classes with the requisite textbook and must read specific chapters prior to each tutorial. This will allow them to actively take part in discussions. Students should have elementary skills in both word processing and electronic spreadsheet software, such as OFFICE 365 or MS Word and MS Excel.
o Computers and WIFI facilities are extensively available for student use throughout KOI. Students are encouraged to make use of the campus Library for reference materials.
o Students will require access to the internet and email. Where students use their own computers, they should have internet access. KOI will provide access to required software.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 1 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Software Resource requirements specific to this subject: Office 365, MS Imagine, SQL Server 2017.
2. Academic Details 2.1 Overview of the Subject
This subject will provide the student with an overall understanding of database development, concepts and theory. Students will learn to design and build a database from data analysis, normalisation, mapping a specific database model. The relational model is emphasised and introduced using structured queried language (SQL) for creating and manipulating databases in both MS Access and SQL Server environments. Assignment work includes the analysis, design, and implementation of a database using SQL queries in SQL Server environment. 2.2 Graduate Attributes for Undergraduate Courses Graduates of Bachelor courses from King’s Own Institute (KOI) will be able to demonstrate the attributes of a successful Bachelor degree graduate as outlined in the Australian Qualifications Framework (2nd edition, January 2013). Graduates at this level will be able to apply an advanced body of knowledge across a range of contexts for the purposes of professional practice or academic scholarship, and as a pathway for further learning. King’s Own Institute’s key generic graduate attributes for a Bachelor’s level degree are summarised below:
Across the course, these skills are developed progressively at three levels:
o Level 1 Foundation – Students learn the basic skills, theories and techniques of the subject and
apply them in basic, standalone contexts o Level 2 Intermediate – Students further develop the skills, theories and techniques of the subject
and apply them in more complex contexts, and begin to integrate this application with other subjects. o Level 3 Advanced – Students demonstrate an ability to plan, research and apply the skills, theories
and techniques of the subject in complex situations, integrating the subject content with a range of other subject disciplines within the context of the course.
KOI Bachelor Degree Graduate Attributes Detailed Description
Knowledge Current, comprehensive, and coherent and connected knowledge
Critical Thinking Critical thinking and creative skills to analyse and synthesise information and evaluate new problems
Communication Communication skills for effective reading, writing, listening and presenting in varied modes and contexts and for the transferring of knowledge and skills to others
Information Literacy Information and technological skills for accessing, evaluating, managing and using information professionally
Problem Solving Skills Skills to apply logical and creative thinking to solve problems and evaluate solutions
Ethical and Cultural Sensitivity Appreciation of ethical principles, cultural sensitivity and social responsibility, both personally and professionally
Teamwork Leadership and teamwork skills to collaborate, inspire colleagues and manage responsibly with positive results
Professional Skills Professional skills to exercise judgement in planning, problem solving and decision making
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 2 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
2.3 Subject Learning Outcomes
This is a Level 2 subject. On successful completion of this subject, students should be able to:
2.4 Subject Content and Structure Below are details of the subject content and how it is structured, including specific topics covered in lectures and tutorials. Reading refers to the text unless otherwise indicated. Weekly Planner:
Week (beginning)
Topic covered in each week’s lecture Reading(s)
Expected work as listed in Moodle
1 08 Jul
Introduction to DBMS: o history of database processing o emergence of relational model o post-relational developments o DBMS concepts o MS Access and SQL
Chapter 1 and Database History Article (See section 2.6)
Chapter 1 Discussion. Formative Not Graded Introduction to MS Access and SQL environments. Tutorial exercises
2 15 Jul
Introduction to Structured Query Language: o creating SQL statements o using SQL in MS Access o using SQL in SQL Server o Querying tables
Chapter 2 Activities, Database exercises – execute simple SQL queries in MS Access and SQL Server. Formative Not Graded. Tutorial exercises
3 22 Jul
Data modelling with the Entity- Relationship model: o purpose of a data model o the E-R model and diagrams o variations of the E-R model o entities and data modelling
process
Chapter 5 Activities, Data Modelling ERD exercises. VISIO and UML (Appendix C and D). Formative Not Graded. Tutorial exercises
Subject Learning Outcomes Contribution to Course Graduate Attributes
a) Explain the history and development of database technologies and the emergence of the relational database model and SQL.
b) Model business information requirements and produce a logical database design using entity relationship diagrams (ERD) and extended relationship diagrams (EERD).
c) Design, develop, test and prove the functionality of a database using MS Access and SQL.
d) Describe and carry out the necessary steps to develop an effective
physical database design
e) Formulate, write and execute SQL queries in an SQL Server environment.
f) Explain the main functions of database administration and data
warehousing.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 3 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
4 29 Jul
The relational model and normalisation: o terminology o characteristics of relationships o normal forms normalisation
categories
Chapter 3 Activities, Normalisation exercises on 1NF,2NF, 3NF and BCNF. Formative Not Graded Tutorial exercises Assessment 2 Quiz A
5 05 Aug
Database design using normalisation: o advantages and
disadvantages o normalising with SQL o common design problems
Chapter 4 Simple SQL Activities, normalisation and de- normalisation exercises. Formative Not Graded Tutorial exercises
6 12 Aug
Transforming data models into database designs: o purpose of database design o tables, entities,
primary/alternate keys o verify normalisation o create relationships o design for minimum cardinality
Chapter 6 Activities creating tables and relationship in SQL, Database Design exercises. Formative Not Graded Database Exercises from textbook
18 Aug 2019 –
25 Aug 2019 Mid trimester break
7 26 Aug
SQL for database construction and application processing: o using SQL scripts o Advanced SQL statements
Chapter 7 Chapter Activities complex SQL queries using join, union, sub-queries. Tutorial exercises Formative Not Graded
8 02 Sep
Database redesign: o the need for database
redesign o analysing existing databases o database backup and test
databases o making changes to tables,
columns, constraints, cardinalities, relationships
Chapter 8 Chapter Activities Testing database and query optimisation for database efficiency. Formative Not Graded Tutorial exercises Assessment 3 Quiz B.
9 09 Sep
Managing multiuser databases: o database administration o DBMS and application
security o database backup and
recovery o managing the DBMS and data
repository
Chapter 9 Tutorial exercises Chapter Activities Formative Not Graded
10 16 Sep
Managing databases with Microsoft SQL server: o installing the DBMS o using the DBMS utilities o creating a database o creating and running SQL
scripts o DBMS security
Chapter 10 Tutorial exercises Assessment 4 due – Report
11 23 Sep
The web server environment: o the web database processing
environment o database server access
standards o OBDC standard o web database processing with
PHP and NetBeans IDE o challenges and SQL injection
Chapter 11 Tutorial exercises SQL Server Project. Formative Not Graded Assessment 4 due – Presentation
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 4 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
attacks o the importance of XML
12 30 Sep
Big data, data warehousing and business intelligence systems: o business intelligence systems o reporting and data mining
systems o data warehousing and data
marts o components of a data
warehouses o OLAP and data mining o distributed databases o cloud computing o big data and the Not Only
SQL movement
Chapter 12 Discussion. Formative Not Graded. Tutorial exercises
13 06 Oct Study Review Week
14 14 Oct Final Exam Week
Please see Exam Timetable for exam date, time and location
15 20 Oct
Student Vacation begins Enrolments for T319 open
16 28 Oct
Results Released 29 Oct 2019 Certification of Grades 01 Nov 2019
T319 begins 04 Nov 2019 1
04 Nov Week 1 of classes for T319 Friday 01 Nov 2019 – Review of Grade Day for T219 – see Sections 2.6 and 3.6 below for more information.
2.5 Public Holiday Amendments Please note: KOI is closed on all scheduled NSW Public Holidays. T219 has one (1) public holiday (Labour Day) that occurs during this trimester. Classes scheduled for this public holiday (Calendar Class Dates) will be rescheduled as per the table below. This applies to ALL subjects taught in T219. Please see the table below and adjust your class timing as required. Please make sure you have arrangements in place to attend the rescheduled classes if applicable to your T219 enrolment. Classes will be conducted at the same time and in the same location as your normally scheduled class except these classes will be held on the date shown below.
Calendar Class Date Rescheduled Class Date
Monday 07 October 2019 (Week 13) Study Review Week
Not required
2.6 Review of Grade, Deferred Exams & Supplementary Exams/Assessments Review of Grade: There may be instances when you believe that your final grade in a subject does not accurately reflect your performance against the subject criteria. Section 8 of the Assessment and Assessment Appeals Policy (www.koi.edu.au) describes the grounds on which you may apply for a Review of Grade. If this happens and you are unable to resolve it with the Academic staff concerned then you can apply for a formal Review of Grade within the timeframes indicated in the following sections of this subject outline – Supplementary Assessments, 3.6 Appeals Process as well as the Assessment and Assessment Appeals
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 5 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Policy. Please ensure you read the Review of Grade information before submitting an application. Review of Grade Day: KOI will hold the Review of Grade Day for all subjects studied in T219 on
Friday 01 November 2019
Only final exams will be discussed as all other assessments should have been reviewed during the trimester. If you fail one or more subjects and you wish to consider applying for a Review of Grade you MUST attend the Review of Grade Day. You will have the chance to discuss your final exam with your lecturer, and will be advised if you have valid reasons for applying for a Review of Grade (see Section 3.6 below and Assessment and Assessment Appeals Policy). If you do not attend the Review of Grade Day you are considered to have accepted your results for T219. Deferred Exams: If you wish to apply for a deferred exam, you should submit an Application for Assignment Extension or Deferred Exam Form before the prescribed deadline. If you miss your mid-trimester or final exam there is no guarantee you will be offered a deferred exam. You must apply within the stated timeframe and satisfy the conditions for approval to be offered a deferred exam (see Section 8.1 of the Assessment and Assessment Appeals Policy and the Application for Assignment Extension or Deferred Exam Forms). In assessing your request for a deferred exam, KOI will take into account the information you provide, the severity of the event or circumstance, your performance on other items of assessment in the subject, class attendance and your history of previous applications for special consideration. Deferred mid-trimester exams will be held before the end of week 9. Deferred final exams will be held on two days during week 1 or 2 in the next trimester. You will not normally be granted a deferred exam on the grounds that you mistook the time, date or place of an examination, or that you have made arrangements to be elsewhere at that time; for example, have booked plane tickets. If you are offered a deferred exam, but do not attend you will be awarded 0 marks for the exam. This may mean it becomes difficult for you to pass the subject. If you apply for a deferred exam within the required time frame and satisfy the conditions you will be advised by email (to your KOI student email address) of the time and date for the deferred exam. Please ensure that you are available to take the exam at this time. Marks awarded for the deferred exam will be the marks awarded for that item of assessment towards your final mark in the subject. Supplementary Assessments (Exams and Assessments): A supplementary assessment may be offered to students to provide a final opportunity to demonstrate successful achievement of the learning outcomes of a subject. Supplementary assessments are only offered at the discretion of the Board of Examiners. In considering whether or not to offer a supplementary assessment, KOI will take into account your performance on all the major assessment items in the subject, your attendance, participation and your history of any previous special considerations. Students are eligible for a supplementary assessment for their final subject in a course where they fail the subject but have successfully completed all other subjects in the course. You must have completed all major assessment tasks for the subject and obtained a passing mark on at least one of the major assessment tasks to be eligible for a supplementary assessment. If you believe you meet the criteria for a supplementary assessment for the final subject in your course, but have not received an offer, complete the “Complaint, Grievance, Appeal Form” and send your form to
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 6 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
[email protected]. The deadline for applying for supplementary assessment is the Friday of the first week of classes in the next trimester. If you are offered a supplementary assessment, you will be advised by email to your KOI student email address of the time and due date for the supplementary assessment – supplementary exams will normally be held at the same time as deferred final exams during week 1 or week 2 of the next trimester. You must pass the supplementary assessment to pass the subject. The maximum grade you can achieve in a subject based on a supplementary assessment is a PASS grade. If you: o are offered a supplementary assessment, but fail it; o are offered a supplementary exam, but do not attend; or o are offered a supplementary assessment but do not submit by the due date; you will receive a FAIL grade for the subject. 2.7 Teaching Methods/Strategies Briefly described below are the teaching methods/strategies used in this subject:
o On-campus lectures (2 hours/week) are conducted in seminar style and address the subject content, provide motivation and context and draw on the students’ experience and preparatory reading.
o Tutorials (2 hours/week) include class discussion of case studies and research papers, practice sets and problem-solving and syndicate work on group projects. Tutorial participation is an essential component of the subject and contributes to the development of graduate attributes (see section 2.2 above). It is intended that specific tutorial material such as case studies, recommended readings, review questions etc. will be made available each week in Moodle.
o Online teaching resources include class materials, readings, model answers to assignments and exercises and discussion boards. All online materials for this subject as provided by KOI will be found in the Moodle page for this subject. Students should access Moodle regularly as material may be updated at any time during the trimester
o Other contact – academic staff may also contact students either via Moodle messaging, or via email to the email address provided to KOI on enrolment.
Grading Final grades are awarded by the Faculty Assessment Committee in accordance with KOI’s Assessment Regulations. The definitions and guidelines for the awarding of final grades within the BIT degree are: o HD High distinction (85-100%) an outstanding level of achievement in relation to the assessment
process. o DI Distinction (75-84%) a high level of achievement in relation to the assessment process. o CR Credit (65-74%) a better than satisfactory level of achievement in relation to the assessment
process. o PS Pass (50-64%) a satisfactory level of achievement in relation to the assessment process. o FL Fail (0-49%) an unsatisfactory level of achievement in relation to the assessment process.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 7 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
2.8 Student Assessment
Provided below is a schedule of formal assessment tasks and major examinations for the subject.
Assessment Type When assessed Weighting Learning Outcomes Assessed
Assessment 1 Weekly Tutorial Week 11 10% a, b, c, d, e, f
Assessment 2 Quiz A (opens week 2) Week 4 5% a
Assessment 3 Quiz B (opens week 8) Week 8 10% d
Assessment 4 Group Project (Report and Presentation) – Problem Based Scenario to Design (ERD), Implement and Query a SQL Server Database
Week 10 Week 11
Report 20% Presentation 5% d, e
Assessment 5 Final Exam (3 hours) Final exam period 50% b, c, d, e, f
Requirements to Pass the Subject: To gain a pass or better in this subject, students must gain a minimum of 50% of the total available subject marks.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 8 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
2.9 Prescribed and Recommended Readings
Prescribed Text: Kroenke, D.M., Auer, D., 2016. Database Processing. 14th ed., Pearson Also available as eText at Pearson Online: http://www.mypearsonstore.com/bookstore/database-processing-fundamentals-design-and- implementation-9780133878998?xid=PSED Recommended Readings: Elmasri, R. and Navathe, S. B., 2016. Fundamentals of Database Systems. 7th ed. Pearson Publishing. Hoffer, J., Venkataraman, R. and Topi, H., 2016. Modern Database Management. 12th ed. Prentice Hall. Useful Websites: The following websites are useful sources covering a range of information useful for this subject. As we are using MS Access and SQL Server there are numerous resources available online. A number are listed below. For core concepts and platform-independent (irrelevant to the DBMS being used) Data Modelling and SQL useful links are also provided. The prescribed textbook provides all the information required for students to do well in this unit. Students are encouraged to research additional information where required. During lectures and tutorials, students will be informed where example databases and related files may be found. Students are also expected to use the library and the internet for additional learning. The following links are primarily for additional learning and future reference (be sure to bookmark them). Remember to use your textbook first – all of the information you should need is in the text. Database resources and articles Journals: o ACM Transactions on Computer Systems. Available from EBSCOhost research databases o ACM Transactions On Database Systems. Available from EBSCOhost research databases o Journal of Electronic Commerce Research www.jecr.org o Journal of International Technology and Information Management
https://www.sciencedirect.com/journal/international-journal-of-information-management A larger resource of database information, tutorials, and exercises o Access 2013 Microsoft Official site for Access 2013 o Basic design from MS Office Database Design Basics o SQL Server Central http://www.sqlservercentral.com/Articles o Allen Browne Tips. Allen Browne is an Australian based Access developer with many years of
experience. More for VBA and advanced coding problems. o MSDN Community Forum. Microsoft Developer Network (MSDN) o TechOnTheNet. More advanced on VBA forms
3. Assessment Details 3.1 Details of Each Assessment Item The assessments for this subject are described below. The description includes the type of assessment, its purpose, weighting, due date and submission requirements, the topic of the assessment, details of the
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 9 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
task and detailed marking criteria, including a marking rubric for essays, reports and presentations. Supplementary assessment information and assistance can be found in Moodle. KOI expects students to submit their own original work in both assignments and exams, or the original work of their group in the case of group assignments. Marking guides for assessments follow the assessment descriptions. Students should compare final drafts of their assessment against the marking guide before submission. Please note that the final exam is not open book. Students are not permitted to bring any reference materials into the final exam. Students are not permitted to use mobile phones or other communication devices during tests and exams. Assessment 1 Assessment type: Tutorial Exercises – individual assessment Assessment purpose: To answer weekly tutorial exercises on the topics covered in lectures. This assessment contributes to learning outcomes a, b, c, d, e and f. Value 10% Submission requirements details: The tutorial exercises for weeks 2-11 Assessment topic: Tutorial Exercises Task details: Students need to complete the weekly tutorial exercises and upload the answers on Moodle Assessment 2 Assessment type: Quiz A (opens week 4) – individual assignment. Assessment purpose: This assessment will allow students to demonstrate that they have understood the concepts covered in weeks 1, 2 and 3. This assessment contributes to learning outcome a. Value: 5% Due Date: End of Week 4 Assessment topic: Quiz A Task details: The quiz will consist of questions and problems relating to subject content from weeks 1 – 3 inclusive. Assessment 2 Marking Rubric: Quiz A – Worth 5 Marks
Criteria Fail (0 – 49%)
Pass (50 – 64%)
Credit (65 – 74%)
Distinction (75 – 84%)
High Distinction (85 – 100%)
Score (out of 10) 0-4 5-6 7 8 9-10
Assessment 3 Assessment type: Quiz B (opens week 8) – individual assignment. Purpose: This assessment will allow students to demonstrate that they have understood the concepts covered in weeks 4 to 7. This assessment contributes to learning outcome d. Value: 10% Due Date: Week 8 Task details: The quiz will consist of questions and problems relating to subject content from weeks 4 – 7 inclusive.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 10 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Assessment 3 Marking Rubric: Short Answer Quiz B – Worth 10 Marks
Criteria Fail (0 – 49%)
Pass (50 – 64%)
Credit (65 – 74%)
Distinction (75 – 84%)
High Distinction (85 – 100%)
Score (out of 10) 0-4 5-6 7 8 9-10
Assessment 4 Assessment type: Group Project Report and Presentation Purpose: Demonstrate students can effectively work in a group to design, normalise, implement and query an SQL Server database according to a project scenario specification which they may select from a case study from the textbook. This assessment contributes to learning outcomes d, e. Value: Report 20%
Presentation 5% Total: 25%
Due Date: Report Week 10; Presentation in class Week 11 Assessment topic: Topics covered in week 1 – 10 Submission: Report, Group Charter and presentation file via Moodle; Presentation in class. Task details: Group Project (Report and Presentation) – Problem Based Scenario to Design (ERD), Implement and Query a SQL Server Database. Students will choose a case study from the textbook for this assignment. An ERD, database, scripts for creating tables, views, triggers, functions, stored procedures, insert, update, alter, delete and successful query results as requested in the case study will be assessed according to the marking criteria below. Students must normalize the data from 1 NF to BCNF and show each and every normalization with diagrams/tables and appropriate sample data to explain their understanding. Students will submit one group written report of 1000 words detailing the tasks they carried out in the assignment. 2 to 3 students can be in one group. This report will be due in the end of week 10. Students will also deliver a 15 mins presentation in class and explain their understanding and the approach they took to work on the assignment. This will be arranged in Week 11. The report requires a title page with student group members’ names and email, the assessment title and date. A brief introduction to the assignment can then be followed by the initial ERD, the Normalised version and the SQL statements used as requested by the case study chosen. Report must be well-written, have in-text and detailed Harvard style referencing and presented professionally, containing: o Title page o Table of Contents o Introduction o Appropriate use of headings within report o Overall structure, presentation and formatting. All group members must remain present for the demonstration in tutorial and must be able to explain the scripts written for the tasks outlined in case study. Marking Guide: A detailed marking guide for the Database Project (Assessment 4) is provided. See the following page.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 11 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Assessment 4 Marking Rubric: SQL Server Database Project – Worth 20 Marks
Criteria Fail (0-49%)
Pass (50-64%)
Credit (65-74%)
Distinction (75-84%)
High Distinction
(85-100%)
ER Diagram 5 marks
ER diagram not correct or not submitted
Identified all entities and built relationships using crow’s foot notation Data is in 3NF
Identified entities and relationships, representation using crow’s foot notation correct Data is in BCNF
ERD accompanied with explanation of relationships Data is in BCNF
Demonstrated all the normalization from 1 NF to BCNF along with diagram and table data
DDL, DML and PSM scripts 10 marks
Scripts are incorrect or not submitted
DDL and DML Scripts are correct Tables are created, data is inserted, updated, deleted
DDL and DML Scripts are correct Tables are created, data is inserted, updated, deleted Tables have default values and constraints are enabled on tables
DDL and DML Scripts are correct Tables are created, data is inserted, updated, deleted Tables have default values and constraints are enabled on tables Functions and Triggers are written to perform tasks mentioned in case study
DDL and DML Scripts are correct Tables are created, data is inserted, updated, deleted Tables have default values and constraints are enabled on tables Functions, Triggers and Stored Procedures are written to perform tasks mentioned in case study
Report and Presentation
10 marks
Report is not adhering to guidelines provided, tasks are not done satisfactorily Team member(s) have not shown convincing evidence of having performed the tasks outlined the case study
Report is submitted, meeting word count and presentation is delivered. There is sufficient evidence of participation of team member(s) Database, tables and other objects are created on SQL Server
Report is submitted, meeting word count, well referenced and presentation is delivered. There is sufficient evidence of participation of team member(s) Database, tables and other objects are created on SQL Server Students must be able to provide an explanation of the scripts they’ve written.
Report is submitted, meeting word count, well referenced and presentation is delivered. There is sufficient evidence of participation of team member(s) Students must be able to provide an explanation of the scripts they’ve written. Students are able to demonstrate the tasks outlined in the case study.
Report is well-written and presented professionally, containing: o Title page o Table of Contents o Introduction o Appropriate use of
headings within report
o Overall structure, presentation and formatting.
All tasks outlined in case study are carried out and the group has shown evidence of having done the task on their own.
Assessment 5 Assessment type: Final Exam (three hours) individual assessment – closed book exam Purpose: The final exam is intended to test that students have understood key concepts for relational database design, development and administration. This assessment contributes specifically to learning outcomes b, c, d, e, and f. Value: 50% Due Date: The final exam will be held in the official KOI exam period in Week 14
of the trimester. The specific date and time will be posted towards the end of the trimester.
Topic: The examination may cover content from any part of the entire subject related to learning outcomes b, c, d, e and f. Task Details: Students will be expected to answer written response questions derived from all lectures and tutorials in the trimester. 3.2 Late Penalties and Extensions An important part of business life and key to achieving KOI’s graduate outcome of Professional Skills is the ability to manage workloads and meet deadlines. Consequently, any assessment items such as in- class quizzes and assignments missed or submitted after the due date/time will attract a penalty (see below).
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 12 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Students who miss mid-trimester tests and final exams without a valid and accepted reason (see below) may not be granted a deferred exam and will be awarded 0 marks for assessment item. These penalties are designed to encourage students to develop good time management practices, and create equity for all students. Any penalties applied will only be up to the maximum marks available for the specific piece of assessment attracting the penalty. Late penalties, granting of extensions and deferred exams are based on the following: In Class Tests (excluding Mid-Trimester Tests) o No extensions permitted or granted – a make-up test may only be permitted under very special
circumstances where acceptable supporting evidence is provided. The procedures and timing to apply for a make-up test (only if available) are as shown in Section 3.3 Applying for an Extension (below).
o Missing a class test will result in 0 marks for that assessment element unless the above applies. Written Assessments o 5% of the total available marks per calendar day unless an extension is approved (see Section 3.3
below) Presentations o No extensions permitted or granted – no presentation = 0 marks. The rules for make-up presentations
are the same as for missing in-class tests (described above). Mid-Trimester Tests and Final Exams o If students are unable to attend mid-trimester tests or final exams due to illness or some other event
(acceptable to KOI), they must: − Advise KOI in writing (email: a[email protected]) as soon as possible, but no later than three
(3) working days after the exam date, that they will be / were absent and the reasons. They will be advised in writing (return email) as to whether the circumstances are acceptable.
− Complete the appropriate Application for Extension or Deferred Exam Form available from the Student Information Centre in Moodle, on the KOI Website (Policies and Forms) and the Reception Desk (Market St and Kent St), as soon as possible and email with attachments to [email protected].
− Provide acceptable documentary evidence in the form of a satisfactorily detailed medical certificate, police report or some other evidence that will be accepted by KOI.
− Agree to attend the deferred exam as set by KOI. Deferred exam o There will only be one deferred exam offered. o Marks awarded for the deferred exam will be the marks awarded for that assessment. o If you miss the deferred exam you will be awarded 0 marks for the assessment. This may mean you
are unable to complete (pass) the subject. 3.3 Applying for an Extension If students are unable to submit or attend an assessment when due, and extensions are possible, they must apply by completing the appropriate Application for Extension form available from the Student Information Centre in Moodle, the KOI Website (Policies and Forms) and the Reception Desk (Market St and Kent St), as soon as possible but no later than three (3) working days of the assessment due date. The completed form must be emailed with supporting documentation to [email protected].
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 13 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Students and lecturers / tutors will be advised of the outcome of the extension request as soon as practicable.
Appropriate documentary evidence to support the request for an extension must be supplied. Please remember there is no guarantee of an extension being granted, and poor organisation is not a satisfactory reason to be granted an extension. 3.4 Referencing and Plagiarism Please remember that all sources used in assessment tasks must be suitably referenced. Failure to acknowledge sources is plagiarism, and as such is a very serious academic issue. Students plagiarising run the risk of severe penalties ranging from a reduction through to 0 marks for a first offence for a single assessment task, to exclusion from KOI in the most serious repeat cases. Exclusion has serious visa implications. The easiest way to avoid plagiarising is to reference all sources. Harvard referencing is the required method – in-text referencing using Author’s Surname (family name) and year of publication. A Referencing Guide, “Harvard Referencing”, and a Referencing Tutorial can be found on the right hand menu strip in Moodle on all subject pages. An effective way to reference correctly is to use Microsoft Word’s referencing function (please note that other versions and programs are likely to be different). To use the referencing function, click on the References Tab in the menu ribbon – students should choose Harvard. Authorship is also an issue under plagiarism – KOI expects students to submit their own original work in both assessment and exams, or the original work of their group in the case of a group project. All students agree to a statement of authorship when submitting assessments online via Moodle, stating that the work submitted is their own original work. The following are examples of academic misconduct and can attract severe penalties: o Handing in work created by someone else (without acknowledgement), whether copied from another
student, written by someone else, or from any published or electronic source, is fraud, and falls under the general Plagiarism guidelines.
o Copying / cheating in tests and exams is academic misconduct. Such incidents will be treated just as seriously as other forms of plagiarism.
o Students who willingly allow another student to copy their work in any assessment may be considered to assisting in copying/cheating, and similar penalties may be applied.
Where a subject coordinator considers that a student might have engaged in academic misconduct, KOI may require the student to undertake an additional oral exam as a part of the assessment for the subject, as a way of testing the student’s understanding of their work. Further information can be found on the KOI website. 3.5 Reasonable Adjustment The Commonwealth Disability Discrimination Act (1992) makes it unlawful to treat people with a disability less fairly than people without a disability. In the context of this subject, the principle of Reasonable Adjustment is applied to ensure that participants with a disability have equitable access to all aspects of the learning situation. For assessment, this means that artificial barriers to their demonstrating competence are removed. Examples of reasonable adjustment in assessment may include: o provision of an oral assessment, rather than a written assessment o provision of extra time o use of adaptive technology. The focus of the adjusted assessment should be on enabling the participants to demonstrate that they have achieved the subject purpose, rather than on the method used. 3.6 Appeals Process Full details of the KOI Assessment and Assessment Appeals Policy may be obtained in hard copy from the Library, and on the KOI website www.koi.edu.au under Policies and Forms.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 14 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
ICT200
Assessments and Mid-Trimester Exams: Where students are not satisfied with the results of an assessment, including mid-trimester exams, they have the right to appeal. The process is as follows: o Discuss the assessment with their tutor or lecturer – students should identify where they feel more
marks should have been awarded – students should provide valid reasons based on the marking guide provided for the assessment. Reasons such as “I worked really hard” are not considered valid.
o If still not satisfied, students should complete an Application for Review of Assessment Marks form, detailing the reason for review. This form can be found on the KOI website and is also available at KOI Reception (Market St and Kent St).
o Application for Review of Assessment Marks forms must be submitted as explained on the form within ten (10) working days of the return of the marked assessment, or within five (5) working days after the return of the assessment if the assessment is returned after the end of the trimester.
Review of Grade – whole of subject and final exams: Where students are not satisfied with the results of the whole subject or with their final exam results, they have the right to request a Review of Grade – see the Assessment and Assessment Appeals Policy for more information. An Application for Review of Grade/Assessment Form (available from the KOI Website under Policies and Forms and from KOI Reception, Market St and Kent St) should be completed clearly explaining the grounds for the application. The completed application should be submitted as explained on the form, with supporting evidence attached, to the Academic Manager.
ICT 200 DATABASE DESIGN AND DEVELOPMENT T219 19/06/2019 16:20 PAGE 15 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A
Approved by KOI Academic Board for T2 2019
Any academic writer who wishes to join our team of professional writers must possess all the following qualities:
To write an exemplary academic paper, you must have good critical thinking skills, possess the proper knowledge of the discipline, and be knowledgeable about applying an academic writing style.
As such we have a rigorous recruitment process. We only collaborate with professional academic writers. We believe in offering the highest quality academic writing services. Our writers pass various grammar and academic writing tests. They have to provide documents about their personal information and credentials to prove their level of expertise.
As a result, our clients receive papers that are thoroughly-researched, properly cited, and written within academic standards. We are proud that any academic writer from our writer's team can complete the paper at a high standard.
We work with the student’s budget because we know that students are usually on a budget majority of the time. We do not compromise on quality because of low prices. On the contrary, we love to foster a good relationship with our clients. That is why we charge our clients reasonable prices, and we are willing to negotiate and work with their budget.
It may be quite disturbing to decide whether to hire an academic writing company. We care about our client’s privacy and confidentiality. We never disclose your information to third parties. We never publish your paper online. You can use our academic writing service without any fear or anxiety.
Many students struggle with writing academic papers. Some barely have time to do their assignments because of their job and family responsibilities. Others have difficulty applying critical thinking skills or meeting time or assignment requirements. Whatever the reason is, you can always have time to do the things you love and other important things. All you need is a reliable and quality academic writing service. Unfortunately, even if you strongly desire to write the paper yourself, you sometimes face unexpected challenges. As we all know, life is unpredictable! Your teacher may be unconcerned about helping students and may not answer your questions. The good news is that there is a way out! You can hire an online academic writer to help you with your assignments. All you need to do is stipulate your paper requirements in the order form, and you can spend your time as you like.
Our company commits towards delivering high-quality custom papers to our clients. We seek to offer reliable essay writing services to our customers in various subject areas. Our customers are very valuable to us. As such, we commit to ensuring that they derive the utmost satisfaction from the essays we deliver. We have a mission to promote our clients' educational and professional lives by providing high-quality essays for their use. We also have a mission to offer a convenient essay writing system where our customers can easily order and pay for the services. We value quality and professionalism in our company.
We write papers on any subject area, and we also write various types of papers for various purposes. We have a team of able writers who are eager to help our customers with writing services of exceptional quality. We offer custom writing services for customers across the globe and charge affordable prices for our services. We are the best essay writing company offering personalized services to all our customers. We ensure our customers receive maximum satisfaction from the essays we deliver. Our website is the place to be if you are seeking high-quality essays.
By using our academic writing service, we match your paper subject with a writer with a degree in the subject. The writer is able to apply their skills, knowledge, and expertise to the paper. You receive an original, unique, well-research paper, properly cited and formatted. As such, you are assured of a high-quality paper.
Truth be told, writing assignments can be stressful and difficult for any student. There is no shame in getting academic writing help. When you search the term “get academic writing help” there are numerous sites that pop up on the results and our website is among them. So, why is it a great idea to choose us?
During your course, your instructor will assign various types of homework. Our academic writers can prepare essays, presentations, speeches, case studies, research papers, dissertations, thesis papers, and more. Our writer’s department is capable of tackling any assignment of any complexity easily. All you need is to give us detailed instructions to help our experts understand the task.After doing so, you can rest assured that everything is in control, and we will deliver a paper of unmatchable quality.
Are you a college or university student pursuing your Bachelor’s , Masters, PhD, or Doctorate degree? Sometimes juggling schoolwork with work, family and hobbies can seem like a daunting task. You have to sacrifice one or the other. The sole purpose of our website is to alleviate your academic burdens. We ensure that you do not fail in your classes and you get good grades consistently. We understand that there is a need for academic help.
We acknowledge that our clients are not dumb or lazy but only need academic life need help in order to live a balanced life and make ends meet. We make it our core priority to ensure that all assignments are done and submitted before the stipulated deadlines. All our writers are graduates. They are competent in handling the clients’ assignments. We step in to help you with any and all of your assignments. Our assignment help service ensures that you never miss a grade or deadline.
Students barely have time to read. We got you! Have your literature essay or book review written without having the hassle of reading the book. You can get your literature paper custom-written for you by our literature specialists.
Do you struggle with finance? No need to torture yourself if finance is not your cup of tea. You can order your finance paper from our academic writing service and get 100% original work from competent finance experts.
Computer science is a tough subject. Fortunately, our computer science experts are up to the match. No need to stress and have sleepless nights. Our academic writers will tackle all your computer science assignments and deliver them on time. Let us handle all your python, java, ruby, JavaScript, php , C+ assignments!
While psychology may be an interesting subject, you may lack sufficient time to handle your assignments. Don’t despair; by using our academic writing service, you can be assured of perfect grades. Moreover, your grades will be consistent.
Engineering is quite a demanding subject. Students face a lot of pressure and barely have enough time to do what they love to do. Our academic writing service got you covered! Our engineering specialists follow the paper instructions and ensure timely delivery of the paper.
In the nursing course, you may have difficulties with literature reviews, annotated bibliographies, critical essays, and other assignments. Our nursing assignment writers will offer you professional nursing paper help at low prices.
Truth be told, sociology papers can be quite exhausting. Our academic writing service relieves you of fatigue, pressure, and stress. You can relax and have peace of mind as our academic writers handle your sociology assignment.
We take pride in having some of the best business writers in the industry. Our business writers have a lot of experience in the field. They are reliable, and you can be assured of a high-grade paper. They are able to handle business papers of any subject, length, deadline, and difficulty!
We boast of having some of the most experienced statistics experts in the industry. Our statistics experts have diverse skills, expertise, and knowledge to handle any kind of assignment. They have access to all kinds of software to get your assignment done.
Writing a law essay may prove to be an insurmountable obstacle especially when you need to know the peculiarities of the legislative framework. Take advantage of our top-notch law specialists and get superb grades and 100% satisfaction.
$10 page
$13 page
$14 page
Our prices depend on the urgency of your assignment, your academic level, the course subject, and the length of the assignment. Basically, more complex assignments will cost more than simpler ones. The level of expertise is also a major determinant of the price of your assignment.
If you need professional help with completing any kind of homework, is the right place to get it. Whether you are looking for essay, coursework, research, or term paper help, or with any other assignments, it is no problem for us. At our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the US, the UK, Australia, Canada, Italy, New Zealand, China, and Japan.
Our cheap essay writing service has already gained a positive reputation in this business field. Understandably so, since all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer APA, MLA, or a Chicago style paper in almost 70 disciplines. Here, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for sale. Any paper will be written on time for a cheap price.
Using our cheap essay writing help is beneficial not only because of its easy access and low cost, but because of how helpful it can be to your studies. Buy custom written papers online from our academic company and we won't disappoint you with our high quality of university, college, and high school papers. Although our writing service is one of the cheapest you can find, we have been in the business long enough to learn how to maintain a balance between quality, wages, and profit. Whenever you need help with your assignment, we will be happy to assist you.
It might seem impossible to you that all custom-written essays, research papers, speeches, book reviews, and other custom task completed by our writers are both of high quality and cheap. It is surprising, but we do have some tricks to lower prices without hindering quality.
To start using our services, it’s enough to place a request like “I need a writer to do my assignment” or “Please, write an essay for me.” We have a convenient order form, which you can complete within minutes and pay for the order via a secure payment system. The support team will view it after the order form and payment is complete and then they will find an academic writer who matches your order description perfectly. Once you submit your instructions, while your order is in progress and even after its completion, our support team will monitor it to provide you with timely assistance.
Hiring good writers is one of the key points in providing high-quality services. That’s why we have entry tests for all applicants who want to work for us. We try to make sure all writers working for us are professionals, so when you purchase custom-written papers, they are of high quality and non-plagiarized.
Our cheap essay writing service employs only writers who have outstanding writing skills. The quality of all custom papers written by our team is important to us; that is why we are so attentive to the application process and employ only those writers who can produce great essays and other kinds of written assignments. All our writers are graduates. They are competent in handling the clients’ assignments. We step in to help you with any and all of your assignments. Our assignment help service ensures that you never miss a grade or deadline.
All our cheap essays are customized to meet your requirements and written from scratch. Our writers have a lot of experience with academic papers and know how to write them without plagiarism. Moreover, at our academic service, we have our own plagiarism-detection software which is designed to find similarities between completed papers and online sources. You can be sure that our custom-written papers are original and properly cited.
Our essay writing service has a 0% plagiarism tolerance. We are well aware of the dangers of plagiarism. Plagiarism is academic suicide. Our essay writing service ensures that all papers are original. We do not sell pre-written papers. All papers are written from scratch as per the instructions. We pass our papers through powerful anti-plagiarism software such as SafeAssign and TurnItIn.
Our cheap essay writing service tries to always be at its best performance level, so each customer who pays money for paper writing can be sure that he or she will get what is wanted. On the off chance that you don’t like your order, you can request a refund and we will return the money according to our money-back guarantee.
There can be a number of reasons why you might not like your order. If we honestly don’t meet your expectations, we will issue a refund. You can also request a free revision, if there are only slight inconsistencies in your order. Your writer will make the necessary amendments free of charge. You can find out more information by visiting our revision policy and money-back guarantee pages, or by contacting our support team via online chat or phone.
We know how important any deadline is to you; that’s why everyone in our company has their tasks and perform them promptly to provide you with the required assistance on time. We even have an urgent delivery option for short essays, term papers, or research papers needed within 8 to 24 hours.
We appreciate that you have chosen our cheap essay service, and will provide you with high-quality and low-cost custom essays, research papers, term papers, speeches, book reports, and other academic assignments for sale. We beat all deadlines. We can also handle urgent orders with deadlines as short as 1 hour. Our urgent paper writing service does not compromise on quality due to the short deadline. On the contrary, our essay writers have a lot of experience which comes in handy in such situations.
We provide affordable writing services for students around the world. That’s why we work without a break to help you at any time, wherever you are located. Contact us for cheap writing assistance. Our impeccable customer support team will answer all your questions and help you out with any issues.
Proceed to order pageDelivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more