Reference no: EM132686937
IFB105 Database Management - Queensland University of Technology
Project - part A
Project overview
The IFB105 project gives you an opportunity to apply concepts and skills you acquired in the unit to a realistic database design scenario and reflect on the data requirements of an organisation.
The submission is divided into 2 parts due at different times during the semester. These parts will cover:
A. Design of a database
B. Creation and use of a database
The task for part A
In this part, you will:
1. Design an ORM conceptual schema for a business domain based on sample reports required for that domain.
2. Map a different ORM schema to a relational database schema.
Groups
This assignment can be done individually or in pairs.
If you choose to work in a pair, only one student should submit the assignment. Please provide the name and student number of the person you worked with on the front page. No consideration will be given to any student who claims to have done more work than the other student in his/her pair, because this assignment can be done individually.
Part A tasks
Note the following points to prepare your answers:
1. Population is significant and no further explanation is required from the domain expert. In other words, carry out your CSDP steps 1 to 6 for the given data only.
2. We strongly recommend that you carry out your CSDP steps starting from Step 1 and ending in Step 6 to prepare your final ORM diagram. But you are not required to submit results of these steps individually.
3. You are only required to submit your final ORM diagram obtained after performing Step 6.
Task 1
Following are tables of employee information. Specify an ORM conceptual schema for this UoD.
EMP_PROJ
|
Ssn
|
Pnumber
|
Hours
|
Ename
|
Pname
|
Plocation
|
|
123456789
|
1
|
32.5
|
Smith, John B.
|
ProductX
|
Bellaire
|
|
123456789
|
2
|
7.5
|
Smith, John B.
|
ProductY
|
Sugarland
|
|
666884444
|
3
|
40.0
|
Narayan, Ramesh K.
|
ProductZ
|
Houston
|
|
453453453
|
1
|
30.0
|
English, Joyce A.
|
ProductX
|
Bellaire
|
|
453453453
|
2
|
20.0
|
English, Joyce A.
|
ProductY
|
Sugarland
|
|
333445555
|
2
|
10.0
|
Wong, Franklin T.
|
ProductY
|
Sugarland
|
|
333445555
|
3
|
10.0
|
Wong, Franklin T.
|
ProductZ
|
Houston
|
|
333445555
|
10
|
10.0
|
Wong, Franklin T.
|
Computerization
|
Stafford
|
|
333445555
|
20
|
10.0
|
Wong, Franklin T.
|
Reorganization
|
Houston
|
|
999887777
|
30
|
30.0
|
Zekata, Alicia J.
|
Newbenefits
|
Stafford
|
|
999887777
|
10
|
10.0
|
Zekata, Alicia J.
|
Computerization
|
Stafford
|
|
987987987
|
10
|
35.0
|
Jabbar, Ahmad V.
|
Computerization
|
Stafford
|
|
987987987
|
30
|
5.0
|
Jabbar, Ahmad V.
|
Newbenefits
|
Stafford
|
|
987654321
|
30
|
20.0
|
Wallace, Jennifer S.
|
Newbenefits
|
Stafford
|
|
987654321
|
20
|
15.0
|
Wallace, Jennifer S.
|
Reorganization
|
Houston
|
|
888665555
|
20
|
Null
|
Borg, James E.
|
Reorganization
|
Houston
|
EMP_DEPT
|
Ename
|
Ssn
|
Bdate
|
Address
|
Dnumber
|
Dname
|
Dmgr_ssn
|
|
Smith, John B.
|
123456789
|
1965-01-09
|
731 Fondren, Houston, TX
|
5
|
Research
|
333445555
|
|
Wong, Franklin T.
|
333445555
|
1955-12-08
|
639 Voss, Houston, TX
|
5
|
Research
|
333445555
|
|
Zekata, Alicia J.
|
999887777
|
1968-07-19
|
3321 Castle, Spring, TX
|
4
|
Administration
|
987654321
|
|
Wallace, Jennifer S.
|
987654321
|
1941-06-20
|
291 Berry, Bellaire, TX
|
4
|
Administration
|
987654321
|
|
Narayan, Ramesh K.
|
666884444
|
1962-09-15
|
975 FireOak, Humble, TX
|
5
|
Research
|
333445555
|
|
English, Joyce A.
|
453453453
|
1972-07-31
|
5631 Rice, Houston, TX
|
5
|
Research
|
333445555
|
|
Jabbar, Ahmad V.
|
987987987
|
1689-03-29
|
980 Dallas, Houston, TX
|
4
|
Administration
|
987654321
|
|
Borg, James E.
|
888665555
|
1937-11-10
|
450 Ston, Houston, TX
|
1
|
Headquarters
|
888665555
|
Task 2
Map the following ORM schema to a relational database schema.
Attachment:- Database Management.rar