Database Systems

In: Computers and Technology

Submitted By pathenry50
Words 1762
Pages 8
Part I

1. Given the file structure shown in Figure P1.1, answer Problems a through f.

Figure P1.1 The File Structure for Problems a-f

a) How many records does the file contain, and how many fields are there per record?

b) What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

c) If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?

d) What data redundancies do you detect, and how could these redundancies lead to anomalies?

e) Using two relational database tables, PROJECT and MANAGER, eliminate the redundancies discovered in Problem d. Make sure you use the naming conventions discussed in Section 1.3.3 and connect the two tables through the appropriate link. (Hint: Use Figure 1.11 as an example.)

f) Create the relational schema to show how the two database tables in Problem e are linked.

2. Given the file structure shown in Figure P1.7, answer Problems a through g.

Figure P1.7 The File Structure for Problems a-g.

a) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.7.

b) How many different data sources are likely to be used by the file you examined in problem a?

c) Given your findings in Problems a and b, how would a relational database environment help eliminate the data redundancy problems?

d) Given your answer to Problem c, how many tables would you use to substantially eliminate the data redundancy problems? What table structures would you recommend?

e) Given your answers to problem d, show the table contents for each table.

f) Identify the types of relationships (1:1, 1:M, or M:N) between the tables you defined in problems d and e.


Similar Documents

Database Management System

... DATABASE S YSTEMS DESIGN, IMPLEMENTATION, AND MANAGEMENT CARLOS CORONEL • STEVEN MORRIS • PETER ROB Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Database Systems: Design, Implementation, and Management, Ninth Edition Carlos Coronel, Steven Morris, and Peter Rob Vice President of Editorial, Business: Jack W. Calhoun Publisher: Joe Sabatino Senior Acquisitions Editor: Charles McCormick, Jr. Senior Product Manager: Kate Mason Development Editor: Deb Kaufmann Editorial Assistant: Nora Heink Senior Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Product Manager: Matthew Hutchinson Senior Art Director: Stacy Jenkins Shirley Cover Designer: Itzhack Shelomi Cover Image: iStock Images Media Editor: Chris Valentine Manufacturing Coordinator: Julio Esperas Copyeditor: Andrea Schein Proofreader: Foxxe Editorial Indexer: Elizabeth Cunningham Composition: GEX Publishing Services © 2011 Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as......

Words: 189848 - Pages: 760

What Is a Database System

...Database What is a database system? A database is can be thought of as an electronic file cabinet where everything is placed in it that needs to be remembered or to be documented for future referencing and where what you put in is exactly what you get out. In other words, a database holds everything that is important for you work or home. It is your e-filing cabinet. (Shenron, 2008) A database keeps important information for any future work close to hand so that the access of this information is almost instant without the hassle of paperwork or manual filing. This type of electronic data storage is very useful for users who are accessing the data from a network or shared drive. This allows users on the same network to have access to all the information at the same time without loss of data. Working for the State of Alaska as a Title 36 (public construction) Accounting Technician is very challenging as Alaska is a very big state and the requirements for this position are many and varied. One of the responsibilities is the management of the public construction database. This database holds all data on any public construction (over $2,000) in the state. The information is about the prime contractors, awarded state projects, the state agencies, who bid out the projects, and the projects themselves. Without the use of a database, there would be no reasonable way to track all the information that is required by this state office such as monthly reports, investigator reports,......

Words: 611 - Pages: 3

Database Systems

...DATABASE SYSTEMS To understand what drives database design, you must understand the difference between data and information. Data are raw numbers or other findings which, by themselves, are of limited value to decision makers. Information, on the other hand, is the result of organizing, processing, and interpreting data, thus transforming the findings into facts that are useful to decision makers. For example, the number of new users your clinic serves in a month means little until you compare it with the number of new users from previous months and years to see whether there has been an increase or decrease in the trend over time. Data are transformed into information by: Selection: Choosing the data that are useful and adequate for answering the questions that have been posed, and ignoring the data that are useless or inadequate for that purpose. Interpretation: Analyzing the data to put them into context, uncover patterns or problem areas, and reflect on the meaning of these patterns in relation to the questions being asked. The overall objective of converting data to information is to describe, explain, predict, and/or evaluate a program and its results. In this “information age” production of accurate, relevant and timely information is the key to good decision making. In turn, good decision making is the key to business survival in a global market. We are now said to be entering to “knowledge age”. Data are the foundation of information which is bedrock of......

Words: 4278 - Pages: 18

