Answer:
See explaination
Explanation:
Entity-Relationship (ER) Model can be described as a data model that is based on the notion of real-world entities and relationships among them. While formulating real-world scenario into the database model, the ER Model creates entity set, relationship set, general attributes and constraints.
ER Model is best used for the conceptual design of a database.
ER Model is based on −
Entities and their attributes and
Relationships among entities.
Please kindly check attachment for the entity relationship model of the business.
Smart people who know the systems well and are good at cooperation and communication.
Answer:
See explaination
Explanation:
No of Mobiles=x1
No of Work stations=x2
Constraints:
50x1+70x2<=1,60,000
250x1+700x2 <= 1,20,00,000
x1>=0 x2>=0
Objective function N(x1,x2)= 7800000000 x1+ 7200000000 x2
Excel formulae:
G17 =D9*E7+F9*G7
G18= D10*E7*F10*G7
G19=E7
G20=G7
G21= I17*E7+I18*G7 (This will be Maximum)
And E7 and G7 will be solution.
Prepare sheet as shown in diagram and set the formulae.
Go to tool and select solver. Solver dialog will open, select ‘Assume Linear model’ and ‘assume non-negative’. Click solve model and click keep solution.
See attachment.