Database Design

In: Computers and Technology

Submitted By completelypc
Words 481
Pages 2
UOPX
IT380 Database Concepts
Database Design Paper
5/7/12

A database is a set of programs and applications used to store data, this allows the data to be used by different individuals in different areas and access information from it quickly. A database stores the information so that it can be used at a later time and so that additional information can be added, taken away, or used as needed.. Once in the database the data is compressed so that it takes up less space in the computer’s memory. The database allows those authorized to use the data within it and control the creation, maintenance, and use of a database. A database stores various kinds of files, data records, and other objects. There are a variety of database models; there is the relational model or object model, which supports applications. That use query languages, which are high level programming languages, and dedicated database languages that simplify writing database application programs. The main function of a database is basically retrieving and presenting information it controls, in doing this it allows the users data access, protects the data’s and makes it more manageable. It also provides safety features for the data so that it is not lost or misplaced and if there is a serious event or natural disaster, fire etc. it can be recovered and restored from a backup. In my work we use Microsoft Access as a relational database for employment record s and to store our client information such as names addresses phone number and email addresses from this database we send out a monthly newsletter with special offers on services and products. By using the database it saves our company time and money because it a few simple steps we can email all of our clients and customers a monthly newsletter which informs them about what is happening with our company what services and products we offer and…...

Similar Documents

Database Design

...Database Design and how it is used at Wal-Mart Benjamin Stites DBM/380 7/2/2012 University of Phoenix. What is a Database System? A database system consists of four components which are the users, the database application, the database management system, and the database itself. We will describe all four components briefly. Database: The database allows a business to store important data using a collection of related tables and other structures. Database Management System: A database management system is a computer program that is used to create, process, and administer the database. (Kroenke & Auer, 2010) Database Application: A database application is a set of one or more computer programs that serves as an intermediary between the user and the database. They read and or modify database data by sending SQL statements to the database. User: The user is the fourth component of the database system. The user employs database applications to keep track of things. They use forms to read, enter, and query data, and they also produce reports. These four components allow the database system to work properly. How does Wal-Mart use its Database System? Wal-Mart is the largest retail company in the world. It needs to keep track of employee data, sales data, inventory data, profit data, and many other types of data throughout each of its stores. In order to keep up with this information Wal-Mart has outsourced its database to NCR. This allows......

Words: 616 - Pages: 3

Database Design Paper380

...Database Design Paper James Elkins University of Phoenix Database Design Paper It is normal practice today for organizations to store large quantities of records of related information as computer based files or databases. A database is a structured collection of records or data that is stored in a computer system (Sage publications). Databases are important in today’s business world. The backbone of information for large businesses is the database system. Information stored in a company database is a useful tool for the success of a company. Most companies today have some form of database system. Database architecture is the set of specifications, rules, and processes that dictate how data is stored in a database and how data is accessed by components of a system. It includes data types, relationships, and naming conventions. The database architecture describes the organization of all database objects and how they work together. It affects integrity, reliability, scalability, and performance. The database architecture involves anything that defines the nature of the data, the structure of the data, or how the data flows (Database Architecture Fourth Edition). My work place includes a NAPA automotive parts distributorship. The computer system is based on a relational database system which keeps up with the sale of parts and the ordering of parts along with inventory on hand. NAPA employs a company called TAMS (Total Automotive Management Systems) which is their IT......

Words: 564 - Pages: 3

Database Design

...DATABASE DESIGN One of the most important if not the most important aspect of a database is the database design process. It is a must that the design is good and functional. A database consists of many different parts of an engineer’s design, which together makes up a complete database system. A database system is designed to manage large bodies of information. Database design is the construction of a database as a subsystem of an information system. Therefore, the database design process is an integral component of the information system design process. ( Chilson and Kudlac, 1983). One of the greatest problems in the application design process is the lack of foresight. During the design process there must be a thorough evaluation of your database, what it should hold, how data relates to each other, and most importantly, whether it is scalable. When it comes to the maintenance of your database it should be easy to maintain, this means storing as limited amount of repetitive data as possible. Let’s say you have a lot of duplicate data, and one instant of that data undergoes a name change, that change has to be made for all occurrences of that data. You can overcome this duplication problem by creating a table of possible values and use a key to refer to the value. That way, if the value changes names, the change occurs only once, in the master table. What are the steps involved in the database design. First, you must determine the purpose of your database, this......