Database Systems

...Problems 2,4,5,6 2. What is data redundancy, and which characteristics of the file system can lead to it? Data redundancy is a condition that exists when data environment contains redundant (unnecessarily duplicated) data and conflicting types of the data show up in other places. It can also cause information anomalies, as a change event may require multiple changes to the data. 4. What is a DBMS, and what are its functions? A database management system is a collection of programs that manages the database structure and controls access to the information stored in a database. 5. What is structural independence, and why is it important? Data characteristics that exists when changes in the database schema do not affect data access. Structural independence is important because when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. 6. Explain the differences among data, information, and a database. Data are raw facts and information is the result of processing raw data to reveal meaning and stored in a database. Chapter 2 problems 13, 14, 15 13. What is a table, and what role does it play in the relational model? A table is a matrix of intersecting rows and columns. In the relational model, the table view of data makes it easy to spot and define entity relationships, thereby greatly simplifying the task of database design. 14. What is a relational diagram? Give an example. The relations......

Words: 427 - Pages: 2

Database System

...Hector Platon Carol Segura Fundamentals of Database Systems CS251-1303B-03 20 Aug 2013 According to Mike Chapple, Server Base Databases (Microsoft SQL, Oracle or IBM DB2) are commonly used in large organization as this type of database is able to handle sufficient amount of data simultaneously within reach of any users. This data is being updated to the server once a user resaves the file (Chapple, 2013). Server Base Database offers flexibility, powerful performance and scalability for its users which makes it a major choice for servers in most organizations. File Database (QSYS, SQLite) uses simple functions and generally uses single disk file. File Database can use several platforms. File Database can be used in 32 bit and 64 bit systems. File Database offers an excellent array of stability to its users as it functions cross platforms. Data sharing is better processed in bigger line of database management systems such as server base, wherein throughout the organization the synchronization of data is immense and constant changes is created simultaneously while File database may offer and give out cross formatting features for its clients however it can only handle minimal amount of data and is rather less reliable than the server base (Hip, 2013). My recommendation to my supervisor is to use a single database in both receiving and shipping area. The conflict begins with the shipping department that uses a Cobol program that is a stand-alone and......

Words: 480 - Pages: 2

Database System

...Only. Computer Science Volume 1 Silberschatz−Korth−Sudarshan • Database System Concepts, Fourth Edition Front Matter 1 1 11 11 35 35 36 87 140 140 141 194 229 260 307 307 308 337 363 393 393 394 446 494 529 563 563 564 590 637 Preface 1. Introduction Text I. Data Models Introduction 2. Entity−Relationship Model 3. Relational Model II. Relational Databases Introduction 4. SQL 5. Other Relational Languages 6. Integrity and Security 7. Relational−Database Design III. Object−Based Databases and XML Introduction 8. Object−Oriented Databases 9. Object−Relational Databases 10. XML IV. Data Storage and Querying Introduction 11. Storage and File Structure 12. Indexing and Hashing 13. Query Processing 14. Query Optimization V. Transaction Management Introduction 15. Transactions 16. Concurrency Control 17. Recovery System iii VI. Database System Architecture 679 679 680 705 750 773 773 774 810 856 884 Introduction 18. Database System Architecture 19. Distributed Databases 20. Parallel Databases VII. Other Topics Introduction 21. Application Development and Administration 22. Advanced Querying and Information Retrieval 23. Advanced Data Types and New Applications 24. Advanced Transaction Processing iv Silberschatz−Korth−Sudarshan: Database System Concepts, Fourth Edition Front Matter Preface © The McGraw−Hill Companies, 2001 1 Preface Database management has evolved from a specialized computer application to a......

Words: 301237 - Pages: 1205

Database Systems and How They Are Used

...Database Systems and How They are Used DBM/380 Week 1 Individual Assignment Craig Gruenbaum Instructor: Kevin Judge Database Systems and How They are used Database systems are utilized in basically every business every day. Businesses use data to perform a multitude of functions, such as sales transactions, customer queries, and the viewing of key performance indicators. Database systems are the management tool that aids in accessing this data. “In a sense, a database resembles a very well-organized electronic filing cabinet in which powerful software (the DBMS) helps manage the cabinet’s contents”(Rob, P., Coronel, C., & Morris, S, 2013). Database Architecture Database Architecture refers to the design of the database. For example, databases can be designed for a single site or multiple sites, have lots of generic data or data designed for a specific purpose, or be transactional or analytical. Take Oracle database architecture for example. “Oracle9i, Oracle8i, and Oracle8 databases are powerful, flexible, and scalable relational database management system (RDBMS) servers that run on a range of computer systems, from personal computers to largest mainframes. Oracle is designed to run effectively in a client/server environment and supports hundreds to thousands of users” (Oracle, "Migration Process", 1998). Summary Without database systems, companies would have no means by which to access the information stored in their databases. This......

