Cs251 Fundamantals of Database Systems Ip 1 - 5

In: Computers and Technology

Submitted By billyfishkill
Words 1691
Pages 7
CS251-1301B-03 Fundamentals of Database Systems
Phase 1 -5 Individual Project
March 24th, 2013

Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18

Project Outline

My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks. We will perform counter sales, contractor and walk-in customer kitchen and bath design, templates, fabrication, installation, and follow-up. To run efficiently (or at all) we must have a centralized DBMS with access for all employees in order to keep track of the progress of the workload and get the products delivered and installed on time. Issues with the process must be immediately known and corrected as this is a high value product with a small profit margin at this point in our economy. Any miscommunication can be disastrous. The MasterStoneWorks database will have the following tables: * Customers * Sales * Installs * Product choices * Costs (wholesale and retail) * Sales people * Project Managers * Templates * Follow-up * Customer support

Description of the Database Design Life Cycle

The seven steps of the SDLC/DBDSL: 1. Concept Planning – This first step is where the need to develop, or improve a system is ascertained along with parameters such as costs, risks, and feasibilities. Roles and responsibilities are designated at this stage. 2. Requirements Analysis – This phase addresses the requirements needed for functioning, support, and training. It begins after the projects parameters have been specified and costs have been allocated. This is where the initial life cycle management plans are…...

Similar Documents

Paper on Database Management Systems

...International Journal of Scientific & Engineering Research Volume 3, Issue 3, March -2012 ISSN 2229-5518 1 A Distributed Transaction Model for a Multidatabase Management System Omar Baakeel and Abdulaziz Alrashidi Abstract— This paper examines the distributed transaction issues that are present in multi-database management systems (DBMSs) and how the distributed transaction in database technology differs from other distributed processing systems. Some common issues that arise with the distribution of transactions over a multi-DBMS while dealing with concurrency control and recovery are highlighted, such as site failure, network failure, and time failure. This study proposes an exceptional distributed transaction model for processing transaction queries in multi-DBMS based on the idea that a complete database can be constructed at any stage. Index Terms— Database management system (DBMS), distributed transaction, transaction management, transaction network —————————— —————————— 1 INTRODUCTION ENERALLY, a distributed transaction is defined as a transaction that updates data on two or more networked computer systems. Different conceptual structures for processing transaction elements are required to meet certain needs of applications that must update distributed data in terms of peer to peer connection. Developing a transaction model is difficult because most of these techniques are customized for a single transaction point, and many types of failures, such as client......

Words: 2094 - Pages: 9

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

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

Unit 1 Ip Operating System Choice

... Speed, how fast the computer can complete a task, this will be second most important for rendering images and code for games. Looking at the needs of the company my recommendation would be for the company to run PC’s with Windows 7. I recommend this OS for several reasons: its newer, resource management, security options, very compatible, easy to maintain and upgrade. When it comes to any large task that requires a PC to be tasked, resource management is going to be crucial. In the field of game development the largest task is going to be rending and compiling the game. Both of these require lots of memory, CPU time and hard drive activity. Windows 7 can stand up to the task because of it new and improved resource management system over Vista and XP. Its more streamlined programming allows for less usage by the OS to running tasks in the background, and more integrated drivers allow for better control over the hardware and what it is doing. In this sense Windows 7 can perform rending and compiling faster, more reliably, and securely. Another major advantage Windows 7 has over other OS’s is its security center. Windows 7 has a brand new security center that allows for more control over what has access and what does not. The security center controls the firewall, checks for updates, makes sure that virus protection is up to date, and has access to the user account control settings. With all of these features made easy access in one place makes setting up the......

Words: 854 - Pages: 4

Database Systems

...Chapter 1 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......

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 Systems Cornel/Morris Chapter 1 Summary

...Chapter 1 Database Systems Why Databases? * At the heart of all of these systems are the collection, storage, aggregation, manipulation, dissemination, and management of data * Databases are specialized structures that allow computer-based systems to store, manage, and to retrieve data very quickly Data vs. Information * Data – raw facts * Raw indicates that the facts have not yet been processed to reveal their meaning * You transform the raw data into a data summary * Information – the result of processing raw data to reveal its meaning * Data processing can be as simple as organizing data to reveal patters or as complex as making forecasts or drawing inferences using statistical modeling * To reveal meaning, information requires context * Raw data must be properly formatted for storage, processing, and processing * Ex: dates must be stored in Julian calendar formats and yes/no responses must be converted to Y/N or 0/1 * Data are the foundation of information which is bed rocked of knowledge * Knowledge – body of information and facts about a specific subject * Knowledge implies familiarity, awareness, and understanding of information as it applies to the environment * A key characteristic of knowledge is that “new: knowledge can be derived from “old” knowledge * Key Points: * Data constitute the building blocks of information * Information is produced by......

Words: 2824 - Pages: 12

Database System

...For Evaluation 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......

Words: 301237 - Pages: 1205

Database Systems

...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......

Words: 1762 - Pages: 8

Database 1

...1. What are the main differences between a file-processing system and a database management system? Ans: A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates only the physical access. 2. What are the major advantages of a database system? What are the major Disadvantages of a database system? Ans:- Advantages a) Controlling Data redundancy b) Data Consistency c) Data Sharing d)Data security Disadvantages:- a) Cost of hardware and software b) Cost of data sharing c) Database Failures d) Complexity 3. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2.? Ans: The database has shown the student information for smith and brown. It also represents the course details. Then it shows the intake of the subject and instructor. In grade report section its display the grade result of smith and brown. Also it illustrates the prerequisite for the major subject. From this Database we can get the information of student, course details, course instructor, prerequisite for the major subject and grade report of the student. 4. Discuss the capabilities that should be provided by a DBMS? Ans:- i) Restricting Unauthorised access ii) Providing multiple user interface iii) Controlling redundancy iv) Providing backup and recovery v) Providing persistence storage for programs object......

Words: 521 - Pages: 3

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

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 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