Premium Essay

Introduction to Database Approach

In:

Submitted By rizalieann
Words 1617
Pages 7
Introduction to Database Approach
(CHAPTER I)

Data - is the raw material that can be processed into information by any computing machine. It can be letters or numbers.
Information - is the data that has been processed and becomes more meaningful and useful for the users to help them in the decision-making.
Table – set of data elements that uses a specified number of colums but can have any number of rows. It is also the logical group of columns and it is the one who make up the entire database and it is important that we don’t duplicate the data.
Column – a vertical arrangement of items; a single type collection of data values and defines data in the table
Record – a database entry that may contain one or more values and usually stored in table. Record is another term for rows since adding another record creates new row. It contains data about a single entity.
Metadata – it provides a description or information to other data. For example, in a picture, metadata is the who tells us the size of the picture, image resolution, etc.
Database – it is a collection of data or data structure that stores informations and most databases contains tables.
DBMS – it is a software responsible for classifying, retrieving, and running queries on data. It also manages the incoming data, organizes it and provides ways to modify by the other programs or users.
FILE PROCESSING APPROACH It is an approach wherein the data is being created, stored and the content of the file becomes accessible. It can also be used in opening saved files fore read only purpose, for creating new file and replacing existing file.Each file is called as flat file and it means that the file contained a single table only. We may also use CD-ROM or hard disk to store the data.
Characteristics
• Files are independent from each other.
• It is a group of file that stores data of a

Similar Documents

Premium Essay

Database

...COURSE OUTLINE DATABASE SYSTEMS: DIS 308 INTRODUCTION Databases are part of our day to day lives. When we are registering as students, we are interacting with databases, when we go to the bank, pay our electricity bills or pay water bills our accounts are on a database, even when we are browsing the net; information is coming from several databases. Therefore, databases are sources of information kept on electronic storage media for easy retrieval by interested parties. OBJECTIVE The objective of this unit is to introduce students to the concepts, architecture and design methods of database systems. At the end of the course you will be expected to translate logical models into physical databases LECTURE ONE: Introduction to Databases * Database Terminologies * Tradition Files * Database Management Systems (DBMSs) * Characteristics of Database Approach * Database Users * Database Storage LECTURE TWO: Database Systems Concepts and Architecture * Data Models * Three Schema Architecture * Database Languages and Interfaces LECTURE THREE: Database System Environment * Types of Databases * Database System Utilities * Tools Environment and Communication Facilities * Centralized and Client Server architecture for DBMSs * Distributed Databases * Data Warehouse LECTURE FOUR: Database Design Process * Logical Database Design Process * Physical Database Design * Object-Oriented Database Design LECTURE FIVE: CAT LECTURE SIX: Modeling...

Words: 252 - Pages: 2

Premium Essay

Write a Business Report on Any Chosen Business

...Report draft1 Introduction This report has been compiled to propose the introduction of a database. The report considers the benefits to the company in terms of improving customer service and cutting the cost of errors. The report also considers benefits to customers as well as incorporating a more personalised approach to marketing our services and products to specific customers. Executive Summary Max Motors LTD is an automotive motor vehicle garage that repairs car and does MOT tests. As a business in the secondary sector we provide a list of services. Ever since the company opened we have gained a loyal customer base through word of mouth and a respectable reputation achieved through the quality our services. This report analyses the strengths and weaknesses and how we can improve the running of the company through up to date organizational methods using database software. The database will accurately regulate and enhance all aspects of the business, which we will look at in detail in the report. Areas such as sales and marketing, administration, customer service, finance and vehicle records would benefit from such an organizational tool because time will be saved, errors will be reduced and customer will be retained. Max Motors LTD have a loyal customer base so therefore as a business we are profitable and self-sustaining. However over the past eight years the company has not progressed in terms of size and annual net profit. In fact there has been a steady...

Words: 1483 - Pages: 6

Premium Essay

Cochran Library Database Paper

...Databases Searched The following databases that were utilized in this study included, CINHAL, Medline, Cochran Library, and Clinical Key. Search Terms Within the CINHAL database the following search terms were used, “hypertension”, “blood pressure”, “hypertension AND exercise”, “hypertension AND device guided breathing”, “hypertension AND African Americans”, “hypertension AND blacks”. Within the Medline database the following search terms were used, “hypertension”, “high blood pressure”, “hypertension” combined with “pathophysiology”, “high blood pressure AND pathophysiology”. “hypertension AND device-guided breathing”, “hypertension AND slow-paced breathing”. In the Cochran Library database, the following terms were searched, “hypertension...

Words: 789 - Pages: 4

Premium Essay

Reflection

