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...
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...
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...
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:...
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....
2.Which of the following statements are true? (Check all that apply.) A.In an REA diagram, each...
2.Which of the following statements are true? (Check all that apply.) A.In an REA diagram, each event is linked to at least one resource. B.In an REA diagram, each event is linked to at least one other event. C.In an REA diagram, each relationship is linked to at least one resource. D.In an REA diagram, each relationship is linked to at least one agent. 2.Which of the following statements is true? A.The maximum cardinality is used to indicate whether the...
Database 1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following...
Database
1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...
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....
Database
1. Draw an Entity-Relationship diagram(including cardinality ratio and participa- tion constraint) to represent the following application: A DEPARTMENT has a number of TEACHERS and each TEACHER is affil- iated only with one DEPARTMENT; A STUDENT has only one TEACHER as an advisor, but a TEACHER can advise many STUDENT; on the other hand, TEACHER instructs many STUDENTS, and a STUDENT has a number of instructors. Different AGENCIES support different TEACHERS for various PROJECTS. (15 points) A trucking company is...
Most questions answered within 3 hours.
-
What is precedent?
an order by the court.
the power of a court to overrule a...
asked 5 minutes ago -
Classify the tonicity of a solution made by dissolving 12mg of
sodium chloride in 1.0mL of...
asked 11 minutes ago -
Consider the equilibrium reaction: 2A (aq) + 3B (aq) <-->
C (aq) (in my notation <-->...
asked 12 minutes ago -
A recent poll found that 21% of a random sample of 1200 people
lost jobs due...
asked 18 minutes ago -
Indicate whether aqueous solutions of the following substances
contain ions. If so, write formulas for the...
asked 14 minutes ago -
Include at least one psychology theory, model or concept
discussed in Chapter 1, 2 or the...
asked 24 minutes ago -
Need help in drawing out a map pathway of pentose phosphate
pathway and pyruvate dehydrogenase/citric acid...
asked 31 minutes ago -
Question 1
At the end of Year 6,
South Co.'s tax department estimates that they will...
asked 33 minutes ago -
Use standard enthalpies of formation to determine
ΔHorxn for:
1. 3NO2(g) + H2O(l) → 2HNO3(aq)
+...
asked 37 minutes ago -
Abigail Adams was hired as an associate professor of economics
at Heartland University. She was the...
asked 39 minutes ago -
consider the overall reaction: AB(g) + CB(g) ⟶ A(g) + CB2(g)
A proposed mechanism for this...
asked 46 minutes ago -
In fruit flies, assume bright red eyes (r) and curly wing (w)
are encoded by two...
asked 1 hour ago