Introduction to Reational Database - Essay Example

Comments (1) Cite this document
This report is aimed to provide an overview of the present ICT environment in a hypothetical company Speed Trans to recommend the future ICT infrastructure and system requirements of the company. The company is still young in the business and has recently expanded its operations…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER96.2% of users find it useful
Introduction to Reational Database
Read TextPreview

Extract of sample "Introduction to Reational Database"

Download file to see previous pages A thorough research was conducted to address the above-stated issues with the system. There are several solutions available to address the issues pertaining to the development of an ICT infrastructure including an integrated information system based on some relational database management tool. There are two major application environments available to develop the system which includes a simple Management Information System and a Web-based Information Portal. Both of these systems can be developed on a relational database and are equally viable solutions. However, there are certain added features that a web-based Information Portal can offer to accommodate specific business operations. (Grehan, 2011).Speed Trans information portal is supposed to handle the heavy load of external transactions through e-commerce module and a quick access to information is a mandatory requirement of e-business clientele. These two business domain specific requirement are best met by a Web-based Information Portal. Web-portals are more prone to security issues, therefore, a strong user authentication and authorization over a secure Virtual Private Network (VPN) channel will be required to establish a connection to the system. Additionally, a strong security spectrum will be required to safeguard vital system resources from hackers and viruses. Special network protection technologies including software and hardware tools and mechanisms are required to be implemented to ensure secure, smooth and stable information portal implementation. ...
The company is presently working with various other firms to supply them with automobile spare parts on regular basis. The company operations require an online communication system with its own branch office and other firms. The system is also required to be integrated with the company’s information system. Moreover, the firms is experiencing a high growth in the business and the present ICT setup often faces bottleneck conditions to support the business operations in size and speed. The new system should be designed keeping in mind the future scalability requirements that may arise within at least three years from now. Speed Trans has initially launched a limited ICT setup which is now required to be expanded to a fully integrated Information System along with online communication capabilities to handle the workload of a medium sized enterprise. 3. Current Business Issues The current system has several issues due to its limited scope. These issues cause delay in business transactions, communications bottlenecks restrict the smooth flow of critical business information to and from business partners and clientele, due to lack of integration between various system modules the information stored in various systems cannot be used to provide business intelligence and decision support. These and many other business issues identified in the study are discussed in the following paragraphs; a) Lack of System Support Presently every business operations is not supported by the system and a hybrid environment of system supported and manual operations and transactions are used to achieve business objectives, e.g. system maintains business partners and clientele information but it does not support automated email module to ensure ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Introduction to Reational Database Essay Example | Topics and Well Written Essays - 1250 words”, n.d.)
Retrieved from
(Introduction to Reational Database Essay Example | Topics and Well Written Essays - 1250 Words)
“Introduction to Reational Database Essay Example | Topics and Well Written Essays - 1250 Words”, n.d.
  • Cited: 0 times
Comments (1)
Click to create a comment or rate a document
nicolasmilton added comment 9 months ago
Student rated this paper as
I never thought 1250 words essay could be written in such a free manner. I loved the background of this essay. Will definitely use it for my own work!

CHECK THESE SAMPLES OF Introduction to Reational Database


...?Task a) and b) The ER-Diagram consists of five main entities, ly VISIT, BOOKING, OWNER, DOG, and INVOICE. The relationships can be explained in detail considering their cardinalities, participations and constraints according to the given scenario. CLASS/VISIT and BOOKING A CLASS/VISIT can have several BOOKINGs and a one BOOKING have a single corresponding CLASS/VISIT. Hence a one to many relationship exits between these entities (Marked with 1 and M near the respective entity). A CLASS/VISIT may or may not have booking at a time and it is considered a BOOKING is optional for a CLASS/VISIT and CLASS/VISIT is mandatory for a booking (marked with a circle on BOOKING as the optional side). A class can either have no bookings... a) and b) The...
4 Pages(1000 words)Assignment


...?Business Systems and Process/Operations Management INDIVIDUAL REPORT 2 – INDIVIDUAL ASSIGNMENT Carrefour Case Study Table of Contents INTRODUCTION In the past, the purpose of implementing information technology in the businesses was to offer reports and some small business analysis charts to a small number of managerial staff. But with the passage of time, administrative structures have turned out to be less hierarchical and more decentralized. Thus, there is need to offer data and information to remotely located departments of business. Additionally, due to these changes in business structures, the information delivery process is also changed. In this scenario, IT managers face a lot of challenges in an attempt to bring...
8 Pages(2000 words)Essay

An Introduction to Database Technology and Database Management

