Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Consider a Mail_Order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees, each identified by a unique customer number, first and last name, and ZIP code. Each customer of the company is identified by a unique customer number, first and last name, and ZIP code. Each part sold by the company is identified by a unique part number, a part name, price, and quantity in stock. Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.

Consider a Mail_Order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees, each identified by a unique customer number, first and last name, and ZIP code. Each customer of the company is identified by a unique customer number, first and last name, and ZIP code. Each part sold by the company is identified by a unique part number, a part name, price, and quantity in stock. Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.

Principles of Information Systems (MindTap Course List)
Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Big Data
Section: Chapter Questions
Problem 4SAT: The ______________ model is a simple but highly useful way to organize data into collections of...
See similar textbooks
icon
Related questions
Question
  1. Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make.
  2. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS).

NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION.

 

Consider a Mail_Order database in which employees take orders for parts from customers. The data requirements are summarized as follows:

  • The mail order company has employees, each identified by a unique customer number, first and last name, and ZIP code.
  • Each customer of the company is identified by a unique customer number, first and last name, and ZIP code.
  • Each part sold by the company is identified by a unique part number, a part name, price, and quantity in stock.
  • Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Research
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS