IFB105 Database Management Assignment

Assignment Help Database Management System

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

Reference no: EM132686937

Questions Cloud

What is the economic life of the truck project : What if they were abandoned at the end of Year 2? What if they were abandoned at the end of Year 1?

Do some quick research with convincing evidence : Do some quick research (with convincing evidence) that provides five reasons why you should study logistics. List at least three job descriptions

What is the optimal number of euros to be delivered : What is the optimal number of euros to be delivered in the short forward contract according to the minimum variance hedge ratio?

What are all the required summary journal entries : In 20X5, it entered into a $25 million, long-term contract to construct a small office complex. What are all the required summary journal entries

IFB105 Database Management Assignment : IFB105 Database Management Assignment Help and Solution, Queensland University of Technology - Assessment Writing Service

Discuss medical complications that may arise for a child : Medical advances in the care of premature infants now allow babies who are born extremely premature (as early as 24 weeks gestation) to survive.

What kinds of imagery comes to mind as listen : How the two pieces are different, does the music spark your imagination or any emotional/personal responses? What kinds of imagery comes to mind as you listen?

Irr of the investment strategy-bubba : What is the IRR of the investment strategy you recommended to Bubba?

Determine the required return for swifty : Determine the required return for Swifty using the appropriate beta. (Round answer to 3 decimal places, e.g. 3.361%.)

User Account

All Pages