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 .