Premium Essay

Database Design Paper380

In:

Submitted By reggid
Words 564
Pages 3
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 that keep their system up-to-date. The retail outlets such as ours do not have access to the database; all we can do is make sure inventory in our store is correct.
Microsoft Access Access is a database program developed by the Microsoft Corporation. This program lets the user track and report information easily. Access is user friendly and accommodates beginning level users and experts

Similar Documents

Premium Essay

A Case Study in Database Design

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

Premium Essay

Data Development Cycle

...The database development Process Vamsinadh Machavarapu IST 7000 Wilmington University Table Of Contents Introduction...........................................................................................3 SDLC Phases.........................................................................................3 • Requirements Analysis...................................................................4 • Database Design.............................................................................4 • Evaluation and Selection................................................................5 • Logical Database design................................................................5 • Physical Database design...............................................................6 • Implementation..............................................................................6 • Data Loading.................................................................................7 • Testing and Performance Tuning...................................................7 • Operation.......................................................................................7 • Maintenance...................................................................................8 Conclusion.............................................................................................8 References.......................................................................................

Words: 1225 - Pages: 5

Free Essay

Logical Design and Physical Design

...Logical Design and Physical Design CMGT 555/ Systems Analysis and Development   Throughout the whole process of system development, there are designs that take place before any coding or setup takes place. During this time, phrases like logical design and physical design get tossed around a lot, but what are they and what do they mean? In short, the logical design defines what must take place, not how it is accomplished. The logical design is like a set of blue prints, it describes the actual processes of entering, verifying, and storing data. In this paper we will explain when logical designs and physical designs are used, what design information a logical design and physical design contain and any similarities or differences. Figure 1. Example of Logical Model and Physical Model for an ERD Relationship Diagram (Compare Logical and Physical ERD, 2009) The direct definition of a logical design “is the Conceptual Blueprint of a software application, illustrating entities, relationships, rules, and processes (Thibeault, 2011)”. So what is the logical design is used for? The logical design contains all the business entries, what each entries attributes are, and relationships among entries. Now the logical design to some is misleading because they often confuse it with detailed technical design, even though the goals for these two are not similar at all. Now when do we use the logical design? That question is simpler to answer; it usually starts during the requirements...

Words: 845 - Pages: 4

Premium Essay

Design and Implementation

...DIALOGUE SALESPERSON INFORMATION 5 USER REQUIREMENTS DIAGRAM 8 Forms 8 Report 13 DATABASE DESIGN 18 ARCHITECTURE DESIGN 22 CONCLUSION……………………………………………………………………………………………24 INTRODUCTION In the System Development Life Cycle (SDLC), there are four phases that need to be done to develop a system for used of by the organization. The phases are system planning and selection, system analysis, system design and implementation and operation. Since the planning and analysis phase have successfully completed, now we are continue with the next phase, which is systems design of the POS System in ARZA Coffee & Cakes. System design under System Development Life Cycle was a conversion of description of the recommended alternative solution into logical and physical specifications for the system starting from the input until the output screens consists of report, databases and computer processes. By that action the company might ease to reveals the real systems from which all the programming and system construction can be accomplish. This system could be implemented into any hardware and software since it is not tied up to any of the specific one. However, the logical design will illustrate the functions of the system in all aspects. In the physical design, the logical design will be interpret into the physical or technical specifications by convert the systems data to the structured systems design. DIALOGUE INDIVIDUAL CUSTOMER INFORMATION Figure 1 0 | Log-OnScreenSystem | 1 |...

Words: 3417 - Pages: 14

Premium Essay

Management Information Systems: Managing the Digital Firm

...Avinash Shankar Coleman University Database Integration – A framework The Physical Database Design depicts the actual structure of a set of relational tables specific to the platform and Database Management Systems (DBMS) on which the database is implemented. It is used to transition a logical data design into a physical database design that can be used to generate Data Definition Language (DDL). It also takes the current Systems environment into consideration, as well as some non-functional requirements. Basically the Physical Database Design is the implementation of the logical data design with any changes needed for physical considerations, such as capacity and performance. A physical database design is performed in three stages (LePendu, P., & Dou, D., 2011, p. 217 to 244): 1. Logical database design, which includes gathering of business requirements, developing a logical data model, and designing how to load the data 2. Conversion of the logical data design into a Physical Database Design includes table definitions, primary and foreign key relationships, and basic indexing 3. Post deployment Physical Database Design (often performed by a database administrator) includes improving performance, reducing I/O, and streamlining administration tasks. Data Integration Layer The data integration layer should be modeled in 3rd normal form or near 3rd normal form and is considered to be similar to an operational data design. In addition, the data integration layer...

Words: 582 - Pages: 3

Premium Essay

Tinga

...Semester One Mid-semester Examinations, 2015 MGTS1201 Computer-based Information Systems Venue Seat Number ________ Student Number |__|__|__|__|__|__|__|__| Family Name This exam paper must not be removed from the venue ____________________ _____________________ First Name _____________________ School of Business EXAMINATION Semester One Mid-semester Examinations, 2015 MGTS1201 Computer-based Information Systems This paper is for St Lucia Campus students. Examination Duration: 60 minutes Reading Time: 10 minutes Exam Conditions: For Examiner Use Only Question   Mark    This is a School Examination   This is a Closed Book Examination - specified materials permitted   During reading time - write only on the rough paper provided   This examination paper will NOT be released to the Library   Materials Permitted In The Exam Venue:   (No electronic aids are permitted e.g. laptops, phones)   An unmarked Bilingual dictionary is permitted   Calculators - No calculators permitted   Materials To Be Supplied To Students:     1 x Multiple Choice Answer Sheet   Rough Paper   Instructions To Students:   Please answer all multiple choice questions (MCQ) in the MCQ answer sheet provided. Please answer all short answer questions in the space provided within the examination paper. Please ensure you write your student number and name on the MCQ answer sheet...

Words: 2471 - Pages: 10