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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education