Database Management

IFB105 Database Management - provision 2A

IFB105 Database Management

Project - sever A

Project overview

The IFB105 contrivance gives you an occasion to dedicate concepts and skills you adventitious in the individual to a realistic factsbase intention scenario and consider on the facts requirements of an organisation.

The inferiority is disjoined into 2 severs due at unanalogous times during the semester. These severs succeed cover:

A. Intention of a factsbase

B. Creation and use of a factsbase

The function for sever A

In this sever, you succeed:

1. Intention an ORM conceptual schema for a profession estate domiciled on exemplification reports required for that estate.

2. Map a unanalogous ORM schema to a abstract factsbase schema.

Weighting

Part A is estimate 15 marks, for 15% of the individual.

Groups

This provision can be performed partially or in couples.

If you appropriate to operation in a couple, singly one student should yield the provision. Please agree the indicate and student calculate of the individual you operationed behind a while on the front page. No suspect succeed be abandoned to any student who claims to feel performed past operation than the other student in his/her couple, consequently this provision can be performed partially.

Doing the provision in undeclared classs, or classs larger than two students, succeed be treated as plagiarism. Pairs that operation concomitantly and then disunite due to difficulties must not yield any of the identical operation, or it succeed be treated as plagiarism.

Due continuance

Friday September 4th 11:59 pm (end of week 7).

Submission

For this impost, you should yield a professionally presented Word instrument containing your answer to each function. For Function 1, ORM schemas should be created using a computer scheme program, such as Lucid Chart or describe.io. For Function 2, the abstract schema must be entered using either the notation taught in lectures and tutorials. You should annotate the basic abstract schema to fix all the ORM constraints and subtype definitions are taken. Partial or amply handwritten inferioritys succeed not be legitimate. Your instrument needs to be uploaded to the inferiority conjoin on Blackboard.

Late inferiority

Assessment operation yieldted behind the due continuance succeed be remarkable singly behind a while an favorite production (MOPP E/6.8.2). Impost operation yieldted behind the due continuance behind a whileout an favorite production or, where an production has been granted, behind the unabrupt due continuance, succeed not be remarkable and a proceeding of 1 or 0% succeed be awarded across the impost individual.

Please note: productions succeed not be granted for class (2 members) inferioritys, unmindful of the deduce.

Part A functions

Note the subjoined points to lay your answers:

1. Population is forcible and no elevate description is required from the estate alert. In other tone, heave out your CSDP steps 1 to 6 for the abandoned facts singly.

2. We strongly approve that you heave out your CSDP steps starting from Step 1 and conclusion in Step 6 to lay your developed ORM diagram. But you are not required to yield results of these steps partially.

3. You are singly required to yield your developed ORM diagram obtained behind performing Step 6.

Task 1 [10 marks]

Following are tables of employee notice. Specify an ORM conceptual schema for this UoD.

EMP_PROJ

SsnPnumberHoursEnamePnamePlocation
123456789132.5Smith, John B.ProductXBellaire
12345678927.5Smith, John B.ProductYSugarland
666884444340.0Narayan, Ramesh K.ProductZHouston
453453453130.0English, Joyce A.ProductXBellaire
453453453220.0English, Joyce A.ProductYSugarland
333445555210.0Wong, Franklin T.ProductYSugarland
333445555310.0Wong, Franklin T.ProductZHouston
3334455551010.0Wong, Franklin T.ComputerizationStafford
3334455552010.0Wong, Franklin T.ReorganizationHouston
9998877773030.0Zekata, Alicia J.NewbenefitsStafford
9998877771010.0Zekata, Alicia J.ComputerizationStafford
9879879871035.0Jabbar, Ahmad V.ComputerizationStafford
987987987305.0Jabbar, Ahmad V.NewbenefitsStafford
9876543213020.0Wallace, Jennifer S.NewbenefitsStafford
9876543212015.0Wallace, Jennifer S.ReorganizationHouston
88866555520NullBorg, James E.ReorganizationHouston

EMP_DEPT

EnameSsnBdateAddressDnumberDnameDmgr_ssn
Smith, John B.1234567891965-01-09731 Fondren, Houston, TX5Research333445555
Wong, Franklin T.3334455551955-12-08639 Voss, Houston, TX5Research333445555
Zekata, Alicia J.9998877771968-07-193321 Castle, Spring, TX4Administration987654321
Wallace, Jennifer S.9876543211941-06-20291 Berry, Bellaire, TX4Administration987654321
Narayan, Ramesh K.6668844441962-09-15975 FireOak, Humble, TX5Research333445555
English, Joyce A.4534534531972-07-315631 Rice, Houston, TX5Research333445555
Jabbar, Ahmad V.9879879871689-03-29980 Dallas, Houston, TX4Administration987654321
Borg, James E.8886655551937-11-10450 Ston, Houston, TX1Headquarters888665555

Task 2 [5 marks]

Map the subjoined ORM schema to a abstract factsbase schema.

1

3

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency