Free Essay

Logical Design and Physical Design

In: Computers and Technology

Submitted By Nigomas
Words 845
Pages 4
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 definition phase of the project and after the physical design. When working with the logical design, several pieces of important information needs to be included in the design. This information would include graphical diagrams that help when the business users and the developers sit down to discuss the system; it helps work through business problems and test out ideas.
During the logical design phase, there are deliverables that are provided in the design. Here is a list of these deliverables: * Full Object Model, System Level * Update Object Life Cycle Models * Object Interaction Diagram * System Wide Behavior Model * External Specifications * Initial Draft of Test Plan * Use Cases * Documentation Plan * Initial Draft of Test Scripts * Updated Project Plan * Methodology Compliance Form * Recommendation Form
The logical side represents the inherent nature of a business and only changes if the business changes, which is considerably less volatile than the physical.
Now that we have discussed the logical design, let’s move on to the physical design. To help fully understand the physical design we need to know what it is. The logical design of a system pertains to an abstract representation of the data flows, inputs and outputs of the system. This is often conducted via modeling, using an over-abstract (and sometimes graphical) model of the actual system. The physical components describe "how" it will be implemented. For example, companies have been implementing payroll systems for many years prior to the advent of the computer. We have seen payroll implemented manually, then with time clocks and punch cards, followed by automation on mainframes, minis and PC's. We have also seen such innovations as "direct deposit" to expedite paying employees, and electronic government reporting. All of these devices are simply a physical variation of a theme (Thibeault, 2011).
The physical design has many components what work within the design; it is very easy to get lost scanning all data that is involved. Physical design involves generating the schema for tables, indexes, default and check constraints, and views for a specific physical structure such as a database, file, or XML document (Physical vs. Logical Design). The one thing to keep in mind about the physical design is that it is all about the hardware and it is ultimately based off of the available technology and because of this, it changes drastically from time to time when hardware changes. The physical models can change as well because of hardware changes, even well after the application is deployed in the production environment.
The deliverable in the physical design is: * Full Object Model Technical Level * Internal Specifications * Transaction Plan * Updated Test Scripts * Updated Test Plan * Updated Project Plan * Methodology Compliance Form * Recommendation Form
In conclusion, the logical design and physical design can seem similar on paper when looking at them but they are different when you look at it more closely. The logical design is the blueprints or layout and the physical design is about the hardware and how it plays out in the system. We have also learned that the logical design does not change even though the physical design does change when hardware changes. The hardware my change, evolving the physical design but the processes and functions stay the same.

References

Compare Logical and Physical ERD. (2009, April 20). Retrieved December 04, 2011, from Visual Paradigm: http://www.visual-paradigm.com/highlight/compare_logical_physical_erd.jsp
Physical vs. Logical Design. (n.d.). Retrieved December 04, 2011, from SQLServerPedia: http://sqlserverpedia.com/wiki/Physical_vs._Logical_Design
Thibeault, K. M. (2011, February 14). Definition of a Logical Design. Retrieved 12 04, 2011, from Logical Design Database Solutions : http://www.logicaldesigndbs.com/definition-of-a-logical-design-2/

Similar Documents

Premium Essay

Management Information Systems: Managing the Digital Firm

...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 should leverage the...

Words: 582 - Pages: 3

Premium Essay

Relational Databases

...further advances were necessary to keep everything manageable. The relational database, designed in 1970 by E. F. Codd, represented a major breakthrough in database technology for both designers and users alike. The relational model is very simple, yet very effective in concept. As strange as it may be to think, the relational database pioneered the concept of using tables to hold and organize data. An Excel spreadsheet is probably the most obvious example of a relational database that the end user can relate to today. Essentially, a relational database is the logical view, rather than the physical view, of information. (Carlos Coronel, 2013) Logical vs Physical Design A relational database is considered to be a logical view of information, but it created through physical database design. To reach the final, physical, database that the end user experiences, it must be first designed on the logical level. A logical data model is necessary for the creation of any database, sort of like a blueprint. Like a blueprint, a good...

Words: 1200 - Pages: 5

Free Essay

Civil

