Answered Essay: Can you help me create an ER model and business rule for the information provided below:

Can you help me create an ER model and business rule for the information provided below:

An inventory database is required to store and manage all those products.. The company provided the following descriptions about their business::

• The company has multiple suppliers (ddog food manufacturers)).. For each supplier,, its name,, address,, phone number and contact email should be recorded in the database . The company assigns a unique supplier ID to each supplier..

• Each supplier may supply multiple products and a product is supplied only by a specific supplier..

• For each product,, the product name,, product description (sshown as product feature s in the mock – up)),, product image s , number of units in stock,, number of units on order,, and date of t he order entered,, the lead time (tthe number of days from the order date to the delivery date guaranteed by the supplier)),, unit cost paid by the company,, uni t sale price,, discount rate if t he product is currently on sale,, and the total number of units sold up to date.. The company assigns a unique product code for each product..

• To be able to track each food package of a product,, each package is assigned a univ ersally unique bard code.. The code can be used to identify specific packages if they are recalled because of food safety..


Can you help me create an ER model and business rule for the information provided below:

ATL iTrust Pay is a start – up with an innovat ive business model that manages and protects customer credit card information . Its customers can securely store their credit card information in the company’s database.. The customers can then use the unique payment code gen erated by the company for online shopping instead of providing their credit card information to the online stores.. The online stores send the payment code along with customer charges to the company.. T he company in turn passes the charges to the actual cred it card companies to process after verifying the payment code..

The company want s to have a web page to allow customers to create an account and store credit information in a database . The mock – up screen of the web page was shown in Figure 2.. The company p rovided the following descriptions of the credit card management business :

• One customer can only create one account identified by the customer’s email address . A customer can register only one email address.. Note that p asswords are in general not unique..

• O n e customer a c c o u n t may store multiple credit cards a n d a l l t h o s e c a r d s m u s t h a v e t h e s a m e b i l l i n g c o n t a c t n a m e a n d a d d r e s s . T h a t i s , t h e c o m b i n a t i o n o f b i l l i n g c o n t a c t n a m e , a d d r e s s a n d c r e d i t c a r d n u m b e r c a n u n i q u e l y i d e n t i f y a c r e d i t c a r d .

• Multiple customers may share the same phone number and billing address .

• Multiple customers may share the same credit card number.. For example,, all members of a family may have the same credit card number.. But,, the combination of credit card number a n d billing contact name can uniquely identify a customer .

Expert Answer


The above is er model for the first scenario.

Business rules:-

These are the constraints in the business which every one must follow. These rules define what we must do in the business. The business rules which are apt for this scenario are

  • Suppliers must supply quality product according to the norms and because this is related to food items, suppliers must always take atmost care with the expiry date.
  • And the buyer’s also must not tamper or disturb Barcode.
  • In Delivery and accepting return’s should always be processed based on expiry dates otherwise there will be loss of money to either buyer or to the supplier.

The below diagram is the crow’s feet notation model for the same.

Buy Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Help Me Write My Essay - Reasons:

Best Online Essay Writing Service

We strive to give our customers the best online essay writing experience. We Make sure essays are submitted on time and all the instructions are followed.

Our Writers are Experienced and Professional

Our essay writing service is founded on professional writers who are on stand by to help you any time.

Free Revision Fo all Essays

Sometimes you may require our writers to add on a point to make your essay as customised as possible, we will give you unlimited times to do this. And we will do it for free.

Timely Essay(s)

We understand the frustrations that comes with late essays and our writers are extra careful to not violate this term. Our support team is always engauging our writers to help you have your essay ahead of time.

Customised Essays &100% Confidential

Our Online writing Service has zero torelance for plagiarised papers. We have plagiarism checking tool that generate plagiarism reports just to make sure you are satisfied.

24/7 Customer Support

Our agents are ready to help you around the clock. Please feel free to reach out and enquire about anything.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.


Let us write that nagging essay.


Submit Your Essay/Homework Instructions

By clicking on the "PLACE ORDER" button, tell us your requires. Be precise for an accurate customised essay. You may also upload any reading materials where applicable.


Pick A & Writer

Our ordering form will provide you with a list of writers and their feedbacks. At step 2, its time select a writer. Our online agents are on stand by to help you just in case.


Editing (OUR PART)

At this stage, our editor will go through your essay and make sure your writer did meet all the instructions.


Receive your Paper

After Editing, your paper will be sent to you via email.