ASSIGNMENT TWO 15 marks Due Friday 2/11/2012 at 5pm Released on 3/10, draft available since 3/10, last updated 3/10 This assignment is a group assignment. This assignment needs to be completed in a group of 2 student members. If such a group is formed, both members must come from the same campus, and also within the tutorial classes of the same tutor whenever possible. While lecturers and tutors will help as much as they can, it is essentially each students own motivation and responsibility to form a group for this assignment. Document Preview: ASSIGNMENT TWO 15 marks Due Friday 2/11/2012 at 5pm Released on 3/10, draft available since 3/10, last updated 3/10 This assignment is a group assignment. This assignment needs to be completed in a group of 2 student members. If such a group is formed, both members must come from the same campus, and also within the tutorial classes of the same tutor whenever possible. While lecturers and tutors will help as much as they can, it is essentially each students own motivation and responsibility to form a group for this assignment. Students not willing or not able to form a group in a timely manner will have to do the complete assignment on his or her own. Database Design and SQL Queries In assignment 1, you have already started the process of designing a database for the Instant Recruitment mini-case (enclosed again below), mainly in the phase of conceptual database design, and a draft ER diagram has been created for this purpose. Here you will further refine your database design for the other design phases. In this assignment, you will in particular complete the logical design along with the normalisation process, have it physically implemented, perform a few important queries in SQL, and establish certain stored procedures or functions in Transact SQL (T-SQL) to process data or verify database integrity. Your design of relational model should be done in such a way that business rules and data integrity are ensured by the intrinsic designof the database as much as possible. Logical Database Design For the ER diagram you created in assignment 1, the artefact of the conceptual database design, map the ER model into the relational model according to how it was designed in the ER diagram. You may however first refine your ER diagram if necessary. The actual assessment of this part is in the point 3 below. While there can be a variety of acceptable designs, we here attach one simplistic rough sketch for the comparison Attachments: ASSIGNMENT-TW.docx