StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Information Systems (Database Assignment) - Essay Example

Cite this document
Summary
I have been a regular member at the Reader’s Inn, a small library in my neighborhood, dedicated towards providing access to quality books yet charging very minimal fees. The library has successfully been running since 1995 and has over 200 members. There are over 5000 books at…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95% of users find it useful
Information Systems (Database Assignment)
Read Text Preview

Extract of sample "Information Systems (Database Assignment)"

Download file to see previous pages

Each book has a paper card which maintains the record of which member bought which book and when. When a member borrows a book, Mr. Russell marks the entry on the card and also writes this in his notebook. He then keeps the card with himself to remind him of the pending books. There is also another notebook which maintains information about the contact details of all the members of the library. Initially, when the number of members used to be less, the existing system ran smoothly and had no flaws.

However, as the number of members and the daily transactions increase, there are a few serious problems that Mr. Russell is facing. They are described below: There are no proper records for the books in the shelves. Often members complain that they do not have the facility to search for a particular book, or at least know, whether it is available or has been issued. The situation wastes a lot of time and people have to wait a long time. It takes a while to find out which members have not returned their books back within the due date.

Members need to be reminded to return their books on time and any members who continuously fail to return books on time, need to be penalized. With the current system, there is no means to find this out. In this project, we have analyzed a problem at a local library called Reader’s Inn which is currently running on manual system. It is difficult to search through manual records and many of the functionality needed such as report generation are not possible. Hence, we developed the design for a database system for the library which consisted of three normalized entities.

Each of these entities had several attributes. These entities were programmed in Ms Access 2007, a common database package. Apart from the database tables, we also designed input screens for data and reports for output. With this database system, the existing problems will be solved to a great extent and the new

...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Information Systems (Database Assignment) Essay”, n.d.)
Information Systems (Database Assignment) Essay. Retrieved from https://studentshare.org/miscellaneous/1566175-information-systems-database-assignment
(Information Systems (Database Assignment) Essay)
Information Systems (Database Assignment) Essay. https://studentshare.org/miscellaneous/1566175-information-systems-database-assignment.
“Information Systems (Database Assignment) Essay”, n.d. https://studentshare.org/miscellaneous/1566175-information-systems-database-assignment.
  • Cited: 0 times

CHECK THESE SAMPLES OF Information Systems (Database Assignment)

Domestic Military Intelligence of the United States

The TALON program mandated Air Force/military bases and other defense systems to profile and report suspicious activities into a merged database.... Thus, the CIA's and the FBI's databases and intelligence are efficient enough to avail the right information for national security policies and defense decisions.... The Department of Homeland Security, Intelligence, and Analysis also offers the information for which the TALON program was formed, more so with regards to merging intelligence related to terrorism with law enforcement within US borders....
3 Pages (750 words) Assignment

Problems and Issues of Localising and Distributing Databases Worldwide

This is because one may be required to hire additional staffs to manage and operate database.... The problem in ensuring that logarithms being utilized are correct might be experienced when localizing and distributing database world wide (O?... Additionally, lack of established tools and techniques of converting centralised data management systems into decentralised form makes it quite challenging to localize and distribute databases world wide(O?...
6 Pages (1500 words) Assignment

Software Development Life Cycle

Correspondingly, the proposed operations in the considered Software Development Life Cycle (SDLC) framework include a web-server and database server hosting protocol and a firewall protection configuration.... hellip; The planned web-server and database server hosting protocol needs to operate on the basis of certain requirements which entail a common browser which invokes a particular URL that can be operated through a PC or a notebook or even a mobile device....
5 Pages (1250 words) Assignment

The Identification Types of the Components of a Cluster

The second layer is diversely treated by database modeling languages.... The paper "The Identification Types of the Components of a Cluster" concerns the application of aggregation functions such as summarization and average to derived values is based on conversions to absolute or ratio values....
6 Pages (1500 words) Assignment

Management and Modeling of Oracle Data Modeler

Erwin can be used to perform data modeling for different types of databases like information systems, database transactional systems, data marts, and several others.... According to Burbank, these approaches include the following: Physical data modeling This type of modeling makes use of the current facilities and specific constraints of a particular database management system.... It provides database-specific kind of representation of a data model....
12 Pages (3000 words) Assignment

Specific Aspects of Auditing in a Computer-Based Environment

hellip; The perception of DDBS is identified to be dissimilar to that of the centralized database system.... Especially mentioning, it contributes to maintaining the reliability of data by extracting valuable data from a specific database to compile various important reports....
4 Pages (1000 words) Assignment

Logics of Database Analysis

… )c) specifying that the subject of a message must not be longer than 120 characters, in SQL is by using the term text(120) as shown in the diagram below CREATE TABLE Colors ( MessageID LONG, PRIMARY KEY, MessageSubject TEXT(120) Message Body )c) specifying that the subject of a message must not be longer than 120 characters, in SQL is by using the term text(120) as shown in the diagram below CREATE TABLE Colors ( MessageID LONG, PRIMARY KEY, MessageSubject TEXT(120) Message Body TEXT(100) SendDate LONG )d) Enforcing the restriction that the only valid values of sex are male or female, in SQL is as shownCREATE TABLE Client ( EmailAdress LONG, ClientName TEXT(40), Gender TEXT (10), CONSTRAINT PK_Male and female PRIMARY KEY ClienthouseholdSize LONG, clientaddress )Question 3Entity – Relationship Diagram (E R Diagram) The database to create will contain various entities which include member details, client details contacts and contracts....
6 Pages (1500 words) Assignment

Magic Quadrant for Data Warehouse Database Management Systems

… The paper “Magic Quadrant for Data Warehouse database Management Systems ” is a potent example of an assignment on information technology.... The paper “Magic Quadrant for Data Warehouse database Management Systems ” is a potent example of an assignment on information technology.... The Lolipop team found out that the existing data warehouse systems were used as a bridge to data rather than make effective use of a company's information....
9 Pages (2250 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us