Free Essay

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 * Return item module; Users will have a section to shows returned items * Report module; this will shows the administrator the user activities like borrowing, returning, login/out activities * Department management module; allows administrator to search department by name, register, edit or delete department * Section management module; admin can search sections by name, add, edit or delete section * Topic management module; admin can search topic by name, add, edit or delete topic * Shelf management module; admin can search shelf by name, register a new shelf, edit shelf associated to section, edit department information and delete department information

List the data specifications
Entity=student
Attributes = student Id, Student first name, Student surname, Student course
Entity=department
Attributes = department code, department name, department faculty
Entity=books
Attributes = book code, book category, book name
References
Mishra, L. K., & Srivastava, V. (2008). Automation and networking of libraries: A manual of library management software and applications of computer technology in libraries. New Delhi: New Age International.
Saracco, C. M. (1998). Universal database management: A guide to object/relational technology. San Francisco, Calif: Kaufmann Publ.

Similar Documents

Free Essay

Assignment and Essay.... Others)Information Technology (Programming/ Languages (Java, C++, Vb,.Net, & Etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ It & Society/ and.

...(Programming/ Languages (Java, C++, VB, .NET, & etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ IT & Society/ and. - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper! ... Java on the other hand is cross-platform, and also traditionally runs as an ... - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper! ... Java on the other hand is cross-platform, and also traditionally runsASSIGNMENT and ESSAY. ... others)Information Technology (Programming/ Languages (Java, C++, VB, .NET, & etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ IT & Society/ and. - NET programmers continue to struggle with the complexiASSIGNMENT and ESSAY. ... others)Information Technology (Programming/ Languages (Java, C++, VB, .NET, & etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ IT & Society/ and. - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper! ... Java on the other hand is cross-platform, and also traditionally runs as an ... - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper!......

Words: 784 - Pages: 4

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the...

Words: 6349 - Pages: 26

Premium Essay

Assignment 3 Business Intelligence and Data Warehouses

...Course title: 1. Differences between the structures of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data Data Warehouse is a database which is designed to process for query and analysis rather than for transaction processing, and it is usually contains historical data derived from transaction data, but can include data from other sources while relational database optimized for online transaction which includes insertions, updates and deletion. Basically Data Warehouse is defined as a subject-oriented, non-volatile and time –variant collection of database which support management’s decisions. Data Warehouse is very distinct from online transaction systems. Some of distinctions are given below: * One of main difference, a data warehouse you can do separate analysis workload form transaction workload which makes it very much read-oriented systems. * They deal higher amount of volume in comparisons to online transaction database. * They have a far higher amount of data reading versus writing and updating. This enables far better analytical performance and avoids impacting your transaction systems. * A data warehouse system can be optimized to consolidate data from many sources to achieve a key goal. * it prevents many disputes and enhances decision-making efficiency 2. Differences between database requirements for operational data and for decision support......

Words: 763 - Pages: 4

Premium Essay

Managing Data Resources

...Chapter 7 Managing Data Resources True-False Questions | |The benefits of a DBMS are immediately tangible. | | | | | |Answer: False Difficulty: Easy Reference: p. 234 | | |Excellent hardware and software will result in inefficient information systems if file management is poor. | | | | | |Answer: True Difficulty: Easy Reference: p. 234 | | |A record describes an entity. | | | | | |Answer: True Difficulty: Easy Reference: p. 235 | | |In traditional file processing, each functional area, by developing its own specialized applications, contributes to data ...

Words: 4937 - Pages: 20

Premium Essay

Dbm 502 Week One

...Material Database Environment, Development Process, and Staffing Tables Part I Database Environment Table Describe each component of the database environment, and provide a common vendor-supplied example or an example of how this component relates to the rest of the database environment. |Components |Description |Example | |Database Management |The Computer Software application that |MySQL, MS-SQL, Oracle IBM DB2.. Etc | |System (DBMS) |interacts with the user and other applications | | |Repository |A storage location for safety of preservation |Dimensions, Maven, | |Metadata |Data the describes other data. |Card Catalogs in the old days, Digital | | | |Photos have metadata describing the photo| | | |location, apature size, etc. | |Case Tools |Computer aided software engineering tools. A |Umbrello, Visio (Kinda) etc. | | |domain of tools to design and implement | | | |software | ......

Words: 1500 - Pages: 6

Premium Essay

Fasttrack Module #5

...important because software packages require a minimum amount; if the computer doesn’t have enough RAM, it won’t be able to use that particular software package. 3. What is the primary purpose of an Operating System? -It is to maximize the productivity of a computer system by operating in the most efficient manner. It reduces the amount of human intervention required during processing. 4. Which is the most important software component for many users today? - The Web-Browser/Internet 5. What is a Database? - A Database is a collection of integrated data files that give different people access to it for different purposes. 6. Why is Data considered a vital resource? - Most organizations couldn’t survive or succeed without quality data about their internal operations and external environment. 7. What is a Data Warehouse? - It is an integrated decision support database whose content derives from the various operational and analytical databases. It is historical and centralized source of data that has been standardized and integrated, used by managers and other professional users. 8. What are the 3 Network topologies? -Star, Ring and bus topology 9. What is “The Web”? - It is a system with a universally accepted set of standards for storing, retrieving, formatting, and displaying data using a client/server architecture. The web combines text, audio, video and...

Words: 2284 - Pages: 10

Premium Essay

Leaders

... Growth.     Walter  Demartis.  Master  programme  in  HR  Development  .  Department  of   Human  and  Organizational  Change.  The  George  Washington  University.                 1. Overview /Introduction The case is about a successful company that has to deal with the complexities and challenges of a globalized environment. The organization faces a number of SHRD issues arising from: a) the specificity of a rapidly changing industry (smartphone), b) the need to cope with significant growth through strategic and diversified sourcing and talent management and, c) align mergers and acquisitions to the HR strategy. Moreover, the growth has resulted in work pressure, which is further affected by lack of physical space and staffing needs concerns also middle management posts. The following analysis further describes the internal and external challenges. The main issue is identified and solutions proposed in the ensuing paragraphs along with an annexed action plan. 2. Environment Analysis Internally, the recent growth and external competition have impacted upon the structures, the workload, and motivation and led the company to reconsider its strategy. Externally, the industry faces an increasing global demand particularly in the emerging economies, which calls for RIM’s penetration in markets like China and India. Scarcity of skilled talents is, along others, the most evident reflection......

Words: 1725 - Pages: 7

Premium Essay

Paroll and It

...Connection between Statistical Software and Database Management System Sunghae Jun Department of Statistics, Cheongju University Chungbuk 360-764 Korea ABSTRACT In big data era, we need to manipulate and analyze the big data. For the first step of big data manipulation, we can consider traditional database management system. To discover novel knowledge from the big data environment, we should analyze the big data. Many statistical methods have been applied to big data analysis, and most works of statistical analysis are dependent on diverse statistical software such as SAS, SPSS, or R project. In addition, a considerable portion of big data is stored in diverse database systems. But, the data types of general statistical software are different from the database systems such as Oracle, or MySQL. So, many approaches to connect statistical software to database management system (DBMS) were introduced. In this paper, we study on an efficient connection between the statistical software and DBMS. To show our performance, we carry out a case study using real application. Keywords Statistical software, Database management system, Big data analysis, Database connection, MySQL, R project. 1. INTRODUCTION Every day, huge data are created from diverse fields, and stored in computer systems. These big data are extremely large and complex [1]. So, it is very difficult to manage and analyze them. But, big data analysis is important issue in many fields such as......

Words: 2685 - Pages: 11

Premium Essay

Exam

...INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Learning Objectives • Describe how the problems of managing data resources in a traditional file environment are solved by a database management system • Describe the capabilities and value of a database management system • Apply important database design principles • Evaluate tools and technologies for accessing information from databases to improve business performance and decision making • Assess the role of information policy, data administration, and data quality assurance in the management of a firm’s data resources 2 © Pearson Education 2012 Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Organizing Data in a Traditional File Environment • File organization concepts – – – – Database: Group of related files File: Group of records of same type Record: Group of related fields Field: Group of characters as word(s) or number • Describes an entity (person, place, thing on which we store information) • Attribute: Each characteristic, or quality, describing entity – E.g., Attributes Date or Grade belong to entity COURSE 3 © Pearson Education 2012 Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Organizing Data in a Traditional File......

Words: 2709 - Pages: 11

Free Essay

Hardware Recommendation for Ftk 4 Accessdata

...Quantifying Hardware Selection in an FTK 4.0 Environment Introduction and Background The purpose of this analysis is to evaluate the relative effectiveness of individual hardware component selection in the FTK 4.0 environment. While it is useful to document the individual hardware components which result in maximum performance, it is also important to identify those components which provide the best value. This effort is part of an ongoing commitment by Digital Intelligence to assist customers in making educated choices when selecting individual components for their forensic workstations. Approach Four basic steps were used to evaluate the application’s resource requirements. Step 1 (Establish Test Environment): A suite of tests was developed for the application. These tests were intended to represent the demands of a typical forensic examination. These tests were then automated in order to provide accurate and repeatable recording of results. Step 2 (I/O Channel Evaluation): The automated test suite was then used to determine the basic configuration of the I/O channels. As a starting point, the application manufacturer recommends up to 5 I/O channels: 1.) 2.) 3.) 4.) 5.) Operating System Casework Database Cache/TempDB Evidence A demonstrated ability to combine two or more of these I/O channels could easily result in a less expensive and more manageable configuration. Evaluation of the I/O channel requirements would be essential in determining an optimal I/O configuration...

