21 0 78KB
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