Database Environment Analysis

In: Computers and Technology

Submitted By eddiepos
Words 469
Pages 2
MEMORANDUM
SUBJECT: Library Database Environment
DATE: Tuesday, March 1, 2016
Analysis of the Database environment
This environment in which this database is based on is a library.it seeks to look into a library setting and all attributes associated with a library. Basically a library contains documentation for reference, research and learning purposes with a variety of fields to look into. Some may also have archived materials that are still being used. Current libraries have a section where you can access materials like newspapers to catch up with news updates. This database will use a MYSQL environment to manage the data related to the library and Delphi in designing the interface
Problems and constraints
The existing library has a category of sections from which reference materials for research and learning can be obtained. Unfortunately no systematic sorting has been done to categorize books in each section. This makes it some worth difficult and time consuming to find a specific book of interest within the sections
Objectives of the database environment
The objectives of the database environment are enlisted below * Provide an all-in-one system for accessing reference materials * Develop a system that will store user details and item details * Create an easy to understand and friendly environment * Develop a system that can replace the manual library management system * Provide borrow and return records * Provide user access levels(i.e. Only Admin updates database records)
Scope and boundaries
The database scope and bounds will include: * The search module; this enables the user to search any material within the records of the database * The security module; the user must login with his/her credentials in order to access materials * Borrow item module; this will enable borrowing items from the library *…...

Similar Documents

Database Environment

...The Getty Provenance Institute’s database (The Gettys research institute, 2012) contains 1.1 million records. All of these records can be used for a wide variety of research. According to the institute the database can be used for assistance in finding information for Projects, and for the Study of Collecting. According to the Database, “The J. Paul Getty Museum acquired The Entombment (ca. 1612) by Peter Paul Rubens in a Christie's sale in 1992. At that time, the provenance of the painting could only be traced as far back as the mid-19th century. The number 146, located on the face of the painting, appeared to be an inventory number (the Getty Research Institute, 2012). A search in the Provenance Index's Archival Inventories database retrieved a single record in which the artist name (Rubens) and item number (146) matched. The search lead to a 1651 inventory preserved in the Archivo de la Casa de Alba, Palacio de Liria in Madrid, which lists this Rubens painting. Possibly its first owner was Gaspar de Haro y Guzmán Carpio (1629–1687)”. Other Institutions are not as lucky some. Some Museums are not so fortunate to find the item number associated with the picture. When it is time to introduce the collections into a database, curators of small museums find themselves in a little bit of trouble. The features and capabilities offered by the newer commercial and professional collection systems are more than they will ever need, more than they can support and more than......

Words: 1164 - Pages: 5

External and Internal Environment Analysis

...EXTERNAL AND INTERNAL ENVIRONEMNT External and Internal Environment Analysis Bharti Gupta University of Phoenix External and Internal Environment Analysis: Mayo Clinic The purpose of this paper is to analyze the External and Internal environmental factors of Mayo Clinic (MC). Mayo Clinic is a nonprofit worldwide leader in medical care, research and education for people from all walks of life (Mayo Clinic, 2011). Various types of external and internal factors affect the smooth flow of business at Mayo Clinic. External environment analysis is important in determining the strategy that should be adopted by a business and internal environment analysis is critical to identify the core competences of the business. External Environment External environment (EE) can be broadly classified into three types: Remote, Industry and Operating. Remote environment (sometimes called as macro environment) consists of the forces at work in the general business environment which will shape the industries and markets in which an organization competes (Stonehouse, Campbell, Prudie & Hamill, 2008). Industry environment (sometimes called as micro environment) is the competitive environment facing a business. It consists of the industries and markets in which the organization conducts its business competes (Stonehouse, Campbell, Prudie & Hamill, 2008). Operating environment also called the competitive or task environment comprises factors in the competitive situation that......

Words: 1436 - Pages: 6

Database Analysis and Modeling