Words: 497 - Pages: 2

Database Systems for Business

...How can Play On Toys ensure its information technology systems are ready for growth? Issue: Play On Toys has enjoyed 5 years of success in the European market, experiencing strong growth, particularly in the past year, increasing its staff from 16 to 60 employees. With 200 customers, Play On Toys fulfils 3000 orders annually, with a turnover of 5million Euro and 1.4 million in pre-tax profit. Having expanded its range from 2 to 20 products, Play On Toys now works with 30 suppliers to acquire the 110 parts required to manufacture its wares. Expansion into Asia, Africa and America is planned over the coming three years, with the accompanying growth and challenges of moving into new markets and expanding the operation, Play On Toys is at a critical junction. Ensuring that internal systems are functioning at highest efficiency and are prepared for growth are essential elements for the continued success of Play On Toys. Currently, records and information for critical areas including sales, financial, production, and customer relations are held in isolated electronic and paper files as well as some small databases. Essential reporting and transaction processing are highly dependent on manual inputs. Critically, sales orders submitted via the website must be manually processed by sales administrators in a process requiring printing orders and entering them into a spreadsheet manually. The current system of record keeping and reporting lacks cohesion and efficiency, and......

Words: 3888 - Pages: 16

Database Management Systems

...Database Management System Basith Shaik Southern New Hampshire University September 7, 2015 Abstract The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal Compliance, Ethical Practices, Security Needs and Security Plan Keywords: Grandfield College, Database Design, Recommendations, Business Rules, Data model, Security Plan Database Management System Grandfield College is in need of Database Management System as law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. For this purpose I have developed a Software Tracking database for Grandfield College. Problem Grandfield College is in need of a database for effectively tracking faculty and staff computers, the software installed on those systems, User access to each computer, and requests for new software......

Words: 4672 - Pages: 19

Database System

...Chapter 1 Databases and Database Users Copyright © 2011 Pearson Education, Inc. Publishing as Pearson Addison-Wesley Chapter 1 Outline         Types of Databases and Database Applications Basic Definitions Typical DBMS Functionality Example of a Database (UNIVERSITY) Main Characteristics of the Database Approach Types of Database Users Advantages of Using the Database Approach When Not to Use Databases Copyright © 2011 Ramez Elmasri and Shamkant Navathe Types of Database Applications  Traditional Applications:   Numeric and Textual Databases in Business Applications More Recent Applications:      Multimedia Databases (images, videos, voice, etc.) Geographic Information Systems (GIS) Data Warehouses Real-time and Active Databases Many other applications  Initial part of book focuses on traditional applications  A number of recent applications are described later in the book (for example, Chapters 26,27,28,29) Copyright © 2011 Ramez Elmasri and Shamkant Navathe Basic Definitions      Database:  A collection of related data. Data:  Known facts that can be recorded and have an implicit meaning. Mini-world:  Some part of the real world about which data is stored in a database. For example, student registration, grades and transcripts at a university. Database Management System (DBMS):  A software package/system to facilitate the creation......

Words: 1892 - Pages: 8

Fundamentals of Database System

... Addis Ababa Institute of Technology ITSC Fundamentals of Database Systems Laboratory Practice Note: This laboratory practice will be evaluated at the end (10% of final grade) Prepared BY: Tigabu D. Based on the information given below Develop: i) ER diagram for the company ii) Convert the ER diagram you designed in question I in to tables (relational database) iii) Implement the tables and relationships in question ii using a DMBS of below a. Microsoft access 2007/2010/2013 (Select One version) b. My SQL or Windows SQL Server 2005/08/12 (Select One version) Company Information: ■ The company is organized into Departments. Each department has a name, number and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. ■ Each department controls a number of Projects. Each project has a unique name, unique number and is located at a single location. ■ We store each Employee’s social security number, address, salary, sex, and Birthdate. ■ Each employee works for one department but may work on several projects. ■ We keep track of the number of hours per week that an employee currently works on each project. . ■ Each employee may have a number of Dependents. ■ For each dependent, we keep track of their name, sex,......

Words: 254 - Pages: 2

Database Systems