...? An introduction to Database Technology and Database management Data, information and knowledge, are correlated and can be defined in terms of each other (Amidon, 1997). Though many definitions have been put across, here are some that differentiates these three terms. Data is a collection of raw and unrefined pieces of information that do not give any meaning, in their present state. It is normally used for analytical purposes and must be organized in a certain manner so as to become useful (Dixon, 2000). It is mostly comprised of facts and figures about certain events and occurrences that require being organized, analyzed and interpreted to give rise to some required information about this events and occurrences. Data is usually... ...
3 Pages(750 words)Essay


...? Happy Homes Database System Database security The security of a database system should be up to The data held by a database is ofgreat importance and loss or damage to that data could result into great consequences to the organization. Happy Homes Ltd has a database for the storage, access, and management of information required for its normal operations. To enhance the security of the database, several key concepts have to be looked at and properly set. This enhances maximum operation and security of the database. First, the issue of access control should take center stage while discussing the security concepts. This...
5 Pages(1250 words)Coursework


...? Creating an Extended Entity Relationship Model (EERM) Creating an Extended Entity Relationship Model (EERM) We use a classical four-layered approach to inductive specification of database structures. The first layer is the data environment, called the basic data type scheme, which is defined by the system or is the assumed set of available basic data. The second layer is the schema of a given database. The third layer is the database itself representing a state of the application's data often called micro-data. The fourth layer consists of the macro-data that are generated from the micro-data by application of view queries to the micro-data (DIETRICH, 2011). The second layer is diversely treated by database modeling languages... for...
6 Pages(1500 words)Assignment

Introduction to Biometric Identification Database

...Biometrics Introduction The term "biometrics" is derived from the Greek words "bio" (life) and "metrics" (to measure). Biometrics is an evolving field of science which deals with establishing the identity of a person based on his/ her biological, anatomical and physiological features like face, fingerprints, handwriting, voice, iris structure, retina, veins, DNA etc. Such features help in establishing the identity of the person without any effort from the person concerned. In fact even if someone tries to conceal his identity, biometrics won't let it happen. Brief History Identifying a person with his face and voice have been the age old practices in the human civilization process. But the evolution of biometrics in the...
11 Pages(2750 words)Essay


...are held on record. Products are identified by their name and records of the product type and a description of the product are kept. i.) Design an E-R diagram for the above database ii.) Derive a corresponding relational scheme from your E-R diagram. Table Assets: assetID (primary) productID (primary) location LeaseRenewalDate Table Assets Inspection: inspectionID (primary) inspectorID (primary) assetID (primary) maintenanceDate maintenanceAction Table Inspectors: inspectorID (primary) name position Table Products: productID (primary) name type description Question 2: A garden plant supplier keeps data about their customers, orders and the plants they sell in a relational database with the...
4 Pages(1000 words)Assignment


...Databases An electronic database is an organized collection of data in a digital form, to achieve a properly working database. A specific user requirement needs to be well elicited before the design and development takes place. These requirements are in two categories; functional and non functional. The functional ones are. First, it should allow users to create new trainers and topics; secondly, it should allow creation deletion of users. It should also allow only authorized users to make changes in the data stored example the trainers should not have the privilege of making changes on schedules and topics, it should allow easy production of standardized reports. The developer should...
1 Pages(250 words)Essay

Description of Bioterrorism Response System

...Bioterrorism Response System Introduction To respond to bioterrorism attacks, health officials must play their part in helping detect, communicate and manage such events. Technological advance enables health officials, including nurses to respond to an attack. To create a database for use in bioterrorism response, certain factors have to be considered; purpose of the system, being detection, diagnosis, management, and communication, clinical evaluation of the system and system security (Gill, 2008). Information from the system should help officials make accurate decisions. For the system to function accordingly, it has to have a measure of accuracy. Sensitivity is required in order to detect the smallest...
1 Pages(250 words)Research Paper

Introduction to Database Systems

...Insert SQL Stored Procedure and Functions Stored procedures in SQL is a collection of controls, condition handling and SQL statements that provide an interface to the database. Stored procedure is an SQL code or object that is executed like a query several times in order to achieve different functions or purposes. Stored procedures are usually precompiled and can be simple selection query or complex ones to do several tasks like selection, joins, insertion or deletion simultaneously. Stored procedures contain a procedure name, input/output parameters, and a procedure body. User defined functions are routines that encapsulate SQ logic inside them. User defined functions accept input and are compiled and executed at...
1 Pages(250 words)Essay
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.

Let us find you another Essay on topic Introduction to Reational Database for FREE!

Contact Us