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

Mis Project

...Applied Research Project Topic Selection: Review the list of possible topics and consider which you would like to research. Identify a company or which the topic would apply. You can use the Week 1 Q&A thread to pose any questions you may have about the research project. Post your chosen topic for my approval in the (required but ungraded) Discussion topic entitled "Applied Research Project" in Week2. You will be given feedback to make sure that you're on the right track for this assignment. If there are still questions regarding the project, the Q&A discussion in Week 3 will accommodate our continued discussion about the project. Applied Research Project Submission: Submit your assignment to the Week 6 Research Paper Dropbox located on the silver tab at the top of this page. (200 points) Dropbox | For instructions on how to use the Dropbox, please click here.See Syllabus/"Due Dates for Assignments & Exams" for due date information. | | | Topic Selection | | Week 1 Applied Research Paper Assignment: Topic Review  Read the following description and possible topic choices. Week 2 Applied Research Paper Assignment: Topic Selection (ungraded but required) Choose your research project topic and prepare a brief description of your proposed topic. Post your proposed title and brief description in the Week 2 Applied Research Project discussion topic. Your description will be reviewed, and you will then receive feedback and approval of your topic choice...

Words: 2482 - Pages: 10

Premium Essay

Access Control

...system will be developed. In this stage, any development requirements will be completed. This may involve the development of a database system or modification of a commercial off the shelf system. During the integration phase, the physical installation of the system will occur. This is followed by testing. Once testing has been completed, the major project scope ends and the project enters into a maintenance phase. Major Tasks There will be five major tasks in this project, including: 1. Analysis and Design a. Design Documentation i. With this task, documentation is written up to describe the work that needs to be completed. This documentation is reviewed by all stake holders to ensure that the requirements are have been accurately conveyed and understood. b. Design Models i. With this task, flow charts and/or use case are created to describe the functionality. These documents are of particular importance to members of the project team, as they provide a model for the actual system 2. Development a. Database i. Depending on the results of the analysis and design task, either a custom or a commercial off the shelf system will be used. This system will require development or customizations to meet specific needs. b. Interface i. An interface is required to view access records. This is the front-end of the database. This is either included in a pre-packaged system or custom developed. 3. Integration a. Install radio-frequency card...

Words: 479 - Pages: 2