Consider the attached ER diagram (please see attachment for ER diagram) as part of a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans.
Answer the following questions based on the ER diagram.
(a) List the strong (nonweak) entity types in the ER diagram.
(b) Is there a weak entity type? If so, give its name, its partial key, and its identifying relationship.
(c) What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram?
(d) List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify your choices.
nventory, imprecise inventory tracking systems and a lack of priorities have the ability to disturb operations and lower profit margins. Just-in-time inventory management, part of Lean Production, and related calculations help managers keep stocking and reordering costs to a minimal level. As a result, the business can sustain or improve profit margins. Other inventory management methods also help reduce costs and maintain adequate inventory turnover times. By utilizing such techniques, inventory levels are kept at sufficient levels to meet consumer demand and inventory turnover is rapid; thus, resulting in a reduction in operations budgets being tied up in inventory sitting on a shelf not being sold. JIT inventory is a popular strategy a company can utilize to increase efficiency and decrease waste by purchasing supplies only when they are needed in the production process, thus reducing overall inventory costs. A negative aspect to this technique is that it requires manufacturers to be able to accurately predict inventory demand (“Just In Time (JIT) Definition | Investopedia,” n.d.). Third, budgeting is an important tool used in both professional and personal settings. Although all budgets are valuable, one of the essential budgets in the business environment is the expense budget. This budget allows management to set preferred spending limits and control cash accordingly. Although budgets are usually created for the organization’s calendar years, they can easily be adjusted throughout the year in agreement with fluctuations in sales or operational activity. One of the most ideal features of an expense budget is that it can be created for each department, as well as the entire organization, which makes it easier for departmental managers to monitor better and manage their spending as needed (DeBenedetti, n.d.). Budgets may not be well received in all areas of the organization; however, they are a necessary part of any business to adequately control spending. Without budgets, managers have the potential to overspend or misapply resources and reduce bottom-line profit. Part II Cost management can be defined as the process of collecting, analyzing, evaluating and reporting of cost information that is used for budgeting, forecasting, pricing, profitability analysis and performance reporting (Berger, 2004, p. 79). Accurate cost information affects both financial and non-financial decision making. Inaccurate >GET ANSWER