...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 few...
Words: 1876 - Pages: 8
...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 natural...
Words: 9678 - Pages: 39
...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 completes...
Words: 667 - Pages: 3
...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 inventory...
Words: 637 - Pages: 3
...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 helps...
Words: 2020 - Pages: 9
...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 the...
Words: 2693 - Pages: 11
...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 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 express...
Words: 392 - Pages: 2
...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 Wal-Mart...
Words: 616 - Pages: 3
...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 information...
Words: 464 - Pages: 2
...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
...“Petilla Dormitory” Sampaloc, Manila A Case Study in Database Design Partial Fulfillment of the Requirements in Database Lecture Bachelor of Science in Information System Submitted by: FRANCIA, Jan Diether GISALA, Aaron MORALES, Shiela May C. NOARIN, Jenny M. October 2015 Table of Contents Title page ------------------------------------------------------------------------ I I. Overview A. Company Profile ------------------------------------------------------------- 1 B. Sample Forms --------------------------------------------------------------- 2 II. Database Planning A. Mission Statement ----------------------------------------------------------- 3 B. Mission Objectives ----------------------------------------------------------- 3 C. Project Team and Responsibility Assignment ------------------------------ 4 III. Database Boundary A. System Boundary ------------------------------------------------------------ 5 B. Database User --------------------------------------------------------------- 6 C. Data Dictionary -------------------------------------------------------------- 7 IV. Requirements Collection and Analysis A. Database Normalization ---------------------------------------------------- 14 V. System Specification A. System Specification ------------------------------------------------------- 15 VI. Physical Database Design A. Physical Database Design -------------------------------------------------- 16 ...
Words: 2260 - Pages: 10
...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...
Words: 404 - Pages: 2
...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 people...
Words: 564 - Pages: 3
...Stock Portfolio Management The following exercises are designed to provide you more practice with querying an Access database. To begin this exercise, retrieve the file PortfolioManagment.accdb from Blackboard (found in the Learning Module called Databases & Access -> Presentation & Data Files). Open the database file. Design Challenges 1. Open the Client table. How many records does it have? ______ How many fields does it have? ______ 2. What is the primary key for the Client table? 3. Set the primary key for the Stock table. 4. Review the data types assigned to the Stock Purchase table. One data type is incorrect. Please correct the data type and save the change. 5. Set the primary key for the Stock Purchase table. 6. Create a form for the Client table that allows easy entry of a new client. 7. Using your form you just created, add yourself to the Client table. Call the form Client Entry Form. 8. Add your favorite stock to the Stock table. Make up data if you do not know specifically what exchange or current price it trades at. 9. Buy 100 shares of the stock that you just added to the Stock table. Query Challenges 10. Select the Stock table. Create a query called NYSE Stocks that lists all stock tickers traded on the NYSE. The resulting query should be sorted by the stock’s name. 11. Select the Stock table. Create a query called Expensive Stocks that lists all stocks whose stock price is greater...
Words: 437 - Pages: 2
