Database Design Singapore Home Software Singapore Home Software is a company with a global vision that is engaged in software developer based on Artificial Intelligence (AI) and Internet of Things...

Database Design

Singapore Home Software

Singapore Home Software is a company with a global vision that is engaged in software developer based on Artificial Intelligence (AI) and Internet of Things (IoT). BIT House is supported and strengthened by a team of IT consultants who are ready to serve better in terms of understanding and implementation. One of their proudest projects is developing a mobile application for Wego, a popular travel site in Asia and currently developing in Europe and the US. Shopee and Grab also use our service. At this time the allocation of employees to a project is still done manually using excel, you as a database designer are asked to create a module for the employee allocation system to a particular project, here is the conceptual database design from Singapore Home Software :

IMAGE

Question

1. Based on the business processes and conceptual database design above, create a logical database design for PT Sinus Software House.

Extracted text: WorkingHours Project 1. Projecto ProjecITille ProjectBudget ProjectLocation Insurance Staf Department InsurancelD tafmi DepartmentiD 1.1 1.1 < dependent="" on="" works="" for=""> 1.1 Name StaffName DepartmentName DateOBirth StafGender DepartmentLocation Gender StaffAddress 1.1 StaffSalary (Optional, And) StartDate Sales ManagerAsistant Manager 1..1 SalesArea Speed Bonus SalesTarget controls= e saBRURIU < so="" siaadns="">< uo siom uo="">