...USE OF DATA ANALYSIS IN MODELING Use of Data Analysis in Modeling Michael Matthews CIS 331: System Modeling Theory Strayer University Mark O’Connell, PHD March 5, 2013 The term “model” refers to a process of creating a representation of reality and working with this simplified representation in order to understand or control some part of the world (Barker, Powell 2004 pg. 11). A model can be used in varies ways such as business plains, forming a database, or building a structure. It can also be formed mentally, visually, and mathematically especially by data analysis. Data analysis is the process of raw data measured in order to determine the means based on that data. Although, data is relevant in producing a model, it is only used to provide general perspective of information, not to form a solution. By determining this objective, I will demonstrate the use of data analysis to form a model and the advantages and disadvantages that come with it. The techniques of a model are used constantly to understand the world and to predict the outcomes and actions. For example, a mental model come into play when one manager has to decide is hiring an older worker beneficial to the company. Another manager suggests that hiring older workers is a good idea because they bring valuable experience to the job. This mental model is the basis of decision making, one action forming an outcome (Barker, Powell 2004). The decision that is made, the advantage and disadvantage of......

Words: 827 - Pages: 4

Database Analysis

...Databases are powerful tools that can provide businesses with an edge over the competition. Databases can help keep track of, inventory, billing, payroll, phone numbers, and much more. Databases are essential for almost every company in today's business world. The company that I used to work for custom built their database in-house to suit their business needs. The company uses Oracle, SQL, and Microsoft Access. The company asked me to develop a helpdesk database using SQL and Microsoft Access. The server-based database that the company uses is the Structured Query Language (SQL) Server to run security. One of the draw backs of the server is that it has many security problems that constantly need to be patched. These patches are important to keep integrity of the data and security and should be scheduled to be applied on regular bases. Microsoft Access is a relational database management system which, allows users to create, edit, and maintain sophisticated databases. When developing the helpdesk database I found the wizard to be easy to use and helpful when creating the tables, data entry screens, display screens, and generating reports. The visual capabilities are user friendly and the user does not need to have programming experience. The wizard is an excellent internal tool to help the user with creating data entry forms and display screens. Microsoft Access also has its security problems. Microsoft Access is restricted to how much data can be stored before needing to...

Words: 706 - Pages: 3

Database Analysis

...Database Analysis Paper Daltrin L Wardell University of Phoenix CIS 319 8/30/2010 ABSTRACT Good Sportsman Marketing utilizes several software programs and a database system which is named Navision to operate its daily business. In the following paper I will outline and describe some of the Navision’s strengths as well as some of its weaknesses. Navision is the database management system that Good Sportsman Marketing’s IT personnel chose because of its ability to grow along with the company. There are several options on the market when it comes to deciding on a DBMS, the key is to make sure that the system you choose meets the business needs. The Navision Database system is the first line of contact for most of the customers that engage in business with Good Sportsman Marketing. The Navision database has a field in which all a customer’s basic contact information is entered. A customer service representative can begin a call by asking a customer that has called in to provide a phone number, their name, or their zip code so that the representative can check the database and see if that particular customer has called in before. The system will detail exactly what transactions may have occurred with that particular customer and can also help a representative lead into a sale of accessories or components. This feature is one of Navision’s strengths. This feature will assist the representative in making sure that the customer’s current information is accurate. A......

Words: 858 - Pages: 4

Database Environment Dbm 380

...Database Environment Stephen K.D. Sylvester DBM/380 15 October 2014 Gary Teed Today I will be taking to you about the database environment, the term database environment refers to a type of configuration used to create and populate an application. The most commonly used definitions for databases, are items, which include data, which are text, images, graphics and facts associated to something. A database is a collection of well-organized data, the environment that is to be designed is one that stores and retrieves data that easily maintained and organized. For the purpose of this assignment of the database environment, I have chosen will be a series of tables that store customer information, purchase orders, sales orders and various status point information. The data will be used for a series of reports that will show the status of the purchase orders as it goes through the database system. The goal of this system is to provide an accountable and accurate status of the items purchased that have been logged in the system. Over the last decade our company has had a hard time and struggled with lost records and documentation of purchase orders, with limited visibility on the status of those orders. W have submitted a request to create a well working database for our customer service to access, and be able to quickly and accurately find the status of that purchase order. Also we would like to implement a list of potential orders that may have dropped off, and......

Words: 880 - Pages: 4

Database Analysis

