country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

BSA 545 Master Data Model For Relationship Between The Orders

tag 0 Download2 Pages / 476 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Questions:

1. Create a 5- to 7-slide presentation defining the key data points of your Entity Relationship Diagram (ERD) model you created in Week Two.

2. Describe the value of these data points and their relevance to each table.

 

 

Answer:

The master data model has been be implemented in this project. The database is based on the process of merging the initial data base or the Master data base with the new Human Resource data base into a single one. This needs to be completed with the implication of zero loss in the data of the two data base. Apart from this there needs to be the consistency of the data integrity in the system so that no connection is lost in the data. There should also be the consideration of no loss in the data during the process of transferring of the data.
 
The entity relationship diagram shows the relation between the six tables which are to be used for the completion of the project. The details of the employees and the customers are to be stored in separate tables. The details of the orderdetails would be used for the connection of the order table and the product table for each customer. The supplier is responsible for the delivery of each of the products from the product table. All details are stored in the table for future reference.
 
The key data points for the table are 

 

 
Employee: Stores the details of the employees working for the company. The employees are responsible for the collection of different orders from the customers.
 
Product: this table stores the details of the products which are available for sale by the company.
 
Order: this entity is responsible for the storage of the order which has been placed by the customer
 
OrderDetails: this entity is responsible for the storing of the relationship between the orders and the product. This entity consists of the associative keys with the orderID and the productID.
 
Customer: this entity stores the details of the customers who are using the service
 
Supplier: this entity is responsible for the storing of information related to the suppliers who are responsible for the delivery of the products.
 
The values that are stored in each of the entities of the database are as follows:
 
Employee stores employeeID, firstName, lastName, address, phone
 
Product stores productID, productName, unitPrice, supplierID
 
Order stores orderID, orderDate, totalValue, employeeID, customerID
 
OrderDetails stores orderID, productID, quantity
 
Customer stores customerID, firstName, lastName, address, phone
 
Supplier stores supplierID, companyName, address, phone 

 

 
Relevance of the use of each of the tables are discussed below:
  • The employees are responsible for the collection of the orders from the customers
  • Each product is linked to a supplier who is responsible for the products delivery.
  • Order details consists of the orderID and the productID which is to be delivered
  • Customers book an order from the company
  • The supplier reviews the order and delivers the product.
  • All details are stored in the database for reference.
Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Master Data Model For Relationship Between The Orders. Retrieved from https://myassignmenthelp.com/free-samples/bsa-545-master-data-model-for-relationship-between-the-orders.

"Master Data Model For Relationship Between The Orders." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/bsa-545-master-data-model-for-relationship-between-the-orders.

My Assignment Help (2020) Master Data Model For Relationship Between The Orders [Online]. Available from: https://myassignmenthelp.com/free-samples/bsa-545-master-data-model-for-relationship-between-the-orders
[Accessed 12 August 2020].

My Assignment Help. 'Master Data Model For Relationship Between The Orders' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/bsa-545-master-data-model-for-relationship-between-the-orders> accessed 12 August 2020.

My Assignment Help. Master Data Model For Relationship Between The Orders [Internet]. My Assignment Help. 2020 [cited 12 August 2020]. Available from: https://myassignmenthelp.com/free-samples/bsa-545-master-data-model-for-relationship-between-the-orders.


If you are stuck with complicated homework assignments, look nowhere else and count on the expertise of MyAssignmenthelp.com. Our team of diligent writers know how to take charge of some of the trickiest homework topics. Simply ask us to “do my homework” and take home flawlessly drafted papers, much ahead of the specified deadline. From descriptive homework writing to answering tricky questions on your behalf; we shall have you covered with the best primary homework help online. So, ask us to “write my paper now.

Latest Management Samples

LCBS5001 Strategic Management01

Download : 0 | Pages : 20
  • Course Code: LCBS5001
  • University: De Montfort University
  • Country: United Kingdom

Answer: Introduction This report will evaluate the business strategy of the organization named Amazon Inc. A strategic analysis will comprise of the various strategic tools and models such as Porter's Five Forces, SWOT analysis, VRIO analysis, strategic fit model, and strategy clock and warfare perspective. These tools will evaluate Amazon's business strategy to provide valuable insights into the organization's strategy and the reason for the...

Read More arrow Tags: United Kingdom Leicester Management Solid work assignment University of London 

LCBS5001 Strategic Management01

Download : 0 | Pages : 20
  • Course Code: LCBS5001
  • University: De Montfort University
  • Country: United Kingdom

Answer: Introduction This report will evaluate the business strategy of the organization named Amazon Inc. A strategic analysis will comprise of the various strategic tools and models such as Porter's Five Forces, SWOT analysis, VRIO analysis, strategic fit model, and strategy clock and warfare perspective. These tools will evaluate Amazon's business strategy to provide valuable insights into the organization's strategy and the reason for the...

Read More arrow Tags: United Kingdom Leicester Management Solid work assignment University of London 

LCBS5001 Strategic Management01

Download : 0 | Pages : 20
  • Course Code: LCBS5001
  • University: De Montfort University
  • Country: United Kingdom

Answer: Introduction This report will evaluate the business strategy of the organization named Amazon Inc. A strategic analysis will comprise of the various strategic tools and models such as Porter's Five Forces, SWOT analysis, VRIO analysis, strategic fit model, and strategy clock and warfare perspective. These tools will evaluate Amazon's business strategy to provide valuable insights into the organization's strategy and the reason for the...

Read More arrow Tags: United Kingdom Leicester Management Solid work assignment University of London 

ICT167 BookStore Application For Calculating Total Stock Amount

Download : 0 | Pages : 13
  • Course Code: ICT167
  • University: Murdoch University
  • Country: Australia

Answer: The Bookstore Application Summary The application has been built using the JAVA language. The console-based application is meant to serve the purpose of maintaining a bookstore. The user can switch into the system as an administrator and add, view, update or delete books from the collection generated. The program generates an initial array of books and allows the user to add to it. Each book has a unique ISBN, title, author, publishi...

Read More arrow

NIT2101 Ambersfield Security Solution For Computer And Internet Security

Download : 0 | Pages : 10
  • Course Code: NIT2101
  • University: Victoria University
  • Country: Australia

Answer: Introduction Ambersfield College of Medicine (ACM) is an academic health center with mission to provide best medical care to patients and enlightening new expertise. The organisation promotes its vision by redefining many creative and technical methods to provide best care to patients. ACM has covered a vast area over 12 acres which includes around 10 buildings and around 2000 devices in the system. ACM provides high q...

Read More arrow Tags: Australia Lugarno Management Humanities University of New South Wales 
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,383,986

Orders

4.9/5

Overall Rating

5,086

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2830 Order Completed

97% Response Time

Leroy Bicknell

MBA in Marketing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

230 Order Completed

97% Response Time

Liya Han

Master Of Science in Geotechnical Engineering (MSc Geotec)

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Awesome work. Awesome response time. Very thorough & clear. Love the results I get with MAH!

flag

User Id: 383727 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Work was done in a timely manner took it through grammarly checked for plagiarism very well satisfied

flag

User Id: 463334 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Great work for the short notice given. Thank you for never disappointing and helping out.

flag

User Id: 194216 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

I received a full point on the assignment. Thank you for all the help with the assignment.

flag

User Id: 411395 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?