Database design and er modeling

Please see attachment before proceeding with directions below.


Case Assignment

Entity-Relationship Modeling 

  1. Fill in the column headings in row one of each table (Customer,  Employee, and Sales Order) with the data items (attributes) you believe  belong in the table.
  2. Draw an ER diagram for the three tables: Customer, Employee, and Sales Order.
    Suppose  the Sales Order Table also contains information for an employee who  makes a sale. If you have an ERD drawing tool such as Visio, you could  draw the diagram using the tool and copy it into your document. You  could also draw it on paper, scan it, and insert it into your document.  If you can’t do either of the above, you could write down the table  schemata and describe the relationships among them.
  3. Submit the document. Make certain the table title, course number, and module and Case ID are on the work you submit.
  4. Describe the major points you learned in the readings especially on  entity relationship modeling and what lessons you have learned in this  exercise. (at least half a page).

Please note that you will need to study the background materials for your assignment.

Assignment Expectations

You are required to:

  • Design tables based on domain requirements.
  • Represent database design using ERD.
  • Communicate effectively with the readers of your report.
Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.