Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
I will have access to this database so that I can correctly and quickly inform clients or vendors about the status of their products. The products inventory database should include item/SKU number; date of acquisition; quantity in stock; item description; number of pending orders from clients; number of pending orders from vendors; cost; selling price; and weight, for the purposes of shipping and receiving. If we maintain the products inventory database, we will not risk running out of items prematurely, or overstocking our shelves. We would also ensure that our pricing accurately reflects our costs.
2. I also recommend creating a database to maintain client and vendor records. Because we are a small and new company, the use of databases in this area has had limited use. However, our vendor list currently tops fifteen, and we have over twenty-five clients. It is becoming increasingly difficult to maintain accurate records of both vendors and clients. Starting the database now will save time in the future and ensure a smooth transition to electronic data maintenance. Information we would include in the client and vendor database would include basics such as company name, address, and contact information. We would also want to maintain records of business transactions so that we will be aware of our best, most trustworthy clients.
3. Intensive, thorough training in the use of database systems, in particular Microsoft Access, will increase productivity. It is unacceptable that so few company personnel have...
Intimidation results from ignorance, and the only way to correct for the lack of familiarity with Microsoft Access is to provide training for office personnel. All personnel using databases should be required to attend the training sessions, including personnel from shipping and receiving and from the warehouse. The training could entail an in-house workshop or an outsourced program at a local college or university. At the request of management, I will investigate the options and make an informed recommendation.
CONCLUSION
Creating three databases, one for products inventory, one for vendor information, and one for client information, should take no more than one or two days. We will lose little in terms of time or resources, especially as this is our slowest time of the year. I would recommend getting started on the new database projects as soon as possible, to eliminate any lag time.
Similarly, I would recommend commencing the training program as soon as possible. I can compose a company-wide memo pertaining to the training sessions as soon as I investigate our options. We should hold a meeting to discuss these matters further.
Works Cited
Works Cited
References
Chappele, Mike. "Choosing a Database Product." About.com. Online at http://databases.about.com/od/administration/a/choosing.htm.
Chappele, Mike. "Database Fundamentals." About.com. Online at http://databases.about.com/od/administration/a/databasefund.htm..
Database Administrator for Department Store Scenario The department store has expanded in the local region by opening five more bookstores, and the bookstore has launched a series of marketing campaign to increase sales and attract new customers. The objective of this technical report is to develop a plan to create and maintain an enterprise-wide database system that will assist the bookstore to hold the inventory and sales data. The database design will
Database Modeling and Normalization Entity Relationship Model (ERM) Diagram is a data model used to describe the database in an abstract method. The relational database stores data in table. The entity in the database could point to several entries. For example, employee is an entity in the relationship database, and a diagram used to create the entity in the database is called entity-relationship diagrams or ER diagrams. (Silberschatz, Korth, 2006). Objective of
Design criteria exist at the levels of the technical, system integration aspects of the database to other systems through XML. This integration is critically important to ensure that the applications created can be effectively used over time and not have any scalability issues. There is also the need for designing the databases at the presentation layer to provide for scalability and flexibility of being able to create applications relatively quickly
Database Administrator, Manager of IT, and the value of a college education As a result of swift distribution of computers and information technology, a necessity for well trained workers to design and promote new hardware and software systems and to integrate new technologies. These workers comprises of computer systems analysts, database administrators, and computer scientists. Based on the choices and procedures of employers and on development of new areas of specialization
Databases and Regulatory Compliance Challenges The advent of technology has increased the popularity of database usage in firms, yet the legislation regulating the field has yet to be finalized. The changing nature of the IT sector, coupled with the legislative traits, creates several situations in which the companies find it difficult to comply with the regulations. This paper recognizes some of those difficulties, and also proposes some solutions. Databases Regulatory challenges for databases No
These personal productivity systems also tend to be islands of customer data that need to be integrated into larger customer information systems to be effective (Zahay, 2008). Enterprise-class DBMS are capable of integrating to broader process workflows due to their underlying technical design. In addition, these DBMS are often used for more advanced customer strategies including data mining, business analytics of customer bases, and the development of long-term loyalty