Premium Essay

Database Normalisation

In:

Submitted By UROOZ
Words 1323
Pages 6
Research Paper
Introduction
Database-management system (DBMS) is a collection of interrelated data and a set of programs to access those data. The collection of data, usually referred to as the database, contains information relevant to an enterprise. The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.

Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition, the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results.

Because information is so important in most organizations, computer scientists have developed a large body of concepts and techniques for managing data. These concepts and technique form the focus of this book. This chapter briefly introduces the principles of database systems.

Literature Survey

1. Redundancies and inconsistencies can be reduced 2. Better service to the Users 3. Flexibility of the system is improved 4. Cost of developing and maintaining systems is lower 5. Standards can be enforced 6. Security can be improved 7. Integrity can be improved 8. Enterprise requirements can be identified 9. Data model must be developed 10. Data consistency

Methodology 1. Redundancies and inconsistencies can be reduced
In conventional data systems, an organization often builds a collection of application programs often created by different programmers and requiring different components of the operational data of the organization. The data in conventional data systems is often not

Similar Documents

Premium Essay

Strategic Hr

...Query and * Implement database systems. Unit abstract An understanding of: * Database tools and * Database technologies * Database * Complex data structures and interface Databases provide the infrastructure to many organisations and they offer support to key business applications and information systems. The most common database model used commercially is the relational one. The aim of this unit is to: * Provide a knowledge and understanding of database systems, including * Design principles * Practical implementation and development skills for both the system designer and software engineer. The importance of structured query languages should be stressed, in terms of how they can be used to manipulate data and how they are used for a variety of tasks including querying and report writing. On completion of this unit the learner should be able to understand, design, query and implement a database(s). Learners will also have a theoretical insight into the requirement for designing a database that meets a given user or system requirement and that is functional, user friendly and robust. Learning outcomes On successful completion of this unit a learner will: 1. Understand data models and database technologies 2. Be able to design and implement relational database systems 3. Be able to use manipulation and querying tools 4. Be able to test and document relational database systems. Unit content ...

Words: 576 - Pages: 3

Premium Essay

Test

