This website uses cookies to ensure you have the best experience. Learn more

Database Fundamentals Essay

1786 words - 8 pages

Student Number: 200202650
School of Engineering & Computing
Course: HNC Business Information Technology
Module: Database Fundamentals
Module Reference: CSH1025
Tutor: Adrian Stevart
Date: Monday, 21 June 2004

CONTENTS

| |ix |
|User Requirements |1 |
|Normalization |1 |
|Forms and there uses ...view middle of the document...

1. User Requirements
• Database to be used by recruitment company called Finders
• Finders work for a number of external clients
• All types of employment
• Agency get a fee for each vacancy filled
• Upon instruction by client, Finders place advert in suitable publication
• Details of applicants, jobs, clients, publication details to be stored on database
• System must be created so that Mail merge can be used to automate interview letters
• Reports and Queries to be used to interrogate the database

To achieve all the objectives outlined within the Database scenario and to be able to manipulate the data and to present it in such a way as to be useful for decision-making, a structured process needs to be adhered to. Normalization is a data technique that attempts to capture all the system needs to store and to organize the data into an efficient structure, and one that doesn’t fall down when operational. With the Finders Employment agency in mind this will enable the data to be organized in such a way that can then be applied to creating a Database that works efficiently. This process can start from a list of seemingly disorganized data items collected during the fact-finding stages of analysis. After normalization has been applied and grouped data within logical groups (entities), this then creates a data model, as seen in [1.1] on Appendix A.

• First normal form demands that each entity has an identifying key that is unique only to that entity. For this purpose I have created a key field, as seen in each and every entity at the end of the attributes list underlined, as seen in [1.2].

• Normalization provides an algorithm for reducing complex data structures into irreducible simple structures. The data that the system needs to store data is organized into its minimal form. Therefore name and address within the APPLICANTS entity and similarly address within the CLIENTS entity have been broken down further. Please see end of respective attributes list for amendments within [1.2].

Please see Appendix B for refined Entity Relationship Diagram.

2. Data validation puts into place further safeguards that ensure that the data input maintains its integrity. It checks that the data is sensible before processing it. An example of a validation rule that could be applied to Finders Employment Agency’s database is a range check, whereupon the data within a form falls between a specified range of values. For example the month of a persons date of birth falls between 1 and 12.

Forms………..what are they good for?

Forms are excellent and user-friendlier for data entry than tables, for example. Forms feel more comfortable. Forms also have facilities for data filtering, automation, and validation beyond that possible using tables or queries alone.

Within the Finders database all forms were linked to an underlying table. Therefore all data...

Other Essays Like Database Fundamentals

Database Systems for Business Essay

3910 words - 16 pages ., Begg, C., & Holowczak, R. (2008). Business database systems. Harlow, England: Addison-Wesley. Elmasri, R., & Navathe, S. (2004). Fundamentals of database systems. Boston: Pearson/Addison Wesley. Hardcastle, E. (2011). Business Information Systems (1st ed.). Bookboon. IBM,. (2015). IBM Download DB2 for Linux, UNIX and Windows. Retrieved 13 April 2015, from http://www.ibm.com/software/data/db2/linux-unix-windows/ Microsoft,. (2015). SQL Server

The Effects of Technology on the Accounting Profession

965 words - 4 pages also takes the required reports by suitable transformations of stored data into information. Therefore, the fundamentals of computerized accounting include all of the basic requirements of any database-oriented application in computers. It helps simplify, integrate and streamline all the business processes cost effectively and easily helps present the true picture of the business undertakings to users of financial reports. This allows departments

Hnwi Asset Allocation in Japan 2014

938 words - 4 pages across 13 asset classes Insights into the drivers of HNWI wealth Reasons To Buy The WealthInsight Intelligence Center Database is an unparalleled resource and the leading resource of its kind. Compiled and curated by a team of expert research specialists, the database comprises dossiers on over 60,000 HNWIs from around the world. The Intelligence Center also includes tracking of wealth and liquidity events as they happen and detailed profiles of

Constructing And Managing A Portfolio Simulation - Memo

1344 words - 6 pages . 401K Advisor, 8(5), 3. Retrieved from Business Source Complete database. http://ehis.ebscohost.com/ehost/pdfviewer/pdfviewer?vid=5&hid=16&sid=685547e5-a60e-4db1-a5a7-6d1734a781b2%40sessionmgr10University of Phoenix. (2010). Constructing and Managing a Portfolio [ComputerSoftware]. Retrieved from University of Phoenix, Simulation, FIN402 -INVESTMENT FUNDAMENTALS AND PORTFOLIOMANAGEMENT website.

Turkey Wealth Report Share 2014