...Running Head: Database Analysis Database Analysis Derek Smith University Of Phoenix CIS/205 Steven Schulman October 11, 2010 Database Analysis I have a friend who works for a company that has four international offices in the USA, Europe, and Japan, and two factories in China. They specialize in providing customized products for any organization, targeting school spirit teams. Their products consist of spirit items such as their cheer sticks, hats, duffel bags, bears, flip-flops, and cheerleading accessories. A Database is used to store, manage, and retrieve data, which is throughout a company, which can be created and collected by a number of individuals using different methods and devices (Rainer & Cegielski, 2007). Each section of the database has its specific function. If databases did not exist, their company would have to revert to paperwork that would slow down productivity. Employees would then have to hand write and draft everything on paper. As a result, they also will have to make several phone calls and rely on faxes to accomplish a simple task. Because they do use a database, their employees can have access to information instantly. This paper highlights the three databases that their company uses: GoldMine, Macromedia Dreamweaver, and Microsoft Excel. They require the use of GoldMine for maintaining customer contact information. This information includes customer name, phone number, delivery address, e-mail, type of organization, and a......

Words: 767 - Pages: 4

The Database Environment

...The Database Environment A database is used to gather and store information that is then organized in such a way that a computer program is able to quickly selected desired pieces of data from the data that is stored. Once a query is created and submitted to the query database management system data and information can then be extracted from the database. Objectives The Southern Nevada Museum of Fine Art is in desperate need of a newly updated database that will help them with maintaining proper records of all the art pieces within the museum. This new database will be used to track all the art pieces, new as well as existing along with their current locations. Along with this information, the database will also store the information on each artist, which includes: telephone number, address, art pieces included, as well as the client information of those that are interested or have purchased art pieces. The database will also store the quantity of art pieces that are in the museum along with the art pieces that have been sold and the price of each piece. This database will need to be maintained on a daily basis, for any changes that might occur. It is important that the museum staff is able to give real time data to anyone that asks. For example, if an art piece is for sale. The staff needs to know if that art piece is available or not, and if it is then they will be able to proceed with the purchase. It is mandatory that this data is easy to find and has to be......

Words: 887 - Pages: 4

Database Environment

...Database Environment DBM/380 The Historic Art Museum of Buffalo, NY needs to keep track of an abundance of information. Such as the artwork, artists, and locations of where the art is displayed or stored within the museum. Unfortunately, the museum is currently using only a Microsoft Office Excel spreadsheet to keep track of the artists, artwork, and their locations. This is not good practice and generally causes hardships for end-users. Therefore, a database will be implemented in order to make the information more readily available and accurate. Objectives of the Database First and foremost, is the objective of the database system - which is to store the following information: which art is owned/possessed, which artists, and the location of the art within the museum. By having this information readily available in a managed database, it can help the museum prepare for showings, buy/sell/trade/acquire artwork, and maintain an accurate inventory. The Database’ Environment The database’ environment shall consist of metadata & data, software, hardware, people to operate the equipment, and the appropriate procedures for the individuals to follow. Within the museum, the following devices (iMac 21.5 inch model) will be used as workstations by employees and networked together in order to access the server of which the database will be stored. The iMac devices are expensive, but have the capability of running Boot Camp for employees that desire to use Windows. And...

Words: 857 - Pages: 4

Database Environment

... Database Environment Smith Consulting wants to be able to track their consulting staff, each staff members skill set, and what projects they are working on. In order for Smith Consulting to keep track of all theses sets of data, they are in need of a database. Smith Consulting is an organization which offers Information Technology services to its clients. The services which Smith Consulting offer are database services, application programming, and website services. Smith Consulting was founded in 1984 with the goal of providing information technology services to its clients which are located in the Western United States. Smith Consulting Database Environment The main reason to analyze Smith Consulting’s database environment is to see where the company stands and in what situation the company is in which will be based on the results of the initial study of their database. Analyzing a company’s database is to see if the current system will be in fact able to support the additional information they want to collect on their employees. Looking at Smith Consulting’s database, we can see their current database will be unable to support the additional information and data they would like to update in order to keep track of the staff as well as the other requirements of the project. These would include tracking each staff member and their skill set, and to also track which projects each staff member is working on. To successfully analyze the database environment, their needs to be......

Words: 878 - Pages: 4

Database Environment Paper

...Database Environment Smith Consulting is a firm that focuses building applications for their clients. One of the biggest core values within this company is to maintain the security of the data that they for which this company builds applications. ("Smith Consulting Intranet", 2015) The main focus of this company is the creation of efficient financial applications as well as other functional applications as requested. The company has about 350 employees that currently working for them across all sites ("Smith Consulting Intranet", 2015). From the company intranet there does not seem to be a current database in place for that tracks their consulting staff, clients, each staff member's skill sets, and what projects they are working on. In order to create a database we would have to first select the best database environment for the project. Within this situation the database would not house confidential information so the need for strong security would not be necessary. For this particular database the amount of data that is being imported into the database is rather small. The company has 4 main clients and 350 employees. The system that I would select for this project would be Access. Access can handle all of the data that is needed to create this Project Database. SQL and Oracle are create database structures when dealing with huge amounts of data, this would not be the case in this situation and it would not be feasible to spend the extra money on......

