Homework Questions? Ask a Tutor for Answers ASAP
Hello and thank you for using JustAnswer. It would be my pleasure to assist you with this.
Did you create this ERD? There are serious design issues with the ERD that make implementing this a significant challenge. Composite keys are being used incorrectly, there are foreign key references that are not permitted in oracle, and the design violates second normal form.
If you created this ERD, then we need to rewrite it into something workable. Please let me know by when you need this completed and if you would like me to create an ERD that will work in Oracle.
Yes - I created it. I am learning this so I am in the basic steps of creating ERDs. If you need to rewrite it...its ok. If you can complete it by end of business today would be great. Let me know if you have other questions or concerns. Thanks for your help.
J. Smith, Inc. has five employees and generates large amounts of receipts every month and has had difficulty keeping track of company expense receipts. The company issues each employee one credit card. The credit cards can be used for office expenses, meals with clients, and travel expenses. Each time an employee has a meal with a customer it must be tracked to fulfill IRS regulations. The company must keep a record of the date of the meal, cost, and reason for the meal with each person in attendance. Create an ER diagram that captures this scenario using crows foot notation.
Thank you very much for your assitance. Can I contact you for further work? You did a great job. Greatly appreciated.
I need your help with some more homework...but I am having problems uploading the word document to you. Any suggestions? Thanks.
Here you go...http://www.ge.tt/47F4Jhj/v/0?c
Let me know.Thanks again.