Friday, May 24, 2019

Wednesday, May 22, 2019

Materials Handling Equipment Corp: Enterprise Systems Drive Corporate Strategy for a Small Business


1. What were the business problems facing MHE? How did they relate to its existing older systems?

            While there can be many problems in a business it seems though it is a declining market. It seems that MHE facing few problems in regards to competition from bigger companies while they reduce the prices. The market was becoming a commodity business focusing on sales of equipment and price which seems moderate for a business. However, while at its Margins were declining. MHE could not differentiate itself from competitors since its business so they decided to drop prices even further which is nothing but chaos. It is more like riding a bicycle with no feet.

2. What were the advantages of working with SAP’s Business One?

            Well after reading it seems the advantages would be Affordable, and powerful enough to address MHE’s business problems. Although it is Configurable, easily implemented, and easy to teach staff how to use the system.  It seems very lenient and nice thing to have. 

3. Why did the new ERP system give the company a competitive advantage?

            There can be multiple reason to why, but to my thought I believe that it allowed MHE to reduce costs and increase revenues which seemed like a good idea at first. It is very important to remember that the ERP system allowed MHE to enter into a new line of business called “customer asset management” in which customers could use an online portal. Now to many this may seem not an important thing but it is very important since now they are able to track the repairs of their equipment and also being able to give the customers visibility into the process. Competitors could not offer this service to begin with. So that’s what I believe.

4. What was the impact of the ERP system on corporate costs and revenues?

            Typically, revenues are something a company should look at. However, in this case Revenues were up 12% and costs were reduced by 30% which I think is very bad for a company.

5. What new revenue generating service was MHE able to provide to its customers? Why did MHE develop a customer portal?

            Well, I think after reading we can all agree that Asset management, in this process customers could see the costs of repairing their equipment. And through the process they can decide about how to proceed for further. It is good because they can now debate into fixing a machine versus buying a new one.

What new revenue generating service was MHE able to provide to its customers? Why did MHE develop a customer portal?


Well, I think after reading we can all agree that Asset management, in this process customers could see the costs of repairing their equipment. And through the process they can decide about how to proceed for further. It is good because they can now debate into fixing a machine versus buying a new one.

Why did the new ERP system give the company a competitive advantage?

There can be multiple reason to why, but to my thought I believe that it allowed MHE to reduce costs and increase revenues which seemed like a good idea at first. It is very important to remember that the ERP system allowed MHE to enter into a new line of business called “customer asset management” in which customers could use an online portal. Now to many this may seem not an important thing but it is very important since now they are able to track the repairs of their equipment and also being able to give the customers visibility into the process. Competitors could not offer this service to begin with. So that’s what I believe.

What were the business problems facing MHE? How did they relate to its existing older systems?


While there can be many problems in a business it seems though it is a declining market. It seems that MHE facing few problems in regards to competition from bigger companies while they reduce the prices. The market was becoming a commodity business focusing on sales of equipment and price which seems moderate for a business. However, while at its Margins were declining. MHE could not differentiate itself from competitors since its business so they decided to drop prices even further which is nothing but chaos. It is more like riding a bicycle with no feet.

Saturday, May 4, 2019

discussion II


The rise of real-time streaming applications and platforms that we use on a daily basis presents challenges to database design and systems.  Cite some of these problems and how you think we can help address the concerns.  What are some of applications that you use daily that would benefit from your proposed improvements? 

While there are many challenges that occurs examples: Choosing among streaming frameworks. Integrating with application architecture, Operational challenges, decreasing costs, Applying Machine Learning, 
3 Main problem and Solution
Unstructured Growth of Data
Solution: A redesigned, all-in-one database designed to handle and store new kinds of information—even when it’s not expected. This kind of future-proofing allows a company to immediately begin collecting and using certain kinds of data when they realize they need it.
Unsecured Databases
Solution: Rather than being stored in disparate “silos,” all information should be contained in one central location, with a single point of entry that can be used to stop unauthorized access. If your previous system was built well for its time, it may be possible to simply add the new security measures—otherwise, a new database may be necessary.
Finding Qualified Database Administrators
Solution: If you can’t find someone, raise them. You may have to help pay for their training and education, but this is an increasingly important role in modern businesses, and it’s vital to have someone who is genuinely qualified for the position.
 I use web streaming, mobile applications such as uber/lyft, medical devices such as for people that checks their diabetes every day and keeping record etc.

DATABASE MANAGEMENT SYSTEM Hands-On Assignments 1 to 5





Hands-On Assignments
To perform assignments 1 to 5, refer to the table structures in Figure 1-5 and the table listings in Appendix A.

1. Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped?

Table CUSTOMERS-Customer#, Table ORDERS-Order#, Shipdate, Customer#, ORDERITEMS-Order#, and the table BOOKS- isbn and title are the tables and field I would access to determine which book titles have been purchase by a customer and the order shipped.

2. How would you determine which orders have not yet been shipped to the customer?

I would determine which orders have not been shipped to the customer by classifying which all orders that does not include admittance for the dates shipped.

3. If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information?

The tables and fields that they would consult to derive that information would include ORDERS: Orderdate, Order#, ORDERITEMS, ISBN, Quantity and the field Paideach.

4. Explain how you would determine how much profit was generated from orders placed in April 2009.

In the beginning the amount of profit generated should be Determined by each book on an order item. Then, increase the profit for each book by the quantity purchased. After that, total the amount of profit generated by all orders placed in April.

5. If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the customer’s request?

The access path that they would need follow to find list of books meeting the customer’s request, would be tables; AUTHOR, BOOKAUTHOR and BOOKS, with the fields; Lname, AuthorID, Pubdate and ISBN.

 Create an initial database design (E-R model) for a library that will serve a local elementary school. Please include entities, attributes, primary keys and relationships in your answer. Also, write down basic assumptions that your database library would (and would not) support, similar to the Basic Assumptions section on page 13.
Basic Assumptions:
·        Students will borrow books based to help with school assignments but most will borrow reading books as it’s an elementary school
·        Regular follow-ups will be done for books that are outstanding, as some students might be waiting to borrow a book that has not been returned
·        The database won’t have much discrepancies, as the librarian would be familiar with the students, as it will be located within the school, and follow-ups can be done on a daily basis