Database Design Paper

In: Computers and Technology

Submitted By deerslayer5783
Words 404
Pages 2
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 handle the data and store them so that accessing, and updating any part of the data is easier and more efficient. Data storage management is also important for database performance tuning. “Performance tuning relates to the activities that make the database perform more efficiently in terms of storage and access speed” (Coronel, Morris, & Rob, 2013, p.24 ). In my place of employment a database…...

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

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

...A database management system, or DBMS, is the category of computer software programs that are used in the creation, organization, retrieval, analysis, and sorting of information in computer-based databases. A database management system is comprised of: * A modeling language, which is used to define the database structure. Commonly, database structures are hierarchical, network, relational, and object based. How they go about connecting related information is where models differentiate. The relational database model is the most widely used. * A database engine, which manages the structure of the database and optimizes data storage for a balance of quick retrieval of information and an efficient usage of space. * A database query language, that allows developers to write programs that extract data from the database, present it, and allow for the saving and storage of changes. * A transaction mechanism, which validates data before storing it while also ensuring numerous users are not allowed to corrupt the data by updating the same data at the same time “Database architecture focuses on the design, development, implementation and maintenance of computer programs that store and organize information for business, agencies and institutions”. One such example is Microsoft SQL Server. There are four system databases in each instance of Microsoft SQL Server (master, model, tempdb, and msdb) and at least one user database. Some companies have a database used by...

Words: 260 - Pages: 2

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 Amanda Chavez DBM/380 February 16, 2015 Pamela Hurd It is important for a business to keep track of certain data. Data management works best if the business has a computer database. A database is a computer structure that stores end-user data and metadata. A database allows data to be saved, managed and retrieved whenever data is needed. It is essential for businesses to save all of their data, such as products they are selling, because this type of data can become useful when there is a decision to be made. Businesses can use the data as a source. Businesses use databases as a way to store their data. They are able to retrieve the data whenever they need it. Modern businesses depend heavily on databases. Databases store a business’ valuable data. A business’ database can hold email addresses, phone numbers, and names which can help the business sell more of their products and/or services. Databases are also used to provide information to the general public. For example, long ago we used the Yellow Pages to look up a person’s contact information. Nowadays, the YP book is still made but they also have the website, which is more modern for today. Database architecture uses programming languages to design, develop, implement and maintain a certain type of software that allows businesses to store information. The goal is to meet the needs of users. Oracle is an example of database architecture. Oracle Database is the first database created for......

Words: 474 - 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

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

Database Design Paper Dbm 380

...Database Design Paper Joseph Schmosef University Of Phoenix (ecampus) DBM/380 Sunday, April 01, 2012 “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input.” (tech-faq.com) To ensure usefulness over the long-term, databases should be built with high data integrity and the ability to recover data if the hardware fails. Information that has been corrupted or destroyed serves no purpose within a business structure. Being the Armed Forces is like being a field value in one giant database. Everything from the gear we are issued to how we are identified as an “individual” (ssn#) is a scannable number to be coded, referenced, and utilized by anyone with proper clearance. “The database architecture is the set of specifications, rule, and processes that dictate how data is stored in a database and how data is accessed by components of the system.” (wingenious.com) Database architecture type s can be broken down into three broad categories, each of which can have several subcategories: One Tier, Two Tier- client/server, and “N” Tier- client/server. The One Tier architecture is best suited to the single user and relatively small amounts of data. It runs on the user’s local machine and references a file that is stored on that......

Words: 668 - Pages: 3

Database Design

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

Words: 481 - Pages: 2