...Module 5 Database Management using OpenOffice Base Module Overview Welcome to Module 5 - Database Management using OpenOffice Base. This module explores the building of a database using the OpenOffice 3.0 Base software application. The module is intended to be very hands-on and focus upon two primary areas: the how and why of designing and implementing a database, and to develop a basic understanding of relational database theory. This balance of practice and theory is intended to bring greater design strength and data integrity to your database applications. | Upon completion of this module you will be able to: * Describe a database and how it can be utilised * Discuss the difference between a database and the other applications * Understand how databases are organised and operated * Create a simple database and view database content in various modes * Create a table, define and modify fields and their properties; enter and edit data in a table * Sort and filter a table or form: create, modify and run queries to retrieve specific information from a database * Understand what a form is and create a form to enter, modify and delete records and data in records * Build queries to retrieve and sort data * Create routine reports * Build and print reports for regular and ad hoc reporting of data Terminology | | Database | A database is a collection of related information which is organised into a series of rows (called records) and columns (called...

Words: 20896 - Pages: 84

Premium Essay

Database Theories

...Modern Database Applications | [Type the document title] | | | Contents 1. Gray, J. (2009). Jim Gray on eScience: A transformed scientific method. The Fourth Paradigm: Data-intensive scientific discovery 2 2. Rowley, J. (2007). Wisdom hierarchy: Representations of the DIKW hierarchy. Journal of Information Science 3 3. Goldman, N. (2013). Towards practical, high-capacity, low-maintenance information storage in synthesized DNA. 4 4. Gray, J. (1981). The transaction concept: virtues and limitations. In: VLDB '81: Proceedings of the seventh international conference on Very Large Data Bases 5 5. Codd, E. F. (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM 7 6. Chen, P. (1976). The entity-relationship model: Toward a unified view of data. ACM Transactions on Database Systems 8 1. Gray, J. (2009). Jim Gray on eScience: A transformed scientific method. The Fourth Paradigm: Data-intensive scientific discovery Gray states that there is need to distinguish data-intensive science from computational science; he defines an emerging fourth paradigm for scientific exploration. This paradigm is derived from the deluge of data being produced within scientific research fields, and the necessity for tools which can be utilised within the whole research cycle; data capture, curation, analysis and visualisation. He identified that currently the data being produced is not being organised, or published in a systematic...

Words: 3050 - Pages: 13

Premium Essay

Programming Language Using Oojavacom 121

...Comments/Suggestions: CPT 125 Pre-Requisite: Completion of 1st Year Courses Introduction: Systems Design is a central part of systems development. It comprises the process of turning a set of user requirements into an implementable system and encompasses various activities to achieve this end. Alternative models are challenging the traditional systems development life cycle. Alongside this, two approaches to systems development are emerging: the traditional structured approach; and the object oriented approach. The systems design activity will be studied in the context of these trends. Students should make themselves familiar with at least one traditional approach (e.g. SSADM) and one object oriented approach (e.g. UML). Aims: To understand the role of systems design within various systems development life cycles To develop awareness of the different approaches that may be taken to systems design To understand and apply the tools and techniques that are currently used by systems designers Formatted: Superscript      Objectives: Describe different life cycle models and explain the contribution of systems design within them Discuss various systems development approaches and explain their strengths and weaknesses 1 30/09/1123/09/10 Evaluate the tools and techniques that may be used by a system designer in a given context Use appropriate methods to produce a system design for a given scenario     Provide suitable systems documentation for a design Discuss the CASE...

Words: 2312 - Pages: 10

Free Essay

Programming

...relational model? Select one: a. Database b. Relational Database c. Data Warehouse d. None of the Above Question 3 If a relation has more than one candidate key the one chosen to represent the relation is called the: Select one: a. primary key b. foreign key c. alternate key d. candidate key Question 4 The first hierarchial DBMS was ____ and was released by IBM in 1968? Select one: a. IMS (Information Management System) b. SQL c. DB2 d. Oracle Question 5 What is a field that uniquely describes each record? Select one: a. Composite Key b. Foreign Key c. Primary Key d. None of the Above Question 6 The number of attributes in a relation is known as: Select one: a. The relation degree b. The relation cardinality c. The relation domain d. The relation schema Question 7 Which of the following is NOT an information model? Select one: a. pureXML model b. Relational Model c. Hierarchial model d. Network model Question 8 The network model (CODASYL) was released in what year? Select one: a. 1979 b. 1969 c. 1964 d. 1980 Question 9 A formal description of all the database relations and all of the relationships existing between them is called a database schema. Select one: True False Question 10 A unique KEY field Select one: a. Is a special field that each database has to have. b. Is a special field that identifies a particular record in a database c. Is a special field that identifies...

Words: 4344 - Pages: 18

Premium Essay

4tq4g

...Business Information Systems Elizabeth Hardcastle Download free books at Elizabeth Hardcastle Business Information Systems Download free eBooks at bookboon.com 2 Business Information Systems © 2011 Elizabeth Hardcastle & bookboon.com ISBN 978-87-7681-463-2 Download free eBooks at bookboon.com 3 Business Information Systems Contents Contents 1 Defining Information Systems 7 1.1 Defining Data and Information 7 1.2 Defining Systems 8 1.3 Defining Information Systems 8 1.4 Business Information Systems 8 1.5 Types of business information system 9 2 Hardware 10 2.1 Input devices 10 2.2 Central Processing Unit (CPU) 10 2.3 Internal and External Memory 10 2.4 Output devices 10 2.5 Major categories of computers 11 3 Software 12 3.1 Systems software 12 3.2 Application software 13 The next step for top-performing graduates Masters in Management Designed for high-achieving graduates across all disciplines, London Business School’s Masters in Management provides specific and tangible foundations for a successful career in business. This 12-month, full-time programme is a business qualification with impact. In 2010, our MiM employment rate was 95% within 3 months of graduation*; the majority of graduates choosing to work in consulting or financial services. As well as a renowned qualification...

Words: 20690 - Pages: 83

Free Essay

(Erdiagrams)

...diagrams LOGIN(Loginname,loginid,Password) STAFF(Firstname,Lastname,Staffid,Street,city,state,emailid) CUSTOMER(Firstname,lastname,customerid,gender,address,dob,phoneno,mobileno,workphnno) FLIGHTDETAIL(flightno,no.of seats,city of departure,city of arrival,time of departure,time of arrival,price) TICKET(ticketno,dateofissue,flightinformation,cost) INSURANCE(companyname,policyno,nameofcustomer) PAYMENT(etps,creditcard,cheque,paymentno,dateofpayment) NOTE:Relational datastructures LOGIN is in 3NF,data structure STAFF satisfies 1NF and 2NF to satisfy 3normalisation form table should decompose into 2 ,2nd table containing code and phoneno,similarly in TICKET database structure cost is dependant on flightinformation so it should decomposed,remaining database structures CUSTOMER,INSURANCE,PAYMENT is in 3rd normalisation form(3NF). ASSUMPTIONS LOGIN: Staff should have mandatory login id and password to enter into reservations site of AAA travels and to service customers. Customer should have valid userid and password to make reservations and check details regarding flights. STAFF: Staff has optional for dealing with customers because some staff supervise other staff. Staff can reserve ticket for many customers. Customer should have mandatory staff to reserve there ticket. CUSTOMER: Customer can search for flight details to reserve a ticket it is mandatory. Customer may reserve non or reserve many tickets it is an optional. Ticket is mandatory to the customer to travel...

Words: 456 - Pages: 2

Premium Essay

Syaran

...MEC/CEC, CA/CWA, B.Com & B.Sc. Master Minds 4. Data Storage, Retrieval & DBMS Q.No.1. Write about different coding schemes. BCD: » » » » » » » » » » » » » » » » » » BCD stands for binary Coded Decimal system. This is a 6 bit code i.e. each character is expressed in terms of a 6 bit code. There will be 64 ways of representing digits, alphabets and special symbols. There is no parity bit in this coding scheme. ASCII: ASCII stands for American Standard Code for Information Interchange. This code is extensively used in small computers, peripherals, instruments and communication devices. It is a seven-bit code and has replaced many of the special codes that were previously used. Microcomputers using 8-bit word length use 7 bits to represent the basic code. The 8th bit is used for parity or it may be permanently 1 or 0. With 7 bits, up to 128 characters can be coded. A letter, digit or special symbol is called a character. It includes upper and lower case alphabets, numbers, punctuation marks, special and control characters. Here the first 3 bits are zone bits and the remaining 4 bits represent digit values. ASCII-8: A newer version of ASCII is ASCII-8 code, which is an 8-bit code. With 8 bits, the code capacity is extended to 256 characters. EBCDIC: EBCDIC stands for Extended Binary Coded Decimal Interchange Code. It is a standard character code for large computers. It is a 8-bit code without parity and 9th bit can be used as parity bit. Using 8 bits 256 characters...

Words: 14549 - Pages: 59

Free Essay

Book

...Database Tutorial Question The following relational database table is an extract of part of an “unnormalised” Student table: StudNum | StudName | StudAddr | PhNum | CourseCode | CourseName | UnitID | UnitName | StaffID | StaffName | StaffOffice | Grade | 101 | Jenny Teo | 123a Norwich Hse | 9911345 | 20241 | BBus(Acc) | Acc24 | Finance 2a | S045 | Paul Smith | D401 | D | 101 | Jenny Teo | 123a Norwich Hse | 9911345 | 20241 | BBus(Acc) | Law01 | Intro. Law | S022 | Elaine Ng | F213 | C | 101 | Jenny Teo | 123a Norwich Hse | 9911345 | 20241 | BBus(Acc) | Mgt21 | Org. Behaviour | S099 | Ann McCall | D211 | P | 112 | Warren Wills | 64 South St. Clayton | 9894387 | 30001 | BCom | Ais20 | Acc Info Systems | S120 | Peter Duffy | D411 | HD | 121 | Neil Smith | 123a Norwich Hse | 9911345 | 30001 | BCom | Acc24 | Finance 2 | S045 | Paul Smith | D401 | D | 121 | Neil Smith | 123a Norwich Hse | 9911345 | 30001 | BCom | Mkt10 | Intro Marketing | S111 | Dan Coleman | F210 | P | 130 | Joe Chan | 10 Wells St Frankston | 9901238 | 20242 | BBus(Acc) | Acc11 | Intro Accounting | S030 | Elli Blake | F109 | P | 130 | Joe Chan | 10 Wells St Frankston | 9901238 | 20242 | BBus(Acc) | Acc24 | Finance 2a | S046 | Paul Smith | D401 | D | 130 | Joe Chan | 10 Wells St Frankston | 9901239 | 20242 | BCom(Acc) | Law01 | Intro. Law | S022 | Elaine Ng | F213 | C | 130 | Joe Chan | 10 Wells St Frankston | 9901238 | 20242 | BBus(Acc) | Mkt10 | Marketing A | S111 | Dan Coleman | F210 | P | ...

Words: 1236 - Pages: 5

Premium Essay

Outline

...information issued to them by the University via Ryerson online systems on a frequent and consistent basis. Ryerson requires that any official or formal electronic communications from students be sent from their official Ryerson Email account. As such emails from other addresses may not be responded to. 3.0 CALENDAR COURSE DESCRIPTION This course provides the students with an introduction to the core concepts in data and information management. It is centered around conceptual data modeling techniques, converting the conceptual data models into relational data models and verifying its structural characteristics with normalization techniques. The course will include coverage of basic database administration tasks and key concepts of data quality and data security. Building on the transactional database understanding, the course 1 of 4 provides an introduction to data and information management technologies that provide decision support...

Words: 1132 - Pages: 5

Premium Essay

Data Base

...Database Design Table of Contents CHAPTER 1 .............................................................................................................................................. 2 INTRODUCTION ................................................................................................................................... 2 DATABASE MANAGEMENT SYSTEMS .................................................................................................. 2 Database ......................................................................................................................................... 2 Database Management System (DBMS) ......................................................................................... 2 Schemas, Instances and Data Independence.................................................................................. 3 DATA MODELS..................................................................................................................................... 3 Hierarchical Model .......................................................................................................................... 3 Network Model ............................................................................................................................... 4 Relational Model ............................................................................................................................. 5 CHAPTER 2 ............................................

Words: 4347 - Pages: 18

Premium Essay

Secretly Ict Notes

...data types of the fields that are linked must be the same Relationships between entities Entities have been defined as ‘a thing that can be distinctly identified’. The idea of an entity is central to understanding entity relationship models. Relationships There are three types of relationship that can be identified as existing between entities, these are , one to many, one to one, many to many. One to one is that it is associated with only one instance of entity. One to many is the most common type of relationship between entities a single instance of an entity can be associated with many instances of another entity Many to many, many instances of an entity can be associated with many instances of an entity Tables and fields A database table is made up...

Words: 806 - Pages: 4

Premium Essay

Nt1310 Unit 3 Assignment 3

...application. To produce this, I used a software called Balsamiq Mockups 3, the advantage of using this is that I could hyperlink storyboards together and run a simulation of the software. This was very helpful to me because it allowed me to visualise how the GUI will work and look before implementing it. The Story board is located in appendix A. EER diagram is for illustrating entities, relationships and attributes in your database but this does not show how the data is manipulated by the application. First the data has to be...

Words: 517 - Pages: 3

Premium Essay

Strategy

...WORLD VISION POSITION DESCRIPTION |KEY POSITION INFORMATION | |Job Title |DM&E Coordinator | |13 | |Reports To |Program Team Leader | |Department/Group |Quality Team |Location |Sarajevo | WORK CONTEXT / BACKGROUND: World Vision’s earliest involvement in Bosnia-Herzegovina (BiH) was in 1994. Over the years, WV BiH has re-shaped its ministry from a largely return-focused program to one in alignment with the country’s basic development needs. WV BiH strategic intent is to contribute towards CWB in BiH (child wellbeing). To date, WV BiH works in partnership with communities, local and national government, faith-based institutions and civil society for the well-being of children. WV BiH makes no distinction of faith, ethnicity or gender when delivering its assistance to children and their families. Currently WV BiH employs 80 staff across the country. The overall annual budget for World Vision Bosnia and Herzegovina is around $4.6 million. PURPOSE OF POSITION: To lead the DM&E processes of intentional design and gathering of evidence of programs. This will be done through the...

Words: 1594 - Pages: 7

Free Essay

Hibernate

...Hibernate allows us to do object relational mapping. Simply this mean, conversion of objects derived from java classes inside the application, directly to tables in the database. This will reduce the effort utilized in drawing ER diagrams, normalization (conceptual design) as well as physically writing SQL coding to complete the physical design inside the RDBMS. Hibernate will prevent getting your java code dirty via writing SQL within it. If you use hibernate, no sql within your java application at all. Also hibernate provides:- • Caching of frequently used data record. Its several times efficient than retrieving from the database. • Needn’t opening and closing database connections. This will prevent memory leakage problems • Allow the java application to work with multiple DBMSes. • Small change in the java code will alter the table in the DB. Needn’t dropping the table. • 80% of code reduction in the application program When the required operation was initiated from the application, hibernate is versatile enough to auto generate the required SQL coding Go to this site called www.hibernate.org/downloads After going into the site .. notice some changes Look at the release bundles .. under the release bundle , download the latest version Add those into the library.. all those jar files to the library And then add a xml file and name as hibernate.cfg And then go to project file and search for a file in the name of hibernate.cfg.xml And from that get the...

Words: 309 - Pages: 2