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

...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 users. A large amount of data has to be stored and it should be stored at a different level of granularity. In order to achieve this, a specific methodology has to be followed in order to store, retrieve and analyze data at different levels. Basic Idea of the Research: The basic idea of the Research is to find out the different methodologies, different environments and different tools used to store, retrieve and analyze data at different levels. This includes some preliminary research on both OLTP and OLAP environments, differences between these two environments, data modeling concepts, how data flows to a data warehouse environment and different tools involved in these......

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

...|Answer: True Difficulty: Medium Reference: p. 237 | | |A DBMS eliminates most of the data definition statements found in traditional programs. | | | | | |Answer: True Difficulty: Hard Reference: p. 238 | | |A data manipulation language is usually used to replace conventional third- and fourth-generation programming languages to | | |manipulate the data in the database. | | | | | |Answer: False Difficulty: Hard Reference: p. 239 | | |More advanced data dictionaries are active in that related programs can automatically use changes in the dictionary. | | | | | |Answer: True Difficulty: Medium Reference: p. 239 ......

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

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

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

Fasttrack Module #5

...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 graphics to access data. 10. What are the 7 network service applications most frequently used in a business environment? 1. Electronic mail or e-mail 6. Electronic funds transfer 2. Voice mail (telephone) 7. Electronic data interchange (EDI) 3. Video conferencing 4. Work group conferencing 5. Electronic bulletin boards 11. What are the differences between Open and Closed systems? - Closed System- doesn’t take in or give out anything to the environment. All the behavior of the system takes place by......

Words: 2284 - Pages: 10

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

Premium Essay

Business Management

...together with any kind of information which is needed to formulate plans. • Control systems - these provide continuous monitoring of marketing activities and enable marketing executives to identify problems and opportunities in the marketplace. At the same time, they permit a more detailed and comprehensive review of performance against plans. • Marketing research systems - such systems allow executives to test decision rules and cause/effect hypotheses. This permits the assessment of the effects of marketing actions and encourages improved learning from experience. • Monitoring systems - these systems provide management with information concerning the external environment in which they are operating. One can define a marketing information system as one which scans and collects data from the environment, makes use of data from transactions and operations within the firm and then filters, organizes and selects data before presenting them as information to management. Marketing Information Systems in the United Kingdom Many firms in the UK are starting to develop computer-based marketing information systems. A survey by Martech Ltd [2] of UK firms found that, in the companies they surveyed, computerization had grown very rapidly over the previous two years with penetration increasing from 15 per cent to about 50 per cent - that is, 70 per cent of the systems mentioned in the survey had been implemented in the previous two years. Martech also noted that most of......

Words: 3668 - Pages: 15

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

Premium Essay

Report

...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 be studied thoroughly by collecting data about the system. Then the proposed system should be analyzed thoroughly in accordance with the needs. System analysis can be categorized into four parts. * System planning and initial investigation * Information Gathering * Applying analysis tools for structured analysis * Feasibility study * Cost/ Benefit analysis. In the current system we......

Words: 1885 - Pages: 8

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

Database Design

...information services to meet the problems or opportunities of the business. A) Database analysts B) Users C) Systems analysts D) Programmers Ans1. (C)System Analysts TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 2) Database development projects are never done in a bottom-up fashion. Ans2. (F) 3) A well-structured database establishes the entities between relationships in order to derive the desired information. Ans3. (F) ESSAY. Write your answer in the space provided or on a separate sheet of paper. 4) Provide a brief overview of the various components of the database environment. TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 5) Database processing programs are coded and tested during the design stage of the systems development life cycle. Ans5. (F) MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 6) Organizing the database in computer disk storage is done in the ________ phase. A) Analysis B) design C) Implementation D) maintenance Ans6. (B)Design 7) A workgroup database is stored on a central device called a (n): A) client. B) Network. C) Server. D) Remote PC. Ans7. (C)Server TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 8) Many of the disadvantages of file processing systems can also be limitations of databases. Ans8. (T) MULTIPLE CHOICE. Choose the one alternative that best......

Words: 667 - Pages: 3

Premium Essay

Business Intelligence Applications

...What Is Business Intelligence? Business intelligence has become a critical element of information technology. It’s an old term with general or even ambiguous meaning. It has been used synonymously with decision support, analysis, and data warehousing, but today business intelligence has a more specific definition and a better understood application. Taken literally, business intelligence is just that—intelligence or understanding of your business. You get that understanding by analyzing your business operations. That analysis is accomplished by collecting the information that represents your marketing, sales, and service activities, the behavior of your customers in responding to these activities, and the behavior of your internal systems and your suppliers’ systems in responding to your customers’ behavior. Once you have collected this information, and its collection is a continuous process, not a one-time event, you organize and store it in a manner to facilitate its access, processing, and presentation through a broad range of techniques including, reporting, query and analysis, OLAP, and data mining. Finally, you use the results of applying these techniques to improve your business operations and start the analysis cycle all over again. This business intelligence process can deliver significant, bottom-line results. Implementing its technologies and applying its process can help make your business more effective and more efficient, increasing revenue, decreasing......

Words: 2189 - Pages: 9