Department of Business & Computing Programme Title BTEC HND/HNC in Computing & Systems Development Unit Title Database Design Concepts Unit Number 17 Candidate’s Name: Assessor’s Name: Bratati Sinha Verifier’s Name: Mr Kamal Verma Date of IV of Brief: 02.11.2012 Signature of IV: K K Verma Issue Date: 14.11.2012 Due Date: 09.01.2013 Plagiarism: Where there is evidence of plagiarism the assignment will be rejected and the candidate will not have an opportunity to re-submit the work. This will, inevitably, jeopardise your chances of completing the unit. Deadlines: Work that is not handed in on time will be subject to College policy on late submission of work and may not be graded or marked.This could result in you failing the course unless there are exceptional circumstances which must be explained with evidence to your tutor and agreed by the Curriculum Manager. Referral of Assignments: Questions marked “Pxx” need to be completed successfully to achieve a Pass grade. Only then can you achieve a Merit grade by completing the question(s) marked “Mxx”, and a Distinction by completing the question(s) marked “Dxx” in addition to the Merit questions(s). Where this identification of possible higher grades does not exist the general higher grades descriptors, which follow, will apply. Work not meeting the minimum requirement for pass grade will be referred back to the learner who will have TWO weeks to rectify any shortcoming. All decisions or grades are subject to internal and/ or external verification and may be modified. If you feel that an assessment decision is unjustified, you are entitled to appeal. For further details on any of the above please refer to your Course Handbook P2.1 P2.2 P3.1 P3.2 P3.3 P3.4 M1 M2 M3 D1 D2 D3 Assignment No. & Title Learning Outcomes Targeted Date Issued Hand In Date Resubmission Date(s) (if necessary) Assignment 01- City College Database LO2- Understand database design techniques 14.11.2012 LO3 -Be able to design, create and document databases 14.11.2012 Candidate’s Declaration: I certify that the work submitted for this assignment is my own and research sources are fully acknowledged. Candidate’s name: Candidate’s signature: Date: Assessor signature Date IV Signature Date This sheet, with the assignment brief, must be handed in with your work to the faculty assignment box by 16.00hrs of the final date for submission. Learning Outcome Ref. No. Criteria Assign. No. Evidence/ Page No. Feedback Met/ Partly Met? Y/N Assessor Sig./Date L02 P2.1- analyse a database developmental methodology Assignment -01 L02 P2.2- discuss entity-relationship modelling and normalisation Assignment -01 L03 P3.1 apply the database developmental cycle to a given data set Assignment -01 L03 P3.2 design a fully functional database (containing at least four inter-relational tables) including user interface Assignment -01 L03 P3.3 evaluate the effectiveness of the datab.