Words: 3324 - Pages: 14

Premium Essay

A Comparative Investigation and Evaluation of Oracle9I and Sql Server2000 with Respect to Performance and Scalability

...Phathisile Sibanda Supervisor: Mr John Ebden Computer Science Department, Rhodes University 26 September 2005 Abstract: Performance and scalability are two omnipotent factors determining database availability and reliability. This is especially true for modern computer systems due to the inclusion of the Internet in Online transaction processing (OLTP) and E-commerce applications which use databases. This evolution gave birth to an enduring need for high throughput, good response time, excellent data consistency and concurrency control. This paper evaluates SQL server 2000 and Oracle 9i with respect to performance and scalability. Initial performance tests showed that at low to medium workload both database systems behaved in a similar fashion in terms of throughput and response time. At high load however Oracle 9i emerged victorious in both cases. market and use of the Internet in databases. The first point has lead to competition between commercial and open source database vendors while the second has resulted in a need for high performance database systems. This whole controversy has in the past lead database vendors to employ numerous tricks in bid to improve the processing speed of their systems during benchmarking and thus falsely prove that their databases products are superior to other competitors. Some of their tricks include using high-speed CPUs and clusters, caching up data rows and storing SQL execution plans into RAM prior......

Words: 3061 - Pages: 13

Premium Essay

