IFB105 Database Management - provision 2A
Project - sever A
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.
Part A is estimate 15 marks, for 15% of the individual.
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.
Friday September 4th 11:59 pm (end of week 7).
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.
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.
|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|
|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 [5 marks]
Map the subjoined ORM schema to a abstract factsbase schema.
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.
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
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
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
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
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