...end-user, developers, systems engineers, project managers, etc., and to handle separately the functional and non functional requirements. Each of the five views is described, together with a notation to capture it. The views are designed using an architecture-centered, scenariodriven, iterative development process. Keywords: software architecture, view, object-oriented design, software development process Introduction We all have seen many books and articles where one diagram attempts to capture the gist of the architecture of a system. But looking carefully at the set of boxes and arrows shown on these diagrams, it becomes clear that their authors have struggled hard to represent more on one blueprint than it can actually express. Are the boxes representing running programs? Or chunks of source code? Or physical computers? Or merely logical groupings of functionality? Are the arrows representing compilation dependencies? Or control flows? Or data flows? Usually it is a bit of everything. Does an architecture need a single architectural style? Sometimes the architecture of the software suffers scars from a system design that went too far into prematurely partitioning the software, or from an over-emphasis on one aspect of software development: data engineering, or run-time efficiency, or development strategy and team organization. Often also the architecture does not address the concerns of all its “customers” (or...

Words: 6001 - Pages: 25

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

Chapter 1

...requirements are studied and structured. (2) Application Software: Computer software designed to support organizational functions or processes. (3) Computer aided software engineering (CASE) tools: systems development methodologies created to radically decrease the time needed to design and implement information systems. This methodology relies on extensive user involvement, prototyping, integrated CASE tools and code. (4) Design: the third phase of the SDLC in which the descriptions of the recommended solution in converted into logical and physical system specifications. (5) Implementation: the fourth phase of the SDLC in which the information system is coded, tested, installed, and supported in the org. (6) Information system analyses and design: the complex organizational process whereby computer-based information systems are developed and maintained. (7) Inheritance: the property that occurs when entity types or object classes are arranged in a hierarchy and each entity type or object class assumes the attributes and methods of its ancestors; that is, those higher up in the hierarchy. The property allows new but related classes to be deirved from existing classes. (8) Logical design: the part of the design phase of the SDLC in which all function features of the system chosen for development are described independently of any computer platform. (9) Maintenance: the final phase of the SDLC in which an information system is systematically repaired and improved. (10) Object:...

Words: 489 - Pages: 2

Premium Essay

Kforrestcit360Chapt1

...components- Academic colleges, departments, academic functions such as registration and advising. * Boundary- the physical boundary of the campus I think could be the logical boundary for the university. There is also technology-based distance education across the globe and off-campus facilities. * Purpose- Providing education, conducting research, and serving their communities. * Equipment- Textbooks, classes * Input- High school transcripts, applications, tuition payments, and state and federal regulations. * Output- Diplomas, transcripts, billing statements, and inventions. 2. Task #2 Case Problem a. The systems development life cycle may be used to analyze, develop, and support Hoosier Burger’s Information Systems. From the systems planning and selection process, Bob, Thelma, and the analyst recognize their business system needs improvement. In systems analysis, the analyst examines Hoosier Burger to deduce the system requirements, refine and structure these requirements and come up with alternative design strategies. Next is system design. During this process both logical and physical designs are prepared. In logical design, the analyst concentrates on the business aspects of the company. During the physical design, the logical design is translated into the physical design. Next comes systems implementation and operation. The design now becomes a working system. Modifications are consistently made when needed during this process. b. Component-...

Words: 430 - Pages: 2

Premium Essay

Productive and Counterproductive Behavior

...and apply my 21 Years of Ford experience in Vehicle Harness Design on HYBRID , ELECTRIC , GAS & DIESEL VEHICLES. Programs were Cars , SUVS , Light & Medium Duty Trucks. 16 Years of CAD Experience is with the Ford EDGS and E-CAD and CHS and Capital Harness Systems by Mentor Graphics using Translayout , Transdesign , Transharness and Transcable to create Harness Designs and Logical and Physical Schematics. Education MACOMB COMMUNITY COLLEGE - ELECTRICAL ENGINEERING PROGRAM GRADUATED WITH HONORS. RECEIVED AN ASSOCIATES DEGREE IN ELECTRICAL ENGINEERING TECHNOLOGY Employment UNITED TECHNOLOGIES / LEAR CORPORATION, United States of America, SOUTHFIELD, MICHIGAN|March 1987 - November 2008| SENIOR DESIGNER SENIOR DESIGNER OF ALL HARNESSES ON FORD VEHICLES AND ENGINE POWER PACKS. I WAS RESPONSIBLE FOR THE HARNESS DESIGNS FROM PROTOTYPE THRU THE PRODUCTION RELEASE. I WORKED ON THE FOLLOWING FORD PROGRAMS – TOWN CAR , CONTINENTAL , TAURUS/SABLE , ELECTRIC & GAS RANGER , HYBRID & GAS ESCAPE/MARINER/TRIBUTE , GT SPORTS CAR , EXPLORER/MOUNTAINEER/SPORT TRAK & FOCUS. MODIFIED LOGICAL SCHEMATICS AS REQUIRED FOR P-PIN ATTRIBUTES AND ADDING THE REQUIRED OPTION CODES TO THE NETS AND COMPONENTS. CREATED PHYSICAL SCHEMATICS FROM THE BUILDABLE COMBINATION WIRE FILE CREATED FROM THE LAYOUT THAT I DEVELOPED AND CLEANED UP THE PHYSICAL SCHEMATICS AS REQUIRED. MENTORED MANY DESIGNERS ON THE DESIGN TOOL SETS AND PROVIDED TRAINING AS REQUIRED. COMPLETED SEVERAL...

Words: 381 - Pages: 2

Free Essay

Midterm Solutions

...close book, closed note test – with one exception. You may use the two page “logical design” handout (i.e., the one describing the steps required to transform an ER diagram into a relational database schema). d. A Hint: Be certain to read the questions carefully and respond to all portions of the question. e. GOOD LUCK INDE499B, Midterm #1 2 QUESTION 1: THE DATA DESIGN PROCESS (25 points). Imagine that you have been assigned to a team that will be developing an inventory tracking system. As part of the project startup, your manager has asked each team leader to bring a basic work plan to the next meeting. At that meeting, these work plans will be analyzed to determine the overall project timeframe, costs, personnel requirements and software requirements. For now, as the team leader for the data design team, you have been asked to bring a work plan that identifies the phases of data design and includes the following information for each phase: a). a description of the data design phase, b). the inputs of the phase, c). the outputs of the phase, d). a key issue addressed in the phase e). a challenge that you can anticipate would occur in the phase. Please prepare the response you will bring to the meeting. Solution: a. b. Description Conceptual Design Create model that captures major entities, relationships among entities, and attributes of entities required for a particular system. Logical Design Transform the major entity/attribute /relationship...

Words: 1465 - Pages: 6

Free Essay

Fragmentation

...Submitted by: JUNAID MUZAFFAR Roll No: 13031756-016 Vertical Partitioning Algorithm for database Design Vertical Partitioning Algorithms for Database Design SHAMKANT NAVATHE, STEFANO CERI, GIO WIEDERHOLD, AND JINGLIE DOU Stanford University This paper define the vertical partitioning in which spread or break the logical relation into group of attributes according to transaction that access the attribute are group of attribute. The vertical partition is defined in three context memory level a centralized database and the most important is distributed database like placed data in different sites. In this paper we focus on distributed database. in which local transaction should be minimize. In this paper we use two phases the first approach is that we have no first knowledge and second is cost optimization. Fragmented may be no overlapping or overlapping. Summary Partitioning in database design is the process of assign object from the logical schema to the physical several objects. Vertical partition is the process of divide attribute into group (fragments) and assign to physical object. In vertical fragmentation we make maximum and all minimum possible fragments it mean that fragment may be overlap or non-overlap. So we make cluster of fragments that one overlap or no overlap but we use the both disjoint and no disjoint cases in partitioning. We use fragmentation to improve the performance of query optimization .according to distribution point...

Words: 1301 - Pages: 6

Free Essay

Cs136

...Chap 9 Review questions 1. Explain the main differences between a file processing system and a database system. A database coordinates the physical and logical access to the data; a file-processing system only coordinates physical access to the data. A DBMS reduces the amount of data duplication. A DBMS is designed to coordinate and permit multiple users to access data at the same time. A file processing system is much more restrictive in simultaneous data access. 2. What is a DBMS? Briefly describe the components of a DBMS. A database consists of linked tables that form an overall data structure. A database management system (DBMS) is a collection of tools, features, and interfaces that enable users to add, update, manage, access, and analyze data in a database. DBMS components include interfaces for users, database administrators, and related systems; a data manipulation language; a schema; and a physical data repository. 3. Describe a primary key, candidate key, secondary key, foreign key, and common field.  A primary key is a field or combination of fields that uniquely and minimally identifies a particular member of an entity. For example costumer ID can be primary key.  A candidate key like his name suggest is a key that can be use a primary key but is not use for many reasons. For example social security number can be used as primary key but usually are not use for security reasons might be navigation shortcuts or can trigger other actions. ...

Words: 940 - Pages: 4

Premium Essay

Wild Wood Apartments

...Yalamanchili, Sriram sriram.yalamanchili@snhu.edu Yalamanchili, Sriram sriram.yalamanchili@snhu.edu Milestone two Database Analysis and Design Milestone two Database Analysis and Design CONCEPTUAL MODEL: It describes the abstract form of database. It includes only the entities, attributes and relationships between them. This conceptual diagram is the basic diagram which is used to understand the design of the database. This conceptual model is the rough diagram and is not sufficient to identify the datatypes, primary keys, foreign keys, composite keys or compound keys. The entities that are mentioned in this conceptual model are apartment manager, corporate manager, business partner, maintenance, apartment complex, administrator, tenant, apartment, and database. Business rules: * Corporate managers or business managers choose the apartment managers * Apartment managers has to send the daily reports to the headquarters to manage and develop new business strategies * Quarterly generated report should consists of revenue, maintenance, occupancy rate and expenses * Managers has the ability to track tenant information * Managers are responsible for maintenance * Managers should provide lease to new tenants and get rents from existing tenants * Managers should store the tenant information, rental information and maintenance issues * Every tenant need to sign the lease by accepting the terms and conditions * Grace period...

Words: 378 - Pages: 2

Free Essay

Cis175 It Consult

...Proposal In order to design and deliver a reliable and secure network for DesignIT, many critical factors must be considered such as the network topology and architecture, the selection of hardware and software components designed to meet the client’s requirements, and also appropriate security services. DesignIT has decided to upgrade from a temporary workplace to a permanent office space. The new space measures 56’ x 36’ giving DesigntIT over 2000 square feet of dedicated space. This new space contains four cubicles, one executive office, one server room, one reception desk, and one conference room and allows DesignIT to hire two full time designers and a receptionist. As stated in the Request for Proposal (RFP) issued by DesignIT, the design must incorporate the following considerations: * Relocation of three servers configured as follows: * One (1) Web Server – Microsoft IIS Server * One (1) File Server- Microsoft Server 2008 * One (1) Server – Server 2008 Small Business Server Furthermore, DesignIT has stated the design must also include the following deliverables: * High speed internet access * Firewall * Antiviurs/Malware protection * Six (6) computers * Three (3) color laser printers * Wireless access for portable devices A critical first step in designing a network to meet DesignIT’s requirements is designating the network topology. A network topology is both the logical and physical layouts of the network...

Words: 731 - Pages: 3

Premium Essay

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

Words: 2020 - Pages: 9

Premium Essay

Programming Language Using Oojavacom 121

...Pre-Requisite: Completion of 1st Year Courses Introduction: Systems Design is a central part of systems development. It comprises the process of turning a set of user requirements into an implementable system and encompasses various activities to achieve this end. Alternative models are challenging the traditional systems development life cycle. Alongside this, two approaches to systems development are emerging: the traditional structured approach; and the object oriented approach. The systems design activity will be studied in the context of these trends. Students should make themselves familiar with at least one traditional approach (e.g. SSADM) and one object oriented approach (e.g. UML). Aims: To understand the role of systems design within various systems development life cycles To develop awareness of the different approaches that may be taken to systems design To understand and apply the tools and techniques that are currently used by systems designers Formatted: Superscript      Objectives: Describe different life cycle models and explain the contribution of systems design within them Discuss various systems development approaches and explain their strengths and weaknesses 1 30/09/1123/09/10 Evaluate the tools and techniques that may be used by a system designer in a given context Use appropriate methods to produce a system design for a given scenario     Provide suitable systems documentation for a design Discuss the CASE tools currently available Content: Week...

Words: 2312 - Pages: 10

Premium Essay

Computer Security

...Computer Security Protecting Your Computer System Do’s and Don’ts Abstract This paper explores the computer security process of preventing and detecting unauthorized use of computers. I will also discuss: A. The prevention measures (do’s and don’ts) to help you stop unauthorized users (also known as “intruders”) from accessing any part of your computer system. B. Detections methods that help you to determine whether or not someone attempted to break into your system; a. If an attack was successful b. If so, what they may have done.   Computer Security Protecting Your Computer System Do’s and Don’ts We use computers for everything from banking and investing to shopping and communicating with others through email or chat programs. Although you may not consider your communications “top secret,” you probably do not want strangers reading your email, using your computer to attack other systems, sending forged emails from your computer, or examining personal information stored on your computer (such as financial statements). Intruders (also referred to as hackers, attackers, or crackers) may not care about your identity. Often they want to gain control of your computer so they can use it to launch attacks on other computer systems. Once an intruder takes control of your computer, they have the ability to hide their true location as they launch attacks, often against high-profile computer systems such as government or financial systems. Even if you have...

Words: 1909 - Pages: 8