Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
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