...Week Two Student Guide This week, you will explore how databases are used in the work environment. Databases play a significant role in an organization, so it is important to know how to capitalize on database functionality. You will also learn how businesses, consumers, and the government use collaboration tools in the work environment, and how these tools have transformed the business processes of today’s organizations. Additionally, you will explore electronic commerce, and discuss the challenges this technology presents to businesses and their consumers. Databases, Network Applications, and E-Business OBJECTIVE: Describe how databases are used in the work environment. Resources: Ch. 4 and Technology Guide 2 of Introduction to Information Systems and Ch. 1 for Access in Microsoft® Office 2010 Content • Ch. 4: Data and Knowledge Management of Introduction to Information Systems o Managing Data • The Difficulties of Managing Data • The Data Life Cycle o The Database Approach • The Data Hierarchy • Designing the Database o Database Management Systems • The Relational Database Model • Databases in Action o Data Warehousing • Describing the Data Warehouse • Data Marts o Data Governance o Knowledge Management • Concepts and Definitions • Knowledge Management Systems • The Knowledge Management System Cycle • Technology...

Words: 610 - Pages: 3

Free Essay

4.5 Module Review

...4.5 Assignment: Module Review Part One: 1. Discuss the advantages of a database management approach to the file processing approach? Give examples to illustrate your answer. A database management approach can be much more advantageous than a file processing approach. With database management all data stored is processed in a way that independent files are compiled into a pool of records. This allows data to be consolidated and indexed so that it can be searched through quickly and takes up less space than a traditional file processing approach. One example of a database management approach is the FBI’s Next Generation Identification system (NGI). This database is used by law enforcement to instantly identify any individual suspected of a crime. The database contains many different types of data such as fingerprints, a list of individuals of special concern, an interstate photo system, palm prints, criminal history information, and iris recognition. All of the data contained in this database would take years to search using a file processing approach. However, thanks to database management the data can be searched instantaneously by law enforcement around the world. https://www.fbi.gov/about-us/cjis/fingerprints_biometrics/ngi/ngi2 2. Outline the benefits and limitations of the relational database model for business applications today? The benefits and limitations of the relational database model for business applications vary greatly. Some of the benefits are the smaller...

Words: 737 - Pages: 3

Premium Essay

It and Its Scope

...the principal means of quality assurance in higher education. The major emphasis of accreditation process is to measure the outcomes of the program that is being accredited. In line with this Faculty of Technology of University of Mumbai has taken a lead in incorporating philosophy of outcome based education in the process of curriculum development. Faculty of Technology, University of Mumbai, in one of its meeting unanimously resolved that, each Board of Studies shall prepare some Program Educational Objectives (PEO‟s) and give freedom to affiliated Institutes to add few (PEO‟s) and course objectives and course outcomes to be clearly defined for each course, so that all faculty members in affiliated institutes understand the depth and approach of course to be taught, which will enhance learner‟s learning process. It was also resolved that, maximum senior faculty from colleges and experts from industry to be involved while revising the curriculum. I am happy to state that, each Board of studies has adhered to the resolutions passed by Faculty of Technology, and developed curriculum accordingly. In addition to outcome based education, semester based credit and grading system is also introduced to ensure quality of engineering education. Semester based Credit and Grading system enables a much-required shift in focus from teacher-centric to learner-centric...

Words: 10444 - Pages: 42

Free Essay

Ums Fee Stuctur

... | |RD-1801A21 | |Reg.no-10800783 | Contents for synopsis:- 1.Introduction 2. TOOLS / PLATFORMS & LANGUAGE 3. OBJECTIVE OF THE PROJECT 4. INPUT TO THE PROJECT 5. OUTPUT OF THE PROJECT 6. DATABASE DESIGN 7. DATA FLOW DIAGRAMS 8. SCOPE OF FUTURE APPLICATION 9.SOURCE CODE ACKNOWLEDGEMENT It acknowledges all the contributors involved in the preparation of this project. Including me, there is a hand of my teachers, some books and internet. I express most gratitude to my subject teacher, who guided me in the right direction. The guidelines provided by her helped me a lot in completing the term paper. The books and websites I consulted helped me to describe each and every point mentioned in this project. Help of original creativity and illustration had taken and I have explained each and every aspect of the project precisely. At last it acknowledges all the members who are involved in the preparation of this project. Introduction This project “FEE...

Words: 915 - Pages: 4

Premium Essay

Nt1320 Unit 7