Words: 2020 - Pages: 9

Database Design

...Database Design Paper John Hancock DBM/380 April 23, 2013 April Johnson Database Design Paper Database systems are an organized collection of data. The data is normally organized by a couple different methods; structured and unstructured. Database systems make working in a company a lot easier when an employee is looking for information. By having a database management system in the work place the employees will have improved data sharing, data security, data access and better data integration. A couple examples of databases would be Oracle, Microsoft Access and Microsoft SQL Server. Oracle’s primary function is to store and retrieve data as it is requested. Database architecture not only focuses on the design, development, implementation and maintenance of computer programs that store and organize database information for any business or company big or small. Also a database architect my use a vast array of different languages to create a database, one language is called the structured query language or SQL. When I was in the Navy at first I didn’t realize how structured all of the information was and how much information was actually kept on file. Every duty station has a database system that is used which is Oracle. This database in particular is a very great database for the Navy to use because as information is needed a service member can access the information on the Oracle database cloud at any given time. Also the service member will know that the......

Words: 464 - Pages: 2

Database Design

...Database Design DBM 380 | | Databases Databases are electronic filing systems that consist of objects (Microsoft, para 2.) providing a quicker means to data retrieval than traditional paper and pen models. They have more flexibility than standard spreadsheets and offer the ability to run query searches. A properly designed database can retrieve items in complex searches; a task that might take hours or days manually, in a matter of minutes. Databases are designed to store large amounts of information without redundancy or inconsistencies (Microsoft, para 1.) Database information can be used to generate reports for specific topics, create mailing lists, manage data, share data with other programs, and perform calculations of data. Databases also can provide an area of storage for document retrieval, such as a school digital library. At work we use a complex data system known as an AS/400 system that can store and retrieve data. Database Architecture According to Georgetown University (n.d.,) database architecture is “the collective application and database instances that comprise the complete system.” This means that defined rules and specifications determine how data is stored and accessed. Web-based database architecture can use two-tier architecture or three-tier architecture depending on if the DBMS and Web server are both on the same computer (Kroenke, p. 452.) As a three-tier database architecture system the AS/400 is used to keep track of......

Words: 637 - Pages: 3

Database Design

...Database Design DBM502 – Database Management March 24th, 2014 University of Phoenix Professor: Sam Haidar EzStream This paper will provide an overview of the database to be utilized for the startup company EzStream Inc. The core business of EzStream is to provide a complete solution to stream media content via online or WIFI. Customers will have the choice to rent, buy, or pay a monthly subscription to watch media content. Several components will break down the development of the database and provide details to the database infrastructure. Conceptual Design The conceptual design of EzStream’s DB will consist of Movies, Suppliers, and Customers. Customers will either rent or purchase movies, and have the option of paying a monthly subscription rate to watch movies via digital streaming. Data Analysis and Requirements * Tasks during Research and Analysis: * Identify essential "real world" information (e.g. interviews) * Remove redundant, unimportant details * Clarify unclear natural language statements * Fill remaining gaps in discussions * Distinguish data and operations Requirement Analysis First step: filter essential information vs unimportant details * Essentials * There are customers, suppliers, and media content * Identify age of audience for rentals * Customers have a customer identification number * Four weeks maximal rental time. * Unimportant details * "...Rentals since a......

Words: 1876 - Pages: 8

Database Design Final Review

...Database Final Exam review 1. What is data? Data are values of qualitative or quantitative variables, belonging to a set of items 2. What is information? Data becomes information after it has been processed to add context, relevance and purpose. 3. Role of data and information – Data and information allow users to make better decisions based on good information and data 4. Field – a column in a table which is a property of an entity (attribute) 5. Record – A row or tuple in a table 6. Tuple – A record or row in a table 7. ACID - ACID stands for Atomicity, Consistency, Isolation, and Durability. Atomicity means if one part of the transaction fails, all of the transaction fails, leaving the database unchanged. Consistency means the data written must be valid according to all the rules and the rules are applied from state to state. Isolation means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. It is executed as if it were being executed serially. Durability ensures that once transaction changes are done, they are permanent and cannot be undone or lost, even in the event of a system failure. 8. What is data redundancy and which characteristics of the file system can lead to it? Data redundancy exists when unnecessarily duplicated data are found in the database. It is the result of poorly designed databases which allow the data to be stored in different......