Business Management

...There is plenty of information around - but often too much of the wrong kind and not enough if the right kind. Marketing Information systems R.A. PROCTOR The Nature of Marketing Marketing management is about finding ways of satisfying customer wants and needs, while achieving organizational objectives or requirements in terms of profit or some other measure of corporate performance. It brings together all customer-impinging resources, such as product design and specification, advertising and other forms of promotion, pricing policy, selling, channels of distribution and physical distribution to achieve this end. These customer-impinging resources are often summarized under four headings and referred to as the four Ps of the marketing mix (price, promotion, place and product). The art or science of marketing management is concerned with making decisions/policies with respect to the elements of the' marketing mix such that the company's interface with its markets is both profitable and customer satisfying. The Need for Marketing Information managers require information to help them forecast changes in product demand, increase selling Productivity, and exercise control over sales and distribution expenses. Marketing is an ongoing process; decisions are made and results of these decisions have he monitored. Consumer and competitor reactions to the company's decisions have to be studied to ensure that the best strategy is being employed. Information on these matters......

Words: 3668 - Pages: 15

Premium Essay

Report

...user account Administrator can also add new user and can edit and delete a user. A Builder can register as user and can buy and sell Properties. An Agent can suggest for buying and selling Properties. An Individual can register as a user and can list, buy and sell properties. SYSTEM ANALYSIS EXISTING SYSTEM: System Analysis is a detailed study of the various operations performed by a system and their relationships within and outside of the system. Here the key question is- what all problems exist in the present system? What must be done to solve the problem? Analysis begins when a user begins its registration & starts to search, list & post property. During analysis, data collected on the various files, decision points and transactions handled by the present system. The commonly used tools in the system are Data Flow Diagram, activity diagram, sequence diagram, collaboration diagram, etc. Training, experience and common sense are required for collection of relevant information needed to develop the system. The success of the system depends largely on how clearly the problem is defined, thoroughly investigated and properly carried out through the choice of solution. A good analysis model should provide not only the mechanisms of problem understanding but also the framework of the solution. Thus it should...

Words: 1885 - Pages: 8

Free Essay

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

Premium Essay

Sibm

...exposure. ← On-site coordination experience from client site based in San Francisco USA. ← Requirement understanding and project initiation activities at on-site location based in New York, Cincinnati and San Francisco, USA. ← Proven abilities in leading complete SDLC entitling analysis, design, development, testing, planning, estimations and delivery. ← An effective communicator with excellent relationship management skills. Strong analytical, problem solving & analytical abilities. Possess a flexible & detail oriented attitude. ← Leading and managing team of size 20+. ← Consistently top performer. Skills Set Technical Operating System : Windows NT/2K/XP/2K3/2K8/Vista/7. Microsoft Tech. : .NET Framework, Visual C# .Net, VB .NET, ASP .Net, ADO .Net, framework 1.0, 1.1, 2.0, 3.5, web services, Windows services, Remoting, Entity framework, Linq, Share point – WSS exposure, Sales Force integration, Dial up USA. Ajax toolkit extender, Enterprise library, Crystal reports, Membership providers,In-home install api, Google api integration API integration : IBM SPSS, Google api federated login and white listing, Lumi , in-home install, Trumpia SMS. Database : RDBMS Concepts, MS SQL (2000, 2005, 2008), Oracle concepts, SQL integration services. Tools & Packages : Visual Studio.Net, FXCop, IBM SPSS, Lyris, Virtual Servers. Others : Microsoft project planner, Object Oriented Programming Concepts. Professional Summary ......

Words: 2307 - Pages: 10