1325 words - 6 pages Executive Summary 3 Wealth Sector Fundamentals 3.1 Political Background 3.2 Economic Background 3.3 Social Background 3.4 Benchmarking Turkey’s Wealth In Context 3.4.1 Distribution Of Wealth In Turkey 3.5 Hnwi Volume And Wealth Trends 4 Findings From The Wealthinsight Hnwi Database 4.1 Trends In Hnwi Wealth To 2018 4.1.1 Hnwi Trend Analysis 4.1.2 Trends Of The Wealth Bands 4.1.3 Demographic Breakdown Of Hnwis 4.1.4 Hnwis – Job

Qwertyttter

2694 words - 11 pages COMM 226 Database Systems INTRODUCTION A database is a structured collection of data, and is usually stored electronically to facilitate computerassisted search and retrieval. The electronic format allows different users to have views of the data that serve their particular needs. Furthermore, the database management software can ensure the consistency, integrity, and security of the database, provided the data needs of the organization have

Role Based Access Controls

1503 words - 7 pages include a consistent set of rules for controlling and limiting access based on identified individuals who have been determined to have a need-to-know for the information.” (Kim, 2012) The date input control is another challenge, When you have several people entering data in your database, you can define how users must enter data in specific fields to help maintain consistency and to make your database easier to manage. Role based input control

Comparative Summary

1260 words - 6 pages veterans, discounted drugs and services to military families, and keep costs low with less overhead.   References Baker, J. J., & Baker, R. W. (2013). Health care finance: basic tools for nonfinancial managers. ISBN-13: 9781284029864 Department of Veteran Affairs. (March 20, 2013). Drug Pharmaceutical Prices. Retrieved from http://www.pbm.va.gov/PBM/drugpharmaceuticalprices.asp Finkler, S. A., & Ward, D. M. (2006). Accounting Fundamentals

Wealth Sector in Russia: Jsbmarketresearch

1085 words - 5 pages states for UHNWIs (2010-2014) Insights into the drivers of HNWI wealth Reasons to Buy The Challenges and Opportunities for the Wealth Sector in Russia 2015 is an unparalleled resource and the leading resource of its kind. Compiled and curated by a team of expert research specialists, the database comprises dossiers on over 60,000 HNWIs from around the world. With the wealth reports as the foundation for our research and analysis, we are able

Introduction to Market Research

1699 words - 7 pages own list (database) and as low as $0.95. • Thomas Register – information on various companies by industry. • Dun & Bradstreet’s Dun’s Market Identifiers – giving you basic company data, executive names and profiles, org status and more on 28Million U.S. companies. • The Internet Public Library - ask a question or search a collection of resources on everything from Education to special collections. • Kauffman Research Roundup – a great source

Computer Systems

1142 words - 5 pages information you need. The correct choice for an input device for a telephone survey would be a voice activated input device. This device is programmed to work with the computer's database to recognize survey responses when spoken into a telephone. Utilizing this system would alleviate the need for personnel to manually input the data and reduce the costs incurred conducting surveys. MICR (Magnetic Ink Character Recognition) is the most common and

Related Papers

Database Management System Essay

1543 words - 7 pages .Solves data integrity problem.5.Provides greater flexibility.REFERENCE:1.Computer Fundamentals, ( 4th edition) by P. K. Sinha.2.Management Information System, (2nd edition) by Gordon B. Davis and Margrethe H. Olson3.Database Management System, ( 3rd edition) by R. Ramakrishnan and J. Gehrke.4.Introduction to Information Systems, (11th edition) by James A. O'Brien.5.Management Information Systems, (7th edition) by Reymond Mcleod,Jr.~: THE END:~

Database Normalization And Logical Process Concept Paper

1457 words - 6 pages Figure 4 THIRD NORMAL FORM Refrences: 1. Gillenson, M. (2012). Fundamentals of database management systems. (2nd ed.). Danvers, MA: John Wiley & Sons. 2. http://databasemanagement.wikia.com/wiki/Normalization_Steps 3. Thomas M. Connolly, Carolyn E. Begg, Database Systems: A Practical Approach to Design, Implementation and Management, 5/E, 2010 Addison-Wesley

Selecting A Database For A Small Business

1115 words - 5 pages step process used in creating the database with the use of primary keys, while also explaining the thought process that went into why tables were created and the order that they were placed using the relationships of each table. Overall this project as proven to be a great test in using all of the fundamentals for this SQL class. I look forward to continued success in using SQL in my future endeavors. Works Cited Data Analytics Software. http://www.1keydata.com/sql/sql-primary-key.html Pratt, Phillip J. Last, Mary Z. A Guide to SQL, Eighth Edition. P.26 Journal of the Association for Information Systems, Aug 1, 2010, Vol. 11, No. 8 (Aug 2010), p. 433-454

Challenges And Opportunities For The Wealth Sector In Switzerland 2014

662 words - 3 pages This report is a thorough analysis of Switzerland’s Wealth Management and Private Banking sector, and the opportunities and challenges that it faces. Table of contents : • The WealthInsight Intelligence Center Database is an unparalleled resource and the leading resource of its kind. Compiled and curated by a team of expert research specialists, the database comprises dossiers on over 60,000 HNWIs from around the world. • The