Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

English Sentence Structures and EER Modeling Sebastian Link Sven Hartmann Department of Information Systems, Information Science Research Centre...

Below is the assignment I need help with. Basically, I need a tutor to help me create a simple ERD and the accompanying sentences. So this is going to require a tutor with good English skills. Attached are some helpful documents for this. Please only attempt to help me if you have knowledge in this area. 

You are tasked to develop a database design for a retail company that involves shipping orders to customers.

Order data includes:

An order date

 A ship date

One or more items on each order which should be identified by a unique ID.

The quantities of each item in the order, the order amount (total per item and per order)

The customer to whom the order is shipped should be added.

Customer data includes:

A unique customer ID

Customer name

Customer address

Items in the inventory have a unique item ID, description, and unit cost.

1. Identify and describe each entity for this application and the attributes of each entity.

2. Develop relationship sentence pairs for each pair of related entities.

3. Develop a Visio ERD using crow’s feet notation based on your relationship sentence pairs.

The following deliverables are what I need help with

The entity descriptions and the attributes for each entity

The relationship sentence pairs

The Visio ERD (take a screen snapshot from Visio and paste into your Word file). Note you do not have to necessarily use Visio. It could be any ERD diagram software.

  • Attachment 1
  • Attachment 2
TABLE OF CONTENTS1 Descriptions of Each Entity and its attributes..........................................................................2 2 Descriptions of the...
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question