Objectives • To develop a conceptual data model diagram • To perform logical design and physical design • To implement a database
Introduction In this assessment, you are required to perform the following tasks for the case study given below: • Design and draw an Entity Relationship diagram • Perform logical and physical design • Create a Database in MS-Access
Case Study Century Engineering — Timesheet system You are junior member of an information technology consultancy team — Tiger Technology. Your team has been engaged by a medium-sized firm called Century Engineering. Century Engineering has engaged Tiger Technology to develop a database application to record the entry, approval and payment of workers’ timesheet data and some related human resources data. Your team leader has asked you to develop an entity-relationship model to capture the data requirements of this application as well as a subsequent database design/implementation. You are not required to develop an application or any other model — just the ER model and subsequent database design. After interviewing the payroll staff, you have come up with the following data requirements: • Must be able to record details of employees,