Answered: WorkingHours Project 1. Projecto…

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

See similar textbooks

Related questions

Concept explainers

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

Make transaction analysis by making:

a. Cross-referencing transactions

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

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

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