Words: 2014 - Pages: 9

Database Design

...10ISB303 - Database Design | Report Explaining The Data Model For Creating A Conference Database | Loughborough University Department of Information Science | | Cherry Louise Maguire-A913339 | 3/1/2011 | | Contents 1.0 Introduction 3 2.0 Background 3 3.0 Entity Relationship Diagram 4 4.0 Relationship Statements for Database 5 5.0 Justification 6 5.1 Seminar Table 6 Seminar Table 6 5.2 Workshop Table 7 Workshop Table 7 5.3 Chair/Speakers Table 8 Chair Table 8 Speakers Table 8 5.4 Workshop presenters Table 9 Workshop Presenters Table 9 5.5 Presentation Table 10 Presentation Table 10 5.6 Exhibitions Table 11 Exhibitions Table 11 5.7 Exhibitors Table 11 Exhibitors Table 11 5.8 Delegates Table 12 Delegates Table 12 5.9 Costs Table 13 Costs Table 13 6.0 Word Count 13 1.0 Introduction This report includes an explanation of a data model for a Conference database. It will include my rationale behind the database design I have chosen, including an entity-relationship diagram and the expected structure of my database. ------------------------------------------------- 2.0 Background Loughborough University’s Department of Information Science annually hosts a seminar on ‘Electronic Public Information Provision’. This is typically a one-day event which has proved popular due to the events and extras included. The day includes presentations from various speakers, an exhibition and an array of workshops.......

Words: 2890 - Pages: 12

Database Design Paper

...Database Design Paper DBM380 March 09, 2015 Database Design Paper A database is a computer structure that organizes a collection of data so that it can be accessed, updated and managed as fast and efficiently as possible. There are several classifications of databases, “For example, databases can be classified by the number of users supported, where the data are located, the type of data stored, the intended data usage, and the degree to which the data are structured. The number of users determines whether the database is classified as single-user or multiuser. A single-user database supports only one user at a time. In other words, if user A is using the database, users B and C must wait until user A is done. A single-user database that runs on a personal computer is called a desktop database. In contrast, a multiuser database supports multiple users at the same time. When the multiuser database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization, it is called a workgroup database. When the database is used by the entire organization and supports many users (more than 50, usually hundreds) across many departments, the database is known as an enterprise database” (Coronel, Morris, & Rob, 2013, p. 9). Database architecture describes the rules that dictate how data is stored in a database and how data is accessed by components of a system. Database management software, such as Oracle, is designed to......

Words: 404 - Pages: 2

Database Design

...information services to meet the problems or opportunities of the business. A) Database analysts B) Users C) Systems analysts D) Programmers Ans1. (C)System Analysts TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 2) Database development projects are never done in a bottom-up fashion. Ans2. (F) 3) A well-structured database establishes the entities between relationships in order to derive the desired information. Ans3. (F) ESSAY. Write your answer in the space provided or on a separate sheet of paper. 4) Provide a brief overview of the various components of the database environment. TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 5) Database processing programs are coded and tested during the design stage of the systems development life cycle. Ans5. (F) MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 6) Organizing the database in computer disk storage is done in the ________ phase. A) Analysis B) design C) Implementation D) maintenance Ans6. (B)Design 7) A workgroup database is stored on a central device called a (n): A) client. B) Network. C) Server. D) Remote PC. Ans7. (C)Server TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 8) Many of the disadvantages of file processing systems can also be limitations of databases. Ans8. (T) MULTIPLE CHOICE. Choose the one alternative that best......

Words: 667 - Pages: 3

Database Design

...CIS 510 DATABASE DESIGN (WEEK 2) Submitted by: ShaileshwarParimala Arshad Ahmed Mohammed Mohammed WajahathHussain SajjadHussain Syed Uma Devi Singam Types of Database Management Systems A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. [pic] Advantages of DBMS: • Data abstraction and independence • Data security • A locking mechanism for concurrent access • An efficient handler to balance the needs of multiple applications using the same data • The ability to swiftly recover from crashes and errors, including restartability and recoverability • Robust data integrity capabilities • Logging and auditing of activity • Simple access using a standard application programming interface (API) • Uniform administration procedures for data Another advantage of a DBMS is that it can be used to impose a logical, structured organization on the data. A DBMS delivers economy of scale for processing large amounts of data because it is optimized for such operations. A DBMS can also provide many views of a single database schema. A view defines what data the user sees and how that user sees the data. The DBMS provides a level of abstraction between the conceptual schema that defines the logical structure of the database and the physical schema that describes......

