ITICT107A Database Development :
| Unit | ITICT107A Introduction to Databases |
| Assessment Type | Database Development |
| Assessment Number | 5 |
| Assessment Name Weighting | Assignment 5 – Database Development 15% |
| Due Date/Time | Week 11 This assessment task aims to implement a database of your own choice & design with the consideration of the relational model and normalisation. It also involves the use of SQL and to a lesser extent T-SQL. Upload by Sunday 14th May 2023 via Moodle Turnitin 23:55 (AEST) |
| Assessment Description | You are required to implement a database of your own design. See the following documents on the assessments tab for further details on the assignment: Database Project – Example of student work – for a sample report content.ITICT07A Introduction to Databases – Assignment Report Structure – for expected report structure.Database Assignment Student Feedback _# – for marking guide.ITICT107A Introduction to Databases – Assignment Exemplar – for an example of a database based on a hotel system which includes a project brief, requirements, system specifications, sample SQL statements, submission requirements, and a brief marking guide.Database Presentation example of student work |
| Detailed Submission Requirements | Your report for your modelling assignment is to be presented as a soft copy. All assessment activities that are handed in must be presented to a professional standard and must include: A soft copy to be submitted to the designated lecturer or nominated alternative by the due time and date. It must have a title page that includes the student’s name and ID number, the title of the assignment and a signed statement that the work is exclusively the student’s own work and that there has been no plagiarism or collusion. Reports without a coversheet will not be accepted. A footer to be shown on every page that includes the student’s name, ID number, and page #.A soft copy of your report is to be submitted on Moodle. The same assignment deadlines apply to this submission format. E-mailing your assignment will be accepted only after consultation with the tutor. If emailing, through an arrangement with the tutor, send the document as an e-mail attachment in MS Word or PDF format. The subject line in the e-mail must include the student’s name. When sending e-mails please request an automated receipt. Where there is doubt as to whether the assessment activity was submitted on time, no claims for timely submission will be accepted if there is no receipt. Submissions not clearly identified with the author’s details as outlined in the points above will not be marked and may result in a zero (0) grade for that activity. |
| Misconduct | PLAGIARISM AND COLLUSION Any submitted work that contains plagiarism or collusion will be reported to the appropriate authorities according to the TAFE policy and will receive an automatic zero ‘0’ mark for the assignment. The assessment will be submitted through Turnitin via your unit page on Moodle. Turnitin is plagiarism software, which will identify if you have copied information and included it in your assessment. Copying information from others (i.e. websites, partner company information, or other students etc.) without the acknowledging the author is classified as misconduct. Engaging someone else to write any part of your assessment for you outside of the group work arrangement is classified as misconduct. To avoid being charged with Misconduct, students need to submit their own work and apply APA or Harvard Style Referencing (ask your lecturer (https://courses.highered.tafensw.edu.au/mod/page/view.php?id=48) if you do not know what this means, or you need assistance applying it). The TAFE misconduct policy and procedure can be read on the TAFE website ((https://www.tafensw.edu.au/about/policies-procedures/higher-education). Use the TAFE referencing guide accessible on Moodle. |
| Late Submission | Deadlines: There will be NO extensions except where Calendar rules apply. Deadlines must be met, unless an acceptable medical certificate covers 25% or more of the lead-time between the assignment and the deadline. Other absences must be accounted for by substantiating documentation, for example a police accident report or statutory declaration. Any assessment activities missed for medical (or other acceptable substantiated) reasons must be completed by a new deadline that will be assigned in negotiation with the lecturer. The penalty for Late Submission of assignments is 5% of the total marks for each day (or part thereof, including weekends) the assignment is late. For assignments received more than 7 days after the due date, the assignment will be assessed, but a zero mark will be awarded. Electronic failure causing delay: In most work submissions you have a final deadline but it is recommended that you submit well before this time. Timely submission is your responsibility – last minute technical disaster will not be accepted as a reason for late submission. You are expected to have discipline in time management, to make back-ups, and always have the back-ups available for submission. Any assessment submitted past the specific due date and time will be classified as Late. Any Late submission will be subject to a reduction of the mark allocated for the assessment item by 5% per day (or part thereof) of the total marks available for the assessment item. A ‘day’ for this purpose is defined as any day of the week including weekends. Assignments submitted later than one (1) week after the due date will not be accepted, unless special consideration is approved as per the formal process. |
| Special consideration | Students whose ability to submit or attend an assessment item is affected by sickness, misadventure or other circumstances beyond their control, may be eligible for special consideration. No consideration is given when the condition or event is unrelated to the student’s performance in a component of the assessment, or when it is considered not to be serious. Students applying for special consideration must submit the form within 3 days of the due date of the assessment item or exam. The form can be obtained from the TAFE website (https://courses.highered.tafensw.edu.au/mod/page/view.php?id=48) or on-campus P.4.32. The request form must be submitted to Admin Office. Supporting evidence should be attached. For further information please refer to the Higher Education Assessment Policy and associated Procedure available on (https://www.tafensw.edu.au/about/policies-procedures/higher-education). |
Marking criteria and standards: ITICT107A Database Development Assessment 5
| Criteria | Unsatisfactory | Pass | Credit | Distinction | High Distinction |
| Concepts and techniques covered | No proper/little understanding of concepts and very limited use of techniques | Reasonable understanding of the concepts and basic techniques | Sound grasp of the concepts and techniques | Full understanding of the concepts plus the effective use of techniques | Superb understanding of the concepts and demonstrated proficiency in using techniques |
| ER diagram | The provided ER diagram does not attempt to model a database needed to solve the given problem. | Includes some essential entities with some attributes to model the solution database with somewhat meaningful relationships. Primary keys, foreign key and constraints identified. The model presented in a clear way that is easier to comprehend. | Includes most of the essential entities with sufficient attributes to model the solution database with somewhat meaningful relationships. Primary keys, foreign key and constraints identified. The model presented in a clear way that is easier to comprehend. | Includes most of the essential entities with required attributes in ER diagram to model the solution database with meaningful relationships. Primary keys, foreign key and constraints identified. The well-designed model presented in a clear way that is easier to comprehend. | Includes all the essential entities with required attributes in ER diagram to model a professional level solution database with meaningful relationships. Primary keys, foreign key and constraints identified. The well-designed model presented in a clear way that is easier to comprehend. |
| Relational Schema | Did not include all the required tables and attributes. | Reasonable attempt to include the tables and formatted fields, appropriate data types, data integrity and constraints to match with the provided ERD. The tables are populated with some data. | Good attempt to Include most of the tables and formatted fields, appropriate data types, primary keys and foreign keys. Presented using appropriate notation. The tables are populated with some data. | Include most of the tables and formatted fields, appropriate data types, data integrity and constraints to match with the provided ERD. The tables are populated with sufficient data. | Include all the tables and formatted fields, appropriate data types, data integrity and constraints to match with the provided ERD. The tables are populated with sufficient data. |
| SQL and output | Reasonable attempt to create SQL and provide output according to the given specification. | Good attempt to create SQL and provide output according to the given specification. | Very good attempt to create SQL and provide output according to the given specification. | Excellent attempt to create SQL and provide output according to the given specification. |
Visit:https://auspali.info/
Also visit:https://www.notesnepal.com/archives/767
YOUR COMMENT