Advanced Database

In: Business and Management

Submitted By Claire30
Words 1010
Pages 5
Advance Database
Assessment – Marshalls Garage

The problems with a flat file database are as follows -:

The potential problems of a flat file database are mostly caused through duplication of the required information – e.g. each time the town is put in, it has to be typed separately, this can lead to errors with spelling and consistency e.g. (AE) instead of Dalbeattie, and also inconsistencies between the data whilst the information is being inserted into the database, this also leads to a larger size of database

Also unnecessary duplication of entries makes it extremely difficult to make any necessary amendments, such as – inserting data, deleting data or changing commission, if commission rates were to be changed it would require an awful lot of work to update and correct each entry within the file.

To potentially fix the problems which arise through the use of a flat file structure, it would be advisable to input the data into a relational database, this allows each aspect of the flat file database to have a separate table which is linked through a relationship to another table, so that the information can be easily found by the use of queries – selecting the tables that contain the relative information – to withdraw the required information, this in turn avoids duplication of information.

In order to create a relational database the information contained within the flat file structure must be grouped in order of subject-: such as, Customers, Cars and Staff.

The Customers table contains only the information relative to Customers
Customer No, Title, Forename, Surname, Address, Town, Postcode, Telephone No.

The Cars table contains only the information relative to Cars – Registration Number Date registered, Make, price, model
Customer No (fk) Staff I.D No (fk).

The Staff table contains the information which is relative only to the staff…...

Similar Documents

Database

...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and......

Words: 1374 - Pages: 6

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

Database

...IT203 Database Development GRADED ASSIGNMENTS ------------------------------------------------- Graded Assignment Requirements This document includes all of the assignment requirements for the graded assignments in this course. Your instructor will provide the details about when each assignment is due. Unit 1 Assignment 1: Homework Learning Objectives and Outcomes Describe the role of software for computers. Identify the hardware associated with a computer. Describe how computers store data. Explain how programs work. Differentiate among machine language, assembly language, and high-level languages. Differentiate between compilers and interpreters. Identify the different types of software. Assignment Requirements Answer the following true-or-false questions. Required Resources * Textbook Submission Requirements Submit your answers on the answer sheet provided to your instructor at the beginning of Unit 2. Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases, logical design is kept separate from physical design. 6) A......

Words: 7907 - Pages: 32

Database

... FUNDAMENTALS OF Database Systems SIXTH EDITION This page intentionally left blank FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri Department of Computer Science and Engineering The University of Texas at Arlington Shamkant B. Navathe College of Computing Georgia Institute of Technology Addison-Wesley Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Acquisitions Editor: Editorial Assistant: Managing Editor: Senior Production Project Manager: Media Producer: Director of Marketing: Marketing Coordinator: Senior Manufacturing Buyer: Senior Media Buyer: Text Designer: Cover Designer: Cover Image: Full Service Vendor: Copyeditor: Proofreader: Indexer: Printer/Binder: Cover Printer: Michael Hirsch Matt Goldstein Chelsea Bell Jeffrey Holcomb Marilyn Lloyd Katelyn Boller Margaret Waples Kathryn Ferranti Alan Fischer Ginny Michaud Sandra Rigney and Gillian Hall Elena Sidorova Lou Gibbs/Getty Images Gillian Hall, The Aardvark Group Rebecca Greenberg Holly McLean-Aldis Jack Lewis Courier, Westford Lehigh-Phoenix Color/Hagerstown Credits and acknowledgments borrowed from other sources and reproduced with permission in this textbook appear on appropriate page within text. The interior of this book was set in Minion and Akzidenz Grotesk. Copyright © 2011,......

Words: 181574 - Pages: 727

Databases

