This Study Resource Was: Employees [PDF]

Zitiervorschau

Lab 3 Exercise 1.

Convert the following Relationship to Relation Data Model

ID

Nam e

Mana ge

EMPLOYEES

is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m

Q6: EMPLOYEES ( ID, Name ) EMPLOYEES ( ID, ManageID, Name )

Flight#

Date

From

Code

FLIGHTS

Name

LOCATIONS

To

Q5: FLIGHTS ( Flight#, Date, CodeLocationFrom, CodeLocationTo ) LOCATIONS ( Code, Name ) ID

Code

Nam e

EMPLOYEES

Proces s

Nam e

PRODUCTS

Th

Q3: EMPLOYEES ( ID, Name ) PRODUCTS ( Code, Name, ID )

Nam e

Date

Code

sh

ID

EMPLOYEES

Sale

PRODUCTS

Q3: EMPLOYEES ( ID, Name ) PRODUCTS ( Code, Name, Price, Date, ID ) This study source was downloaded by 100000812383137 from CourseHero.com on 09-28-2021 01:50:45 GMT -05:00

https://www.coursehero.com/file/33882522/Lab3-TanHuynhDangdoc/

Nam e

Price

EmployeeID

Nam e

Code

Name

Quantit y Sale

EMPLOYEE

PRODUCT

CustomerID

CUSTOMER Name

is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m

Q1: EMPLOYEES ( EmployeeID, Name ) CUSTOMER ( CustomerID, Name ) PRODUCTS ( Code, Name ) Q3: Sale ( EmployeeID, CustomerID, Code, Quantity )

Speciality

Code

TEACHER

IS A

STUDENT

IS A

Nam e

PERSON

specify the type that you use

Th

Class

sh

Q7: PERSON ( Code, Name ) TEACHER ( Code, Name, Speciality ) STUDENT ( Code, Name, Class )

ABC Consulting is a small-sized consulting firm in the IT industry. ABC’s business is managing several Systems Development projects by assigning staff consultants to these projects as their skills are needed. Each employee is designated to have one primary skill, but there may be other employees Exercise 2.

This study source was downloaded by 100000812383137 from CourseHero.com on 09-28-2021 01:50:45 GMT -05:00

https://www.coursehero.com/file/33882522/Lab3-TanHuynhDangdoc/

with the same primary skill. A consultant may work on one or more projects, or may not yet be assigned to a project. The company charges for each project by billing each consultant's hours worked by the billing rate. The hourly billing rate is dependent on the employee’s primary job skill. Draw ER model for the problem (add the attributes that you deem necessary for each entity in the model). Then, convert this model to Relation data model. SkillID

Name

BillRate s

Name

ProjectI D

Time

PROJECT

SkillID

SALARY

is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m

SKILL

Workhour s

EMPLOYEES

Name

ProjectID

EmployeeID

SKILL ( SkillID, Name, BillRates )

PROJECT ( ProjectID, Name, Time )

SALARY ( SkillID, ProjectID, Workhours )

sh

Th

EMPLOYEES ( EmployeeID, Name, Phone )

This study source was downloaded by 100000812383137 from CourseHero.com on 09-28-2021 01:50:45 GMT -05:00

https://www.coursehero.com/file/33882522/Lab3-TanHuynhDangdoc/ Powered by TCPDF (www.tcpdf.org)

Phone