数据库理论作业.doc

Assignment Cover Sheet Students are requested to complete all details on both portions prior to submission at the to enable a speedy service. Please use a ballpoint pen. STUDENT ID: 2009016 (Please enter your Registration number here) MODULE CODE: COM147J4 MODULE TITLE: Introduction to Database LECTURER’S NAME: Lu ShaoMing ASSIGNMENT NO: 1 OF 3 CONTRIBUTION TOWARDS: Coursework Total 30 % DATE SET: 23 April, 2010 APPROXIMATE TIME TO BE SPENT: 1 Weeks Hand-In Date: 30 April,2010 ON RETURN TUTOR’S COMMENTS ON WORK: Tutor’s Signature: GRADE/MARK STUDENT PLEASE NOTE It is your responsibility to ensure that ALL course work is submitted on time to the specified location. You must keep copies of all work submitted. You are advised to keep your receipt safe – it is required in the event of any query concerning this Assignment. ASSIGNMENT RECEIPT – Not valid unless stamped Student’s Signature: Date: It is your responsibility to retain this receipt. Stamp Assignment 1 (of 3) Date of Issue: 9:00 AM, 23 April, 2010 Submission Date: 11:00 AM, 30 April, 2010 Feedback: 11:00 AM, 30 April, 2010 Assignment Information This assignment contributes 30% of the overall coursework mark for the module, the other 60% being awarded for a class test. Coursework contributes 25% of the final module result, the other 75% being an end of semester examination. Students should attempt and submit solutions to all four of the questions below. Each question carries equal marks. Question 1 Translate each of the following terms: (a)relation (b)database (c)Database management system (d)candidate key (e)data model (f)NULL (g)domain (h)relational algebra Relation:A relation is a table wi