1 BAC41 Management Information Systems, Semester 2/2013 Assignment 2 (20%) Assignment Tasks: Building a Relational Database & querying the data Database skills & DBMS skills: Database Design, querying Assignment description An organization keeps data about the project, employee and the job the employee work for each project. The data for this organisation is shown in the following table. Project_No Project_Name Emp_No Emp_Name Job_class Rate PerHr Hours 15 Evergreen 103 Jane E. Arbough Electrical Engineer 85 24 15 Evergreen 101 John G. News Database Designer 105 19 15 Evergreen 105 Alice K. Johnson Database Designer 105 35 15 Evergreen 102 David H. Senior System Analyst 95 24 18 Amber Wave 114 Annelise Jones Applications Designer 48 24 18 Amber Wave 104 James J. Frommer General Support 18 45 18 Amber Wave 112 Darlene M. Smithson System Analyst 100 44 22 Rolling Tile 105 Alice K. Johnson Database Designer 105 65 22 Rolling Tile 101 John G. News Database Designer 105 60 25 Starfight 112 Darlene M. Smithson System Analyst 100 40 25 Starfight 114 Annelise Jones Applications Designer 48 30
2 You are asked to perform the following activities 1. Implement the normalized tables using MS-Access. (4 marks) 2. From the tables implemented in answer 1, using MS-Access to develop a query to display the employee number and employee name who works for Evergreen project. (3 marks) 3. From the tables implemented in answer 1, using MS-Access to develop a query to display the summary of hours for Rolling Tile project (3 marks). 4. From your normalized tables in answer 1, write a description in 1,000 words for why the normalized tables in answer 1 are important in performing data operation (e.g. insert, delete, update the records). (10 marks) Assignment Requirement This assignment is a group assignment, the numbers of students per group are 3 students. There are two tasks to be done for this assignment. These are presenting the work to the lecturer and submitting document (in pdf…