...Jose P. Mendoza CISS 430 Database Systems January 24, 2016 Instructor: Gary Farrar Assignment: Week 2 Dropbox Q 2.20 Write an SQL statement to display unique WarehouseIDs. Statement: select DISTINCT WarehouseID from INVENTORY Q 2.29 Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Do not use the BETWEEN keyword. Statement: select SKU, SKU_Description, WarehouseID, QuantityOnHand from INVENTORY where QuantityOnHand > 1 and QuantityOnHand < 10; Q 2.31 Write an SQL statement to show a unique SKU and SKU_Description for all products having an SKU description starting with “Half-Dome”. Statement: select SKU, SKU_Description from INVENTORY where SKU_Description = 'Half-dome'; Q 2.33 Write an SQL statement to show a unique SKU and SKU_Description for all products having a ‘d’ in the third position from the left in SKU_Description. Statement: select SKU, SKU_Description from INVENTORY where SKU_Description like '__d%'; Q 2.36 Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Name the sum TotalItemsOnHand and display the results in descending order to TotalItemsOnHand. Statement: select distinct WarehouseID, SUM(QuantityOnHand) as TotalItemsOnHand from INVENTORY group by WarehouseID order by TotalItemsOnHand; Q2.42 Write an SQL statement to display the SKU,......

Words: 376 - Pages: 2

Database Management System Tutorial

...Database Management System Tutorial.pdf Free Download Here Database Management System [DBMS] Tutorial i DATABASE MANAGEMENT SYSTEM [DBMS] TUTORIAL Simply Easy Learning by Tutorial: Introduction to Database Systems Database%20Systems.pdf Tutorial: Introduction to Database Systems ! 3.2! ... The!software!used!to!do!this!grouping!is!called!arelational!database!management!system.!The!term! COURSE: DATABASE MANAGEMENT SYSTEM - Gi?i thi?u There will be tutorial lectures to organized for this course. ... MBA 758 DATABASE MANAGEMENT SYSTEM •Database normalization is usually performed when designing a CP 4105 Database Management System ystems%20Tutorial.doc semester-iv. cs 4105 database management system tutorial sheet. department of computer science and engineering, b. i. t. mesra. introduction. 1. discuss the main ... Got a MySpace Page? Table of Contents - Idea2IC Database Management Systems This is the main screen you'll see when opening up Access to view an existing database. The outer part is the database management system ....

Words: 455 - Pages: 2

Database Systems

...Database Systems name 3-12-2012 Web-407 Advanced Web Development instructor's name Introduction Most companies need some type of database. A company may be small or extremely large but they all share one thing in common, if they make any type of product, sell anything, keep contacts, balance the books, pretty much anything a business can any will do, they need some type of database or multiple databases to store and later retrieve the data a typical business generates. Choosing the right database is even more important in the age of the Internet, products and services can be sold around the world now and the data from shopping carts and other payment and shipping needs a database too. This article will go into a bit more detail on some of the types of databases that are available and how to pick the right one for your company. Open Source vs. Proprietary This is the big question on a lot of businesses minds these days. Rather to try and cut costs by integrating an Open Source database or a proprietary one. First off let us go over what open source means. Open source software, in this case a database, is software that generally has a limited license for free using. The software is developed and maintained by developers and coders around the world that continuously work at improving the software but providing security upgrades and bug fixes. Proprietary software on the other hand is generally developed, upgraded and patched by a company that sells or licenses the......

Words: 1313 - Pages: 6

Database Systems

...Database Systems Adam Fabian DBM / 380 Database Systems Database Systems are emerging as an essential technology in today’s digital society. As human dependence on technology continues to evolve, databases continue to provide the backbone to any customer or data based system and assist organizations in storing vast amounts of information in a reference-able and organized manner. Database systems are specially designed pieces of software that store and organize vast amounts of data in a logical way that users can understand. The size of a database can range anywhere from a few simple records to millions of user accounts with detailed information and data. At my work, databases play an integral part in our company’s success. My current employer, Phoenix Diagnostic Imaging, handles thousands of records related to patient examinations conducted at our facility. The data for each patient is stored in a patient object within the database and referenced using the functionalities provided within the database application. Each one of these objects stores personal information, insurance information, examination data and images, paperwork from each visit, and referring doctor contact information. Employees use this system constantly to access patient records and insert new data into the patient records. Database architecture plays an important role in the success of a database. The three main types of database architecture are the one-tier, two-tier,......

Words: 792 - Pages: 4