Answered step by step
Verified Expert Solution
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. The customers of Boston Papers Company are retail office supply stores eg Officemax, Officedepot, Staples, Walmart, Target, etc. Each customer has one headquarter and one or more branch stores. For each customer headquarter, we want to store a unique customer ID the name of the customer eg 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 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 and ; Officedepot has two branch stores and their branch numbers are and 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. An order is issued by a retail store headquarter. For each order, we want to keep the following information. A unique order number The retail store who issued the order Order date and order amount in Dollars The employees of the Boston Papers who handle the order An order consists of one or more suborders. Each suborder has a suborder number. This suborder number is an integer starting with 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: The branch store the suborder is shipped to Required shipping date Actual shipping date Quantity of each paper type included in the suborder 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. 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 objectconcept as an entity type, a relationship type, or an attribute. Deliverables Documentation A cover page showing the course number, course title, assignment number eg Project Part 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 SsnK Name K Fname Minit Lname if needed N N Derived N N DEPT DeptnoK Deptname K Numemployees 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 WORKSFOR if needed Structural constraint Attribute Emp none Dept n MANAGES Emp Mgrstartdate Dept 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 ie 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started