Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you please use a software and design the ER model of the following: You are required to design a conceptual model of the database

Can you please use a software and design the ER model of the following:
You are required to design a conceptual model of the database system whose requirements specification is given below. Use the ER model that is described in our textbook. Show (min, max) constraints on all relationship types in your ER diagram. Requirements This is a purchase order processing database of Boston Papers Company. The company produces papers and sells them to office supply retail stores. The following is a description of the order processing database and other relevant information. 1. The customers of Boston Papers Company are retail office supply stores (e.g., Officemax, Officedepot, Staples, Walmart, Target, etc.). Each customer has one headquarter and one or more branch stores. 2.2.3. For each customer headquarter, we want to store a unique customer ID, the name of the customer (e.g., Officemax, Officedepot, Staples, Walmart, Target, etc.), the city where the headquarter is located, and the phone number. For each branch store of a customer, we want to keep a branch number and the city where the headquarter is located. A branch number is an integer starting with 1 and is not unique among all branch stores. It is unique only among those that belong to the same retail store. For example, Officemax has three branch stores and their branch numbers are 1,2, and 3; Officedepot has two branch stores and their branch numbers are 1 and 2. Boston Papers produces many different types of papers and each type of paper has a unique type number, the size, the weight, and the unit price. 4. An order is issued by a retail store headquarter. For each order, we want to keep the following information. (1) A unique order number (2) The retail store who issued the order (3) Order date and order amount (in Dollars)(4) The employee(s) of the Boston Papers who handle the order 5. An order consists of one or more suborders. Each suborder has a suborder number. This suborder number is an integer starting with 1 and is not unique among all suborders. It is unique only among those that belong to a particular order. A suborder is shipped to exactly one branch store. A suborder includes one or more paper types. In addition to the suborder number, for each suborder, we want to keep the following information in the database: (1) The branch store the suborder is shipped to (2) Required shipping date (3) Actual shipping date (4) Quantity of each paper type included in the suborder 6. For each employee in the Boston Papers, we want to keep a unique employee ID, the name, the salary, the city where the employee lives, the classification, and the date of birth. 7. An order is handled by at least one employee and at most two employees, and an employee handles at most three orders. The above description is itemized for the sake of description purpose only. You need to read the description carefully and decide whether to model an object/concept as an entity type, a relationship type, or an attribute. Deliverables Documentation A cover page showing the course number, course title, assignment number (e.g., Project Part 1), names of team members, due date, and date submitted. Show all your entity types in following format. Entity Types (example) Name Description Attribute Name Description EMP Multivalued if needed ... Ssn{K} Name {K} Fname Minit Lname ... if needed ...... N N Derived N N DEPT ... Dept_no{K} Dept_name {K}... Num_employees ......... Note: Here, we assume Name is a composite key. N N ... N N N ... Y In the table, use {K} for a key. If there is a weak entity type, indicate the partial key of the weak entity type with {WK}. The component attributes of a composite attribute must be indented. Show all your relationship types in the following format. Relationship Types (example) Name Description Participating Entity Types Name WORKS_FOR if needed ... Structural constraint Attribute Emp (1,1) none Dept (1, n) MANAGES ... Emp (0,1) Mgr_start_date Dept (1,1)............... ER diagram. When drawing an ER diagram you may use our textbook's notation or UML notation. You must draw a diagram using a software (i.e., you must not draw an ER diagram manually). You may use any software to draw an ER diagram.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

3 When might constructivist view of self be not relevant and why?

Answered: 1 week ago