...Why Normalization Failed to Become the Ultimate Guide for Database Designers? Marin Fotache Alexandru Ioan Cuza University of Iasi, Romania Faculty of Economics and Business Administration Dept. of Business Information Systems Blvd. Carol I, nr. 22, Iasi, 700505, Romania Tel: + 40 744 497 654, Fax: + 40 232 217 000 fotache@uaic.ro ABSTRACT With an impressive theoretical foundation, normalization was supposed to bring rigor and relevance into such a slippery domain as database design is. Almost every database textbook treats normalization in a certain extent, usually suggesting that the topic is so clear and consolidated that it does not deserve deeper discussions. But the reality is completely different. After more than three decades, normalization not only has lost much of its interest in the research papers, but also is still looking for practitioners to apply it effectively. Despite the vast amount of database literature, comprehensive books illustrating the application of normalization to effective real-world applications are still waited. This paper reflects the point of 1 view of an Information Systems academic who incidentally has been for almost twenty years a practitioner in developing database applications. It outlines the main weaknesses of normalization and offers some explanations about the failure of a generous framework in becoming the so much needed universal guide for database designers. Practitioners might be interested in finding out (or......

Words: 12110 - Pages: 49

Database

...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 comments that an information retrieval system does not inform (change the knowledge of) the user on the subject of their enquiry; it merely informs them of the existence (or non-existence) and whereabouts of documents relating to their request. However, this notion of information retrieval has changed since the availability of full text documents in bibliographic databases. Modern information retrieval systems can either retrieve......

Words: 5238 - Pages: 21

Database

...various functions, often classified as planning, organizing, leading, motivating and controlling. E-Management also can call as electronic management. E-Management is computerized all the management. E-Management is included a lot of things. E-leave management system also can as an e-management system. E-Management is about how to manage a resources by using web-based database system. With database system, the business will be more efficiently and systematic. The business does not have to use the manual technique that needs files and cupboards to store the forms. The forms are store in one place and references and easier to make. This system is a part of the e-services. This Database System is very import in the business world to provide a better service in a systematic way. Companies use databases because they can store a large number of records, ease of use when locating information, it is easy to add new data and to edit or delete old data, there is ease of storage Data can be imported into other applications. More than one person can access the same database at the same time - multi-access hence save time. Databases offer more security than paper files. Now-a-days traveling is a large growing business in India and other countries. Bus reservation system deals with maintenance of records of details of each passenger who had reserved a seat for a journey. It also includes maintenance of information like schedule and details of each bus. We observed the working of the......

Words: 4264 - Pages: 18

Advanced Database

... | |PROJECT | |ProjectID |ProjectManager |*DeptName | Question 3: When inserting data into the table: Ans Data can be inserted without creating null values Problem that would occur updating data Ans Other data on other tables need to reflect the current data. For Example when a person is moved to another DEPARTMENT data would have to be updated in the other tables(DEPARTMENT and PROJECT) Deleting Data: Some data can be deleted on one table without it reflecting on other tables. The space in the database will be wasted...

Words: 418 - Pages: 2

Database

... FUNDAMENTALS OF Database Systems SIXTH EDITION This page intentionally left blank FUNDAMENTALS OF Database Systems SIXTH EDITION Ramez Elmasri Department of Computer Science and Engineering The University of Texas at Arlington Shamkant B. Navathe College of Computing Georgia Institute of Technology Addison-Wesley Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editor in Chief: Acquisitions Editor: Editorial Assistant: Managing Editor: Senior Production Project Manager: Media Producer: Director of Marketing: Marketing Coordinator: Senior Manufacturing Buyer: Senior Media Buyer: Text Designer: Cover Designer: Cover Image: Full Service Vendor: Copyeditor: Proofreader: Indexer: Printer/Binder: Cover Printer: Michael Hirsch Matt Goldstein Chelsea Bell Jeffrey Holcomb Marilyn Lloyd Katelyn Boller Margaret Waples Kathryn Ferranti Alan Fischer Ginny Michaud Sandra Rigney and Gillian Hall Elena Sidorova Lou Gibbs/Getty Images Gillian Hall, The Aardvark Group Rebecca Greenberg Holly McLean-Aldis Jack Lewis Courier, Westford Lehigh-Phoenix Color/Hagerstown Credits and acknowledgments borrowed from other sources and reproduced with permission in this textbook appear on appropriate page within text. The interior of this book was set in Minion and Akzidenz Grotesk. Copyright © 2011,......

Words: 181574 - Pages: 727

Database

...chapter 2 Database System Concepts and Architecture he architecture of DBMS packages has evolved from the early monolithic systems, where the whole DBMS software package was one tightly integrated system, to the modern DBMS packages that are modular in design, with a client/server system architecture. This evolution mirrors the trends in computing, where large centralized mainframe computers are being replaced by hundreds of distributed workstations and personal computers connected via communications networks to various types of server machines—Web servers, database servers, file servers, application servers, and so on. In a basic client/server DBMS architecture, the system functionality is distributed between two types of modules.1 A client module is typically designed so that it will run on a user workstation or personal computer. Typically, application programs and user interfaces that access the database run in the client module. Hence, the client module handles user interaction and provides the user-friendly interfaces such as forms- or menu-based GUIs (graphical user interfaces). The other kind of module, called a server module, typically handles data storage, access, search, and other functions. We discuss client/server architectures in more detail in Section 2.5. First, we must study more basic concepts that will give us a better understanding of modern database architectures. In this chapter we present the terminology and basic concepts that will be used......

Words: 11529 - Pages: 47

Database

... Chapter 2 Modeling Data in the Organization Chapter Overview The purpose of this chapter is to present a detailed description of the entity-relationship model and the use of this tool within the context of conceptual data modeling. This chapter presents the basic entity-relationship (or E-R) model, while advanced features are presented in Chapter 3. Chapter Objectives Specific student learning objectives are included in the beginning of the chapter. From an instructor’s point of view, the objectives of this chapter are to: 1. Emphasize the importance of understanding organizational data, and convince your students that unless they can represent data unambiguously in logical terms, they cannot implement a database that will effectively serve the needs of management. 2. Present the E-R model as a logical data model that can be used to capture the structure and much, although not all, of the semantics (or meaning) of data. 3. Apply E-R modeling concepts to several practical examples including the Pine Valley Furniture Company case. Key Terms |Associative entity |Entity-relationship diagram |Relationship instance | | |(E-R diagram) | | |Attribute | |Relationship type |...

Words: 12988 - Pages: 52

Advanced Database

...CS 632 Advanced Database Systems Your Name: Yagna Patel Your NJIT UCID: 31327569 Email the COMPLETED form back to me at wangj@njit.edu before 9 PM, Sunday, July 26, 2015. The subject of your email must be CS 632 Exam Time. Students who do not send me the COMPLETED form before 9 PM, Sunday, July 26, 2015 are assumed to be OK with ALL the time slots listed below. If a particular time slot is not checked, it is assumed that the time slot is OK (i.e. the default value for each time slot is OK). The finalized exam time will be posted on Moodle before 9 PM, Sunday, August 2, 2015. The total time (duration) for the exam will be 1 hour. August 4, Tuesday, 6 PM Preferred OK Low priority August 4, Tuesday, 8 PM Preferred OK Low priority August 5, Wednesday, 6 PM Preferred OK Low priority August 5, Wednesday, 8 PM Preferred OK Low priority August 6, Thursday, 6 PM Preferred OK Low priority August 6, Thursday, 8 PM Preferred OK Low priority August 7, Friday, 6 PM Preferred OK Low priority August 7, Friday, 8 PM Preferred OK Low priority August 8, Saturday, 3 PM X X Preferred OK Low priority August 8, Saturday, 6 PM ......

Words: 298 - Pages: 2

Database

...1.1 Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data merupakan satu satuan informasi yang akan diolah dimana sebelum diolah dikumpulkan di dalam suatu file database. Pengumpulan data dilakukan secara sistematis menurut struktur file database. • Database merupakan kumpulan data yang terkait satu sama lain. Atau sekumpulan data yang terintegrasi yang diorganisasi untuk memenuhi kebutuhan pemakai untuk keperluan organisasi. • Dalam database pastinya mengenal istilah DBMS (Databse Management System) yang mana merupakan suatu koleksi dari program yang mana pengguna bisa mengcreate dan memaintain suatu database. Dalam DBMS terdiri atas proses-proses yang harus dilakuka nyaitu defining, constructing, manipulating dan sharing. Komponen-komponen DBMS yaitu terdiri atas hardware, software, data, prosedur, people. Fungsi dari defining yaitu DBMS harus dapat mengolah pendefinisian data. Fungsi dari manipulating DBMS harus dapat menangani permintaan-permintaan dari pemakai untuk mengakses data. Fungsi dari constructing yaitu DBMS harus mengontrol proses pengiriman data ke penyimpanan medium. Fungsi dari sharing yaitu database memperbolehkan banyak orang dan program untuk mengakses database. • Meta data: informasi terstruktur yang bertujuan untuk mendeskripsikan,......

Words: 1618 - Pages: 7

Database

...Student Database Management System Ajay Shankar Bidyarthy , Abhishek Kumar b.ajay@iitg.ernet.in kumar.ak@iitg.ernet.in November 13, 2012 Abstract: An organized and systematic office solution is essential for all universities and organizations. There are many departments of administration for the maintenance of college information and student databases in any institution. All these departments provide various records regarding students. Most of these track records need to maintain information about the students. This information could be the general details like student name, address, performance, attendance etc or specific information related to departments like collection of data. All the modules in college administration are interdependent. They are maintained manually. So they need to be automated and centralized as, Information from one module will be needed by other modules. For example when a student needs his course completion certificate it needs to check many details about the student like his name, reg number, year of study, exams he attended and many other details. So it needs to contact all the modules that are office, department and examination and result of students. With that in mind, we overhauled the existing Student Database Management System and made necessary improvement to streamline the processes. Administrators using the system will find that the process of recording and retrieving students information and managing their classes,......

Words: 4780 - Pages: 20

Database

...NORMALIZATION 7 Normalization Process 7 Un-normalized data 8 1st Normal Form 8 2nd Normal Form 9 3rd Normal Form 9 Normalized Tables 10 INTRODUCTION Planning a wedding is one of the most exciting and most stressful events in one’s lifetime and in Planning this there is a number of factors that need to be considered such as the guest list, venues, and suppliers. Hence on the quest to organize the scheduling and selection of activities for planning Of weddings a database System will be designed to accommodate its operation, providing a high degree of Usability and efficiency for the people using the application within the company. The database would be built in Oracle having forms that provide at least the minimum basic CRUD (Create, Read, Update, and Delete) functions and the following are the specific forms required; Basic wedding detail form, Supplier type form, Event type form, Supplier detail form, Event detail Form along with the advanced forms such as Wedding event schedule form, wedding event guest form, wedding event supplies and company work schedule summary. The system will be constructed from a number of normalized tables that will be used to construct the Forms and an entity relationship diagram will be formed showing relationships between entities and There attributes. More specifically, the system would show which client has booking for a particular Wedding along with the suppliers and staff member assigned......

Words: 1357 - Pages: 6

Pocket Money Pitch ... | Petroleum vs Natural Gas essay | Kunststoffindustrie & Chemie