Garden Glory chapter 1 Essay

Build an Excel spreadsheet to estimate how much a prospective customer is worth, depending on whether that customer is offered a rebate. What do you learn from the updated spreadsheet? Explain the logic behind your findings and

This causes an inconsistency in the data since it was only updated in one location and not all locations. Insertion anomalies occur due to the impossibility to store some information unless other information is stored as well. Deletion anomalies are caused by information being deleted that may cause other information to be deleted as well. This means it may not be possible to delete some information without deleting other information as well. That is why it is important to use normalization when creating databases to help alleviate these problems.

5.     Building Information - Floor Space, Lease Owner, and Lease Rate should be in its own table.

For the true false answers only submit the question number and answer -- do not include the question in your answer sheet.  For other questions/problems, please show all of your work for full credit.  One Excel attachment is preferred -- do not send in more than one attached file.

The next part requires detailed address of the premises including name of the Apartment, City, and Florida Zip Code.

With Microsoft Access I have created a database. The Database has been made to help staff and Equest systems to carry out then business sales operations effectively and efficiently. The Database which I have created is a computer based Database; it is produced for EQuest System. In this Database you can discover that I have made it easy so it user friendly. Firstly I have created tables; the first table which I have created is a customer table. In this table there is information

Question #1 is worth 5 points – all others are worth 1 point each. Either type your answers directly onto THIS sheet OR create a new file and number your answers 1, 2, 3, etc.

Object Relational Mapping (ORM) is a programming technique for converting data between incompatible types in object oriented programming languages. ORM can be considered as a mechanism that helps and aids in addressing, accessing and manipulating data without having to necessarily consider the relationship between the data and the data source. Programmers can maintain a constant view of objects over time and can adapt to application access or data delivery changes while using ORM. ORM manages the mapping properties amongst a set of objects that have underlying relational databases, repositories or other sources of data that simultaneously hide constant details that have been changed in related interfaces from the developers and the code they create. ORM makes it theoretically possible for developers to switch applications between relational databases. Since ORM tools mostly rely heavily on metadata of both the database and objects, the objects do not need to know anything about the database and the database doesn’t need to know anything about how the data is structured in the application. ORM provides a clean well designed data application.

Operational systems are optimized for preservation of data integrity and speed of recording of business transactions through use of database normalization and an entity-relationship model. Operational system designers generally follow the Codd rules of database normalization in order to ensure data integrity. Relational databases are efficient at managing the relationships between these tables. The databases have very fast insert/update performance because only a small amount of data in those tables is affected each time a transaction is processed. Finally, in order to improve performance, older data are usually periodically purged from operational systems.

5A, be sure to think critically about the possible errors that are described. In your answer,

Your final Excel workbook submission should contain the following items. You cannot use any other software but Excel to complete this project.

B.) Could Excel ever be too smart. I think that they can keep working to make Excel a better program. I also think that if it gets better that someday all we will have to do is get on our laptop, computer, or any device to do all of our work. At this point I don’t see Excel been smart. I feel that they can always improve

Note: All requirements must be met to earn points. While you may design your spreadsheet in a way that works well for you, failure to incorporate these elements will

1. A spreadsheet with the lease or buy NPV analysis has been given to you.

3. Describe the value drivers of the replacement decision. 4. Calculate an appropriate discount rate for evaluating the sheeter replacement decision. 5. Perform a net present value analysis of the sheeter replacement decision. While it is possible to perform such an analysis looking at the changes in all cost items, for this analysis, please calculate the present value of future costs assuming the old sheeter is retained and assuming the old sheeter is replaced. The net present value of the replacement would be the difference between these two values.