Words: 896 - Pages: 4

Smith Consulting Database Environment

...Smith Consulting Database Environment Student Name DBM/380 Date: Instructor name: Smith Consulting Database Environment Smith Consulting’s current employee management system is inefficient involving a one table database, which produces duplication of many attributes throughout the system. The first iteration of database design provided a new version consisting of various one-to-many relationships to link its various modules. There are currently four modules that consist of an employees, jobs, skills, and projects tables. Smith Consulting has many employees filling many jobs descriptions. Furthermore, each job position may encompass many skills. Finally, many employees may be working on many projects. This first iteration of database design provided a database model that is inadequate and requires a return to the database development life cycle (DDLC) to incorporate the needed many-to-many relationships among tables for efficient allocation of human resources in order to better meet company customer needs. An analysis of the database environment has surfaced the various problems and constraints with the current system. This in turn has determined the scope and boundaries for the new system version. An overall objective and supporting objectives provided the needed data specifications, which is depicted in a logical model table and database schema. Database Environment Analysis The current database environment involves a one table database. This current system has......

Words: 2475 - Pages: 10

Database Analysis

...Database Analysis Paper Angel Vega CIS/205 7/14/2011 Prof. Allen Database Analysis Paper The Countertop Guys is an organization located in Fort Lauderdale, Florida that provides service to The Home Depot and Lowes stores as a countertop and cabinet manufacturer. This small business currently covers all South Florida and part of the Treasure Coast. The Countertop Guys uses a SQL Database to keep up with the manufacturing, customer service and work order processing. The database application used is Filemaker Pro and this application enables the users to keep track of work orders status, material daily production reports among others. Microsoft SQL Server also allows user-defined composite types (UDTs) to be defined and used. It also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). In addition to tables, a database can also contain other objects including views, stored procedures, indexes and constraints, along with a transaction log. A SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 220 TB. The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with an .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension. Storage space allocated to a database is divided into sequentially numbered pages, each 8 KB in size. A page is the......

Words: 930 - Pages: 4

Database Environment

...Chapter 2 - Database System Concepts and Architecture Data Models, Schemas and Instances A characteristic of the database approach is that it provides a level of data abstraction, by hiding details of data storage that are not needed by most users. A data model is a collection of concepts that can be used to describe the structure of a database. The model provides the necessary means to achieve the abstraction. The structure of a database is characterized by data types, relationships, and constraints that hold for the data. Models also include a set of operations for specifying retrievals and updates. Data models are changing to include concepts to specify the behaviour of the database application. This allows designers to specify a set of user defined operations that are allowed. Categories of Data Models Data models can be categorized in multiple ways. • High level/conceptual data models – provide concepts close to the way users perceive the data. • Physical data models – provide concepts that describe the details of how data is stored in the computer. These concepts are generally meant for the specialist, and not the end user. • Representational data models – provide concepts that may be understood by the end user but not far removed from the way data is organized. Conceptual data models use concepts such as entities, attributes and relationships. • Entity – represents a real world object or concept • Attribute -......

Words: 2961 - Pages: 12

Business Environment Analysis

...Business Environment Analysis Background Environmental analysis is a systematic process that starts from identification of environmental factors, assessing their nature and impact, auditing them to find their impact to the business, and making various profiles for positioning. A common process of environmental analysis or scanning is discussed in the following section. Environmental Analysis Process A business manager should be able to analyze the environment to grasp opportunities or face the threats. Organizations need to build strength and repair their weakness available in the business environment. Therefore, this process consists not only a single steps but a process of various steps. Environmental analysis comprises scanning, monitoring, analyzing, and forecasting the business situation. Scanning is to get the relevant information from the information overload. It is to focus on the most relevant information. Monitoring is to check the nature of the environmental factors. Analyzing requires data collection and use of different required tools and techniques. Forecasting is to find the future possibilities based on the past results and present scenario. Environmental analysis process is not static but a dynamic process. It may differ depending on the situation. However, a general process with few common steps can be identified as the process of environmental analysis these are a) Monitoring or identifying environmental factors, b) Scanning......

Words: 1523 - Pages: 7