Reverse Engineering [20 points]This question tests how well you understand the algorithm for converting E/R diagrams to relational schemas. An E/R diagram when converted to relations (using the mechanical construction that we know and love) gives rise to the following relations:R(a, b, c)S(a, d)T(a, d, f, g)You may assume that the same symbols refer to the same attribute and different symbols refer to different attributes (e.g., the attributes a in the relations R, S and T are the same) i.e. it ultimately comes from a single entity set or relationship in the E/R diagram.Your task is to reverse-engineer the E/R diagram from these relations; in other words, what E/R diagram could have produced these relations. For full credit, give two different E/R diagrams that could have produced these (and only these) relations (i.e. 10 points for each correct E/R diagram).Submission Guidelines and RequirementsInclude your name and UCM ID in the assignmentAdd the following statement in your solution “I certify that the codes/answers/outputs of this assignment are entirely my own work.”// Your Name// Your UCM ID//Certificate of Authenticity: “I certify that the assignment is entirely my own work.”Add comments to your submission as much as possibleSubmit your ER diagrams, relation schemas, functional dependencies and normalized formsZip your files and upload the zipped file onto BlackboardThere could be more than one correct answer. We shall accept them allWhenever you are making an assumption, please state it clearlyGrading standards:There will be automatic 10 points penalty if your submission is missing certificate of authenticityLate submission: Late submission is allowed with a 10% deduction per day (delay in submission). Submission after 3 days of the deadline won’t be acceptedFor more information on Reverse Engineering check on:https://en.wikipedia.org/wiki/Reverse_engineering
Top-quality papers guaranteed
100% original papers
We sell only unique pieces of writing completed according to your demands.
We use security encryption to keep your personal data protected.
We can give your money back if something goes wrong with your order.
Enjoy the free features we offer to everyone
Get a free title page formatted according to the specifics of your particular style.
Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.
Don’t pay extra for a list of references that perfectly fits your academic needs.
24/7 support assistance
Ask us a question anytime you need to—we don’t charge extra for supporting you!
Calculate how much your essay costs
What we are popular for
- English 101
- Business Studies