...SQL Unit 7 – Learning Journal Bachelor's degree in computer science CS2203-01– AY2024-T3 Student: Eckert Schnetler Instructor: Rupa Sarda. Introduction Effective database programming and management in the fields of computer science and database management depend on lifelong learning and implementation of core concepts. This post explores two primary database programming paradigms and evaluates their benefits and drawbacks. It also reflects on my recent experiences learning about databases and the ACID principle. 1. What is the difference between a. and a. Reflective Analysis of Personal Learning Experience I made a big advancement in my knowledge of database management systems this past week. I started a thorough investigation of the ACID principle, which is a fundamental idea in the sector. Atomicity,...

Words: 529 - Pages: 3

Premium Essay

Cruise Sales

...Assignment in Basic Research Find a sample research article which is related to your field of specialization. (Hotel Management) Submitted by: Andreyan M. Solanoy Submitted to: Dr. Perlita Esrael (Professor) A SYSTEMATIC REVIEW OF KNOWLEDGE MANAGEMENT RESEARCH IN THE HOSPITALITY AND TOURISM INDUSTRY by Xu Cheng Bachelor of Art Guangdong University of Business Studies 2008 A thesis submitted in partial fulfillment of the requirements for the Master of Science in Hotel Administration William F. Harrah College of Hotel Administration Graduate College University of Nevada, Las Vegas December 201 Assignment in Basic Research Find a sample research article which is related to your field of specialization. (Hotel Management) Submitted by: Ma. Florina Teresa T. Tampos Submitted to: Dr. Perlita Esrael (Professor) Assignment in Basic Research Find a sample research article which is related to your field of specialization. (Hotel Management) Submitted by: Floven P. Laurencio Submitted to: Dr. Perlita Esrael (Professor) ABSTRACT A Systematic Review of Knowledge Management Research in the Hospitality and Tourism Industry ...

Words: 7367 - Pages: 30

Free Essay

Software

...types of operands and operations; addressing modes; processor organization, register organization and stack organization; instruction cycle; basic details of Pentium processor and power PC processor, RISC and CISC instruction set. UNIT II Memory devices; Semiconductor and ferrite core memory, main memory, cache memory, associative memory organization; concept of virtual memory; memory organization and mapping; partitioning, demand paging, segmentation; magnetic disk organization, introduction to magnetic tape and CDROM. UNIT III IO Devices, Programmed IO, interrupt driver IO, DMA IO modules, IO addressing; IO channel, IO Processor, DOT matrix printer, ink jet printer, laser printer. Advanced concepts; Horizontal and vertical instruction format, microprogramming, microinstruction sequencing and control; instruction pipeline; parallel processing; problems in parallel processing; data hazard, control hazard. UNIT IV ILP software approach-complier techniques-static branch protection-VLIW approach-H.W...

Words: 3183 - Pages: 13

Free Essay

Oracle Database Trends

...Research projectDatabase TrendssUBMITTED BYAndrew HoPatrick TchissamboFlavio baptista | | | PROFESSOR TAHEREH DANESHI | Summary page Our project is about database trends. We started the project by identifying aims and goals such as understanding what database is.We calculated in detail and understood and researched on database understood database used by ORACLE. INTRODUCTION The definition of a database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, you need to incorporate a program that manages the queries and information stored on the system. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. (What is a Database?, 2010) AIM The aim of the study is many folded such as, understanding database, go in detail and understand and research on database, understand the technology used by ORACLE, derive conclusions on the development in the field of database. LIMITATIONS This study is descriptive in nature and the research is done on published secondary materials. Logical conclusions are made based on our experience and...

Words: 3078 - Pages: 13

Premium Essay

Whitle Bread

