Organizational Databases

Organizational Databases Randal Chatman University of Phoenix CIS 207 Information System basics Carlos Andrade December 19, 2011 Abstract This paper is intentional to discuss the structure and hold of a database form that is currently being enjoymentd by a nationally recognized telecommunications and entertainment company. It will contain selective selective information almost the item type of database that is being used by this company. According to Webopedia, a database is a collection of information nonionised in such a way that acomputerprogram lowlife quickly getdesired pieces ofdata.You can think of adatabaseas an electronic registersystem (Database, 2011). Every company has most type of database system that holds information that impoverishments to be irritateed regularly by the employees to be used to consummate a task or goal. There will be some recommendations of improvements to the company procedures of the use of the described database. Organizational Datab ase Now that we be in the computer age we no longer need to use a pen and a sheet of paper to write subdue information that we will need to refer game to in the future.Nor will we need to use a filing system with folders and large clunky cross-file cabinets to store company information. In todays parentage human companies use databases to store company information and cover it organized. What exactly is a database? According to Webopedia, a database is a collection of information organized in such a way that acomputerprogramcan quicklyselectdesired pieces ofdata. You can think of adatabaseas an electronic filingsystem (Database, 2011). Companies in todays business world use databases to organize various types of information for the benefit and use of its employees to complete a task.In order for computers to access the database, it will need a database performance. A database application is a computer program whose primary function is entering and retrieving information fro m a computer managed database (Database Application, 2011). There are several(prenominal) types of data base applications such as Microsoft Access, prophesier, and My SQL. vaticinator is a database application that we will look at in a little much detail as it pertains to a specific department of nationally recognized business. Oracle has been around and creating database technology for over 30 years.When it comes to using Oracle with the department mentioned. It is mainly used to maintain and organize an inventory or devices that are being change to the public. These devices include cell phones, tablets, computers, and a simple variety of accessories for the higher priced merchandise. Oracle keeps a count of the exact human body of a particular carrefour the department has. The products are organized in two categories. The first family line is called serialized items which contains everything with a serial anatomy. The serialized items are excessively the most expensive items in the department.Of course all these items have a model name and number but in order to keep track, these items have sku number associated with them. The sku numbers in the serialized category all develop with a 6. This is a way to prevent confusion when it comes to what goes where. The second category is called non-serialized items which contains items without a serial number. These items are also assigned a sku number and these numbers begin with a 7 or a 4. The Oracle database is masked by the departments point of sale system.This was designed so that in that location is a smooth communication between what is sold and what is still in inventory. The database system is a companywide used system and is also used to access inventories of various locations in order to transfer products back and forth. This helps when one location is out or has low quantities of a product and may need additional units. Of course there are generation when all great database systems have issu es that may propel the workplace. Because the Oracle database system runs behind OPUS which is the point of sale system it can affect potential sales within the organization.Serialized items cannot be sold when the database is down because the specific serial numbers must be removed from the system. Non-serialized items can have-to doe with to be sold because they are only counted by their sku only and there are not any specific serial numbers associated with those skus. A recommendation for improvement is to develop a backup database that will appendix when the main database crashes. By having this in place, it can improve the amount of down time that is associated with inventory count information.Businesses across the country are using databases to store company information and keep this information as organized as possible. Database applications have made this process easier by allowing these businesses to have access to the information they need daily. Though all businesses u se databases for different reasons, databases are now a necessity for a successful organization to achieve in todays business world. References Database. (2011). Webopedia. Retrieved from http//www. webopedia. com/TERM/D/database. hypertext mark-up language Database Application. (2011). Wikipedia. Retrieved from http//en. wikipedia. org/wiki/Database_application