Develop an entity relationship diagram relating the following entities: CUSTOMERDATA. ORDER, ORDERITEM, INVENTORY, REFUNDDATA, SHIPMENTINFO Add...
Develop an entity relationship diagram relating the following entities: CUSTOMERDATA. ORDER, ORDERITEM, INVENTORY, REFUNDDATA, SHIPMENTINFO
Add a primary key and one attribute to each entity. Use Crow’s Feet notation.
Each customer in CUSTOMERDATA entity places zero to many orders in ORDER entity.
Each order in ORDER entity belongs to exactly one customer.
Each order in ORDER entity must consist of at least one item and can contain many orderitems.
Each order item is in exactly one order in ORDER entity.
Each order item consists of a minimum of zero and a maximum of one product in INVENTORY entity.
Each product in INVENTORY entity may be in zero to many order items in ORDERITEM entity.
Each order in ORDER entity consists of zero to many shipments in SHIPMENTINFO entity.
Each shipment is for exactly one order in ORDER entity.
Each refund in REFUNDDATA entity must consist of at least one item and can contain many orderitems.
Each order item is in a minimum of zero and a maximum of one refund in REFUNDDATA entity.
Homework Answers
Add Answer to:
Develop an entity relationship diagram
relating the following entities: CUSTOMERDATA. ORDER, ORDERITEM,
INVENTORY, REFUNDDATA, SHIPMENTINFO
Add...
Problem (40 points) Prepare an Entity Relationship diagram with the cardinalities for the following business rules:...
Problem (40 points) Prepare an Entity Relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares a purchase order, which is sent to a supplier, although ea 2. A supplier is able to ship many different inventory items, although each inventory item can be 3. 4. Each department has only one supervisor. Supervisor must oversee at least one department, but supplier can make many orders. ordered from a specific supplier Each department has at least...
Problem (40 points) Prepare a separate entity relationship diagram with the cardinalities for the following business...
Problem (40 points) Prepare a separate entity relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares many purchase orders, each of which is sent to a specific supplier. 2. Each supplier is able to ship many different inventory items, although each inventory item can be ordered from a specific supplier. 3. Each department has at least one employee. Employees must be assigned to at least one, but possibly more departments. 4. Each department has...
Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small...
Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small database to store information about the online orders. You’re given the following requirements: ⚫ A customer is uniquely identified by his/her email. For each customer, we also record his/her name, phone number and address. The address is composed of suburb and street. ⚫ A rider is uniquely identified by his/her ID. We will keep record of the rider’s age, gender, phone number and available...
Prepare an entity-relationship (ER) diagram using MySQL Workbench for the user requirements described below. Be sure...
Prepare an entity-relationship (ER) diagram using MySQL Workbench for the user requirements described below. Be sure that your ER diagram has the following elements: entities; relationships between entities; primary and foreign keys, and other necessary columns for each entity. Global Trading (GT) is a wholesale business that sells a variety of products; its customers are other businesses. Also GT's vendors are other businesses. GT has the following business rules for the database that the company wants you to design: -A...
Assume two entities ORDER and PRODUCT and the following business rules: An ORDER can contain one...
Assume two entities ORDER and PRODUCT and the following business rules: An ORDER can contain one or more PRODUCTs. A PROUDCT can be in zero or more ORDERs. How would you convert this model into an ERM that displays only 1:M relationships? Be specific and complete. Draw the resulting ERM. 2. What is the difference between entity integrity and referential integrity? Given an example of each. 3. Suppose you have an EMPLOYEE table which has one row per employee. The...
Create an Entity-Relationship Diagram (ERD). In the ERD include the following:
Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...
its about data management entity diagram BM4102 Assessment E X 4 o file:///C:/Users/Admin/Desktop/assisment%20brif/SBM4102 Assessment%20Brief_12_2020_v3%20(1).pdf D Page...
its about data management entity diagram
BM4102 Assessment E X 4 o file:///C:/Users/Admin/Desktop/assisment%20brif/SBM4102 Assessment%20Brief_12_2020_v3%20(1).pdf D Page view A Read aloud 2. Ad + Fit to page TTCLUT), ICLUZI, ICLUSL, ICLUL, ICOUST 1 Course Learny Duncorres: . Assessment Details: The Blue Mountains Financial Services company provides financial services (banking, advisory, tax consulting, auditing, insurance, wealth management etc.) to customers. The company has contracted an outsourcing IT company to develop an Information System. The System database should satisfy the following business rules:...
Question: Draw the ERD for the following situation. Show all entities, attributes, relationships, cardinalities, and modalities....
Question: Draw the ERD for the following situation. Show all entities, attributes, relationships, cardinalities, and modalities. Each student (with attributes StudentID, StudentName, and StudentMajor) must be assigned one advisor (with attributes AdvisorID, AdvisorName, and AdvisorDepartment). Advisors may advise no students or may advise many students. Each student must register for zero or many courses (with attributes CourseID, CourseTitle, and CourseCredits) with the help of one or more advisers. A course may have at least one student registered, and may have...
Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and...
Draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, connectives, and participations. The administrators of Tiny College are so pleased with your design and implemen- tation of their student registration and tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanc- tioned travel. For example, the...
Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
Problem (40 points) Prepare an Entity Relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares a purchase order, which is sent to a supplier, although ea 2. A supplier is able to ship many different inventory items, although each inventory item can be 3. 4. Each department has only one supervisor. Supervisor must oversee at least one department, but supplier can make many orders. ordered from a specific supplier Each department has at least...
Problem (40 points) Prepare a separate entity relationship diagram with the cardinalities for the following business rules: 1. The purchasing department prepares many purchase orders, each of which is sent to a specific supplier. 2. Each supplier is able to ship many different inventory items, although each inventory item can be ordered from a specific supplier. 3. Each department has at least one employee. Employees must be assigned to at least one, but possibly more departments. 4. Each department has...
its about data management entity diagram
BM4102 Assessment E X 4 o file:///C:/Users/Admin/Desktop/assisment%20brif/SBM4102 Assessment%20Brief_12_2020_v3%20(1).pdf D Page view A Read aloud 2. Ad + Fit to page TTCLUT), ICLUZI, ICLUSL, ICLUL, ICOUST 1 Course Learny Duncorres: . Assessment Details: The Blue Mountains Financial Services company provides financial services (banking, advisory, tax consulting, auditing, insurance, wealth management etc.) to customers. The company has contracted an outsourcing IT company to develop an Information System. The System database should satisfy the following business rules:...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago