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.

Microsoft Visual C#
7th Edition
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Joyce, Farrell.
Chapter1: A First Program Using C#
Section: Chapter Questions
Problem 2E: Name at least three attributes that might be appropriate for each of the following classes: TVShow...
icon
Related questions
Question

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.

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
Transcribed Image 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
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Approaches used in acquiring Information System
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,