...Project Plan for Whitbread World Sailboat Race Your Name Goes Here University of Phoenix Project Plan for Whitbread World Sailboat Race [The introduction goes here. It should be one or two paragraphs explaining the findings of your paper. The introduction should prepare the reader for the contents of the paper by previewing the four main topics in your paper. Be sure to end with a transition word or sentence to lead into Section 1 of your paper. Triple click anywhere in this paragraph to begin typing your own introduction.] Bjorn Ericksen Project Strategy Analysis [This should explain the industry your company operates in. It should also identify the areas into which you are expanding. Be sure to end with a transition word or sentence to lead into the next section of your paper. Triple click anywhere in this paragraph to begin typing.] Plan to Reduce Project Duration [This should list any action item deliverables, due dates for each deliverable and who is responsible for each deliverable (resources). This should also assess potential shortfalls, risk factors, and consequences for the plan. Be sure to end with a transition word or sentence to lead into the next section of your paper. Triple click anywhere in this paragraph to begin typing. You may want to use the table provided (Table 1). Project Closure Approach [This should analyze the implementation planning process at Whitbread World Sailboat Race. Be sure to end with a transition word or sentence...

Words: 538 - Pages: 3

Premium Essay

Syllabus

...Subject Title Scheme of Teaching L 3 0 3 0 3 0 T 1 0 1 0 1 0 P 0 3 0 3 0 3 Hours 4 3 4 3 4 3 Credit 4 2 4 2 4 2 University External Marks 50 50 50 CSE361 CSE313 CSE363 AS301 EC316 EC366 EC317 EC367 Data Structures (Practical) Peripheral Devices & Interfaces Hardware Lab (Practical) Engineering Mathematics – III Digital Electronics Digital Electronics (Practical) Microprocessors Microprocessors (Practical) 0 3 0 3 3 0 3 0 15 0 1 0 1 1 0 1 0 5 3 0 2 0 0 2 0 2 09 3 4 2 4 4 2 4 2 29 2 4 1 4 4 1 4 1 25 50 50 50 50 250 Internal Total Sessional Marks 50 50 50 50 50 50 50 50 50 450 100 50 100 50 100 100 50 100 50 700 7. 8. Total ASC405 CSE 415 Analysis & Design of Algorithms Analysis & Design of Algorithms (Practical) Database Management System Database Management System (Practical) Object Oriented Programming Object Oriented Programming (Practical) Cyber Law & IPR Computer Architecture & Organization Internal Total Sessional Marks 50 100 50 50 50 50 50 50 100 50 100 50 3 3 15 0 1 4 0 0 9 3 4 28 3 4 25 50 50 250 50 50 400 100 100 650 2 Scheme of Examination of B.E. in Computer Science & Engineering Third Year - Fifth Semester Sr. Paper Subject Title Scheme of Teaching Univesity Internal Sessional Code External L T P Hou Credit Marks Total Marks rs s 1. CSE511 Operating System 3 1 0 4 4 50 50...

Words: 14784 - Pages: 60

Free Essay

With the Development of Technology, More and More Robots Are Used in Various Fields,

...Base Technologies Programming for Mobile and Remote Computers Information Technology for Management of Enterprise TOTAL Week 4 Scheme of Examinations Theory T/W Practical Oral Total Hours Marks Marks Marks Marks Marks 3 100 25 -25 150 Pract/ Week 2 Tut/ Week -- 2 4 2 -- 3 100 25 -- 25 150 3 4 5 4 4 4 2 2 2 ---- 3 3 3 100 100 100 25 25 25 --25 25 25 -- 150 150 150 6 4 24 10 1 1 3 -- 100 600 25 150 -25 25 125 150 900 INFORMATION AND NETWORK SECURITY CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : WEEK TUTORIALS : PRACTICALS EVALUATION SYSTEM: THEORY PRACTICAL ORAL TERM WORK : SEMESTER VI 04 -02 HOURS 3 ---- MARKS 100 25 25 1. Introduction What is Information Security? Security Goals. 2. Cryptography Crypto Basic, Classic Cryptography, Symmetric Key Cryptography: Stream Ciphers, A5/1, RC4, Block Ciphers, Feistel Cipher, DES, Triple DES, AES, Public Key Cryptography: Kanpsack, RSA, Defiie-Hellman, use of public key crypto- Signature and Non-repudiation, Confidentiality and Non-repudiation, Public Key Infrastructure, Hash Function: The Birthday Problem, MD5, SHA-1, Tiger Hash, Use of Hash Function. 3. Access control - Authentication and Authorization Authentication Methods, Passwords, Biometric, Single – sign on, Authentication Protocol, Kerberos, Access control Matrix, ACLs, Multiple level security model, Multilateral security, Covert channel, CAPTCHA. 4. Software Security...

Words: 3868 - Pages: 16

Free Essay

Database

...1 Basic concepts of information retrieval systems Introduction The term ‘information retrieval’ was coined in 1952 and gained popularity in the research community from 1961 onwards.1 At that time the organizing function of information retrieval was seen as a major advance in libraries that were no longer just storehouses of books, but also places where the information they hold is catalogued and indexed.2 Subsequently, with the introduction of computers in information handling, there appeared a number of databases containing bibliographic details of documents, often married with abstracts, keywords, and so on, and consequently the concept of information retrieval came to mean the retrieval of bibliographic information from stored document databases. Information retrieval is concerned with all the activities related to the organization of, processing of, and access to, information of all forms and formats. An information retrieval system allows people to communicate with an information system or service in order to find information – text, graphic images, sound recordings or video that meet their specific needs. Thus the objective of an information retrieval system is to enable users to find relevant information from an organized collection of documents. In fact, most information retrieval systems are, truly speaking, document retrieval systems, since they are designed to retrieve information about the existence (or non-existence) of documents relevant to a user query. Lancaster3...

Words: 5238 - Pages: 21