Database Techniques and Applications Report
User Needs
==========
My database will be designed for a major florist company called ‘FuNkY
FlOwErS’, the company has requested for me to design a database, which
will enable all records of customers, the flower package they’ve
chosen, and the sales, to be recorded in one document. The database
will enable the staff operating the database to store and retrieve
information, which is relevant to the sales. In order for the
information in my database to remain secure, reliable and private.
Information to be processed
===========================
I have included three tables in my database and their names are as
follows:
· Tbl Employees
· Tbl Flowers
· Tbl Suppliers
Customers
---------
Field Name
Data type
Field size
Customer ID
Auto Number
Surname
Text
20 Characters
Forename
Text
20 Characters
Gender
M/F
1 Character
D.O.B
Date/Time
Medium date
House number
Number
5 Characters
Post Code
Text
10 Characters
Tel. 1
Number
20 Characters
Tel. 2
Number
20 Characters
Mobile number
Number
20 Characters
Email address
Text
20 Characters
Member
Yes/No
3 Characters
Date Joined
Date/Time
Medium Date
Above I have shown the contents of the first table I created in
Microsoft Access, this was the first step of creating my database as I
was labelling the column headings for each table. The reason why I
chose the particular headings was so that it is easily accessible to
my client as all my client needs to do to select information or edit
information is select the corresponding table e.g. if a new customer
had decided to become a member then my client would need to select the
One of the biggest problems that affect everyone is data aggregation. The more the technology develop, the powerful and dangerous it gets. Today there are many companies that aggregate a lot of information about us. Those companies gathering our data from different sources, which create a detailed record about us. Since all services have been computerized whether it is handled directly or indirectly through computers, there is no way to hide your information. We used computers, because they are faster, better, and accurate more that any human being. It solved many problems; however, it created new ones. Data does not means anything if it stands alone, because it is only recoded facts and figure, yet when it organized and sorted, it become information. These transformed information. Data aggregation raises many questions such as, who is benefiting from data aggregation? What is the impact on us (the users)? In this paper I will discuses data aggregation and the ethics and legal issues that affect us.
Databases always used to fascinate me from my under graduation with great curiosity to know how large data is managed and queried. This led me to do Masters in computer science concentrating in the field of Data Management. In the course of my study, I understood the concepts of DBMS which provides a robust and efficient way of managing and mining data. Through the courses like Database Systems (ITCS 6160), Knowledge Discovery in Databases(ITCS 6162) and Knowledge Based Systems(ITCS 6155) I gained enough theoretical and practical knowledge about the importance of proper organization of data, good techniques to build an efficient database management system and how well the data can be managed.
Microsoft Access is a user friendly application software database. According to Microsoft ® Corporation (2004), “Access version 2002 extends this versatility by giving developers and more experienced users new functionality, enabling them to access and analyze their important data as well as build powerful new database solutions. At the same time, Access now makes it easy for beginning users to discover and use more of the existing application” (no pg). This means Microsoft Access application software has something to offer for everybody, from the experienced programmer to the first-time database user. With the programs numerous tutorials, along with the Help Menu, wizards and Office Assistant, one can quickly and easily find solutions to most any database need, problem or concern.
We use forms to enter and manage data. Each table in our database has an input form and an output form. An input form displays one record at a time. We use an inpu7t for to enter, view, and modify information in a single record. An output form displays several records as a list. We use an output form to browse through records, select and sort records, and print a selection of records.
This paper was written to show the similarities and differences in five different databases. It compared Access, MySQL, SQL Server, DB2, and Oracle in six different areas. It found many similarities in functionality, but large diversity in pricing.
The database application design can be improved in a number of ways as described below:
In today’s digital era, our life seems easier because of its technologies. Computer technology is the most influential among others. It supports anything that related to the new inventions and innovations. One of important role in computer technology is a database. Although database is not as popular as web application in computer technology innovations, it determines whether such application system is good or not. Database is ‘a shared collection of logically related data and its description, designed to meet the information needs of an organization’ (Connolly & Begg 2010, p. 65). In the past week, I have interacted with them such as the database in flight data, student system, bank, library and Facebook.
As Satzinger, Jackson & Burd (2010, pp. 488) states that a Database Management System (DBMS) is a “system software that manages and controls access to a database”. It is generally purchased and installed separately from other system software components. Examples of DBMS includes Microsoft Access, Oracle and Gemstone.
Information system is software that helps you sort out and examine data. Information system can make it possible to answer questions and solve any problems that are related to the organization. There are a lot of organizations that works with big amounts of data. They are essential values or facts and they are prepared in a database. Information system turns unprocessed data into information’s that are useful for decision-making in an organization.
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
Yao, Y. (2002, May 12-17). Information Retrieval Support Systems. The 2002 IEEE World Congress on Computational Intelligence, 1092-1097.
In the beginning, businesses used information technology for automating the processes primarily to reduce labor costs. Subsequently, information technology is used for delivering information with speed and accuracy.
Effective implementation of strategic plan is a critical task for the management. Before the implementation of this plan, it is essential for the business personnel to collect pertinent information about the strategic plan. In this concern, various database systems have been introduced. For effective management of the staff functions and line functions as well as execution of strategic plan, the company should make use of the data oriented model. The systematic integration of the goals can be done with the help of a well developed information system (O'Brien, 2003).
The dynamics of our society bring many challenges and opportunities to the business world. Within the last decade, hundreds of jobs have emerged particularly in the technology sector to help keep up with the ever-changing world and to compete on a larger and better scale than the competition. Two key job markets and the basis of this research paper are business intelligence or BI and data mining or DM. These two fields play a very important role in small to large companies and are becoming higher desired sectors within the back offices of the workplace. This paper will explore what the meaning of BI and DM really is, how they are used and what we can expect as workers and learners of the technology and business fields for the future.
of multiple types of end users. The data is stored in one location so that they