Words: 2693 - Pages: 11

Database Design

...The Entity-Relationship Unified View of Data PETER PIN-SHAN Massachusetts Model-Toward a CHEN Institute of Technology A data model, called the entity-relationship model, is proposed. This model incorporates some of the important semantic information about the real world. A special diagrammatic technique is introduced as a tool for database design. An example of database design and description using the model and the diagrammatic technique is given. Some implications for data integrity, information retrieval, and data manipulation are discussed. The entity-relationship model can be used as a basis for unification of different views of data: t,he network model, the relational model, and the entity set model. Semantic ambiguities in these models are analyzed. Possible ways to derive their views of data from the entity-relationship model are presented. Key Words and Phrases: database design, logical view of data, semantics of data, data models, entity-relationship model, relational model, Data Base Task Group, network model, entity set model, data definition and manipulation, data integrity and consistency CR Categories: 3.50, 3.70, 4.33, 4.34 1. INTRODUCTION The logical view of data has been an important issue in recent years. Three major data models have been proposed: the network model [2, 3, 71, the relational model [S), and the entity set model [25]. These models have their own strengths and weaknesses. The network model provides a more......

Words: 9678 - Pages: 39

Database Design

...This project is to design database document. This assignment consists of two (2) sections: a project introduction and a design document. You must submit both sections as ONE file for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and/or assume all necessary assumptions needed for the completion of this assignment. You are currently the Chief Information Officer (CIO) for an innovative Internet-based company with gross revenues of more than $35 million dollars per year. During an executive leadership meeting, you were told that your company will be merging with a multinational company of equal size and you will be responsible for developing a project plan to strategically integrate all systems, including databases and infrastructure. The Chief Executive Officer has given you sixty (60) days to deliver an information technology project plan in anticipation of the company merger. Your company will be expanding from one (1) floor to three (3) floors within six (6) months. Since this merger will be bringing two (2) fairly equal-sized companies together under one roof, the infrastructure must be redesigned to accommodate the increased needs. Your company currently uses operational systems and relational databases but desires to expand into data warehousing. All information technology (hardware and software) must be redesigned to meet organizational needs. The solution should be......

Words: 1238 - Pages: 5

Database Design

...Running Head: UNIT 2: DESIGN A RATIONAL DATABASE SYSTEM Unit 2: Design a Rational Database System Dale Henderson Kaplan University Professor Michael Collins IT520: Database Management Systems August 12, 2013 |Term |Definition |Example | |Attribute Inheritance |Let’s the entity subtype to inherit the |Pilots, mechanics, and accountants all inherit | | |attributes and relationships of the supertype |the employee number, last name, first name, | | |(Coronel, Morris, & and Rob, 2013). |middle initial, and hire date from the EMPLOYEE| | | |entity, but the pilots have unique attributes, | | | |the same is true for the mechanics and | | | |accountants. All entity subtypes inherit their | | | |primary key attribute from their supertype | | ...

Words: 915 - Pages: 4

Database Design

...Database Design Donavan Mitchell Database Concepts DBM/380 ALINE VOGT Database systems are structured collections of data stored in a computer system. A database must not only store large amounts of records, they also must be easy to accessed. New changes and information should be easy to input as well. Stored data that can be easily defined, like availability of equipment, cars, etc. Data that is organized to model relevant aspects of reality in a way that supports processes requiring this information Data modeling is a process used to define and analyze data requirements needed to support business processes within the scope of corresponding information in organization. It can also be thought of as a diagram or flowchart that illustrates the relationship between data. Data modeling tools and technique capture and translate complex system designs into easily understood representations of data flows and processes. Relational Model must try and develop a consistent, logical representation of information. It also provides a declarative method for queries and specifying data. Information is stated by the user and what information the database contains, gathering what they want from it. The database management system software takes care of describing data structures for storing the data and retrieval procedures for answering queries. Entity Relationship Models (ER Model) is an abstract way to describe a database. This model is the most common way to......

Words: 392 - Pages: 2

Web Apps | The Walking Dead No Man's Land premium | Therese Plaehn