Premium Essay

Converting a Physical Data Model to a Logical Model

In: Computers and Technology

Submitted By omarshabbir47
Words 1187
Pages 5
Table of Contents Setting up the subject area (if required) 2 Bringing in the tables 4 Assigning appropriate Domains 5 The logical Model 6 Identifying a many to many relationship 7 Replacing a mapping table 7 Renaming Logical Model 15 Entity Names 15 Relationship Names 16 Attribute Names 16 Revisiting Physical Model 19 Relationship Naming 20 FINAL PRODUCT 21 Logical VS Physical 21

Setting up the subject area (if required) 1. Open the target and source Erwin models in the same instance of Erwin. 2. If required create a new subject area in the target model where the tables are going to be copied.

Figure 1 – Creating a new subject area

3. Change the default theme to ‘Classic Theme’ (right click on the diagram page and click properties ER Diagram Editor will open up. Change the Theme on the ‘General’ tab)

Figure 2 – Selecting a Theme
Bringing in the tables 1. Select the tables and relationships (if applicable) from the source model file and paste them in the target model while both models are in Physical mode.

Figure 3 – Importing/copying the tables 2. Verify that all the tables you need are copied in the Erwin target model. 3. You can close the source model at this stage (recommended)

Assigning appropriate Domains 1. Right click on the table and select ‘column properties’. 2. Assign the correct domain parent to all the columns.

Figure 4 Assigning Domains to the columns 3. Once you have assigned the correct domain parent to all the columns close the dialogue box. 4. Repeat the process for each table you have brought in to the target data model.

The logical Model 1. Switch to the ‘logical’ version of the subject area in the target model. 2. Right click on an entity that is NOT a ref table and select entity properties. 3. Go to the style tab and change the theme to an…...

Similar Documents

Premium Essay

Osi Model Organization for Standardization (ISO) as a Model for a computer protocol architecture and as a framework for developing protocol standards. The OSI model consists of seven Layers: Application, Presentation, Session, Transport, Network, Data Link, and Physical.” (University of Phoenix) The Application layer supports application and end user processes, also it provides application services for file transfer, e-mail, and other network software service. Telnet and FTP are applications that exist completely in the application level. The Presentation layer provides self-rule from differences in data representation by translating from application to network format and vice versa. This layer works to convert data into the form that the application layer can accept. It formats and encrypts data to be sent across a network, providing lack of restrictions from compatibility problem. The Session layer launch manages and come to an end connection between applications. This layer sets up, brings together, and terminates conversations, exchanges, and dialogues between the applications at each end. The Transport layer provides crystal clear transfer of data between end systems, or hosts, and is responsible for end to end error recovery and flow control. This layer guarantee complete data transfer. The Network layer offers switching and routing technologies, creating logical paths, known as virtual circuits, for transmitting data from node to node. The routing and......

Words: 483 - Pages: 2

Free Essay


...MODEL DE PLÂNGERE Către, AUTORITATEA NAŢIONALĂ DE SUPRAVEGHERE A PRELUCRĂRII DATELOR CU CARACTER PERSONAL Str. Olari, nr. 32, sector 2, Bucureşti Subsemnatul/a (numele şi prenumele) domiciliul/reşedinţa în.................................. str. ......................... nr. ..... bl. ..... sc. .... ap. ....., judeţul/ sectorul....................... CNP........................... telefon ........................., adresa de e-mail (opţional),................................., în temeiul art. 25 din Legea nr. 677/2001 pentru protecţia persoanelor cu privire la prelucrarea datelor cu caracter personal şi libera circulaţie a acestor date, vă aduc la cunoştinţă următoarele: (numele/denumirea operatorului),............................................... cu domiciliul/sediul în......................................a prelucrat ilegal datele mele personale (se enumeră datele respective),................................... în următoarele împrejurări:.................................... (se descrie situaţia considerată de petent ca fiind o încălcare a Legii nr. 677/2001). Declar pe proprie răspundere că obiectul prezentei plângeri nu face obiectul unei acţiuni în justiţie. Precizez că m-am adresat în prealabil operatorului cu scrisoarea din data de ........................ *, însă nu am primit un răspuns/răspunsul primit nu îl consider satisfăcător din următoarele motive:......................(se alege...

Words: 308 - Pages: 2

Free Essay

A Model

...A model is a simplified representation of some aspect of the world. In what ways may models help or hinder the research for knowledge? A model by definition is “a schematic description of a system, theory, or phenomenon that accounts for its known or inferred properties and may be used for further study of its characteristics”[1] that implies that a model is supposed to be a helping hand while searching for knowledge in any subject. Sometimes however models can appear to be quite confusing as they are to general or too far away from real life situations. So how and in what way models can help and hinder the search for knowledge in natural sciences, human sciences and arts I am going to argue in the following essay. In school we learn all our subjects with the help of models and especially in natural sciences we need them in order to assume what might happen if, say in biology, in a cell there is a lack of oxygen and we know and can explain with a model of a cell and of the respiratory cycle how anaerobic respiration works and what it does and needs. With the help of the model and through logical connecting of facts that the student might already have, he can develop the thought in his or her mind and therefore gain new knowledge about a theoretical process that was proven to take place in the human body. Another model, which however is not as accurate also in Biology is the Sigmoid Population growth curve. It displays the population growth of a species over a period of......

Words: 1415 - Pages: 6

Free Essay

Osi Model Protocol

...OSI Model Protocol Keisha Bullock NTC 361 December 9, 2013 University of Phoenix (Axia) Bruce Yamashita OSI Model Protocol Open System Interconnection (OSI) is a recommended suggestion for how messages should be transferred between any two users in a telecommunication network. The purpose of the OSI is to direct product implementers so that their items will regularly work with other items. The OSI model outlines seven layers of function that happens at each end of a message. The main purpose of the Open System Interconnection is that the communication procedure between two end points in telecommunication networks can be split up into different levels with each level having its own set of responsibilities ("OSI (open System Interconnection)", 2000-2013). The OSI slits the telecommunication into seven levels which is the application level, the presentation level, the session level, the transport level, the network level, the data link level, and the physical level ("OSI (open System Interconnection)", 2000-2013). The layers are broken up into two sets. The higher four levels are used when a message is transmitted from user to another user. The bottom three levels are exercised when any message passes through the main computer. Messages planned for this computer go through to the higher levels and messages intended for some other computer are not distributed up to the levels but are advanced to other host. The application level offers multiple services to......

Words: 973 - Pages: 4

Free Essay


...The specification says ‘explanations’, which means you’ll need to know at least two explanations. 1. The importation model – this explains aggression in prisons. In brief, it says aggression occurs because of characteristics that prisoners bring inside with them. Cheeseman (2003) said that men in prison have a certain way of behaving (probably why they went to prison in the first place!) and they then apply that behaviour to their new institutional setting. Toch (1997) says this: all prisons inherit their subcultural sediments from the street corners that supply them with clients. This suggests that young people can be aggressive both on the street and in prison. Personal and psychological factors that existed in inmates before being incarcerated can affect the level of aggressive behaviour shown in prison. Mills, Kroner and Weekes (1998) studied prisoners admitted to a Canadian prison using the alcohol dependence scale (ADS). Inmates who had higher levels of dependence were associated with more aggression shown in prison. Also, inmates who had greater periods of unemployment, lower levels of education, and a more serious criminal record were more likely to be aggressive in prison (Kane and Janus, 1981). Demographic variables that seem to influence aggression in prisons are race and age. Studies in America have shown that non-whites and younger prisoners are more likely to be aggressive whilst incarcerated. Kane and Janus (1981) say that this is because these......

Words: 1032 - Pages: 5

Free Essay

Osi Model

...OSI MODEL Joseph Lucero College America Abstract In this paper it is going to explain the OSI model and all the layers. There are 7 layers in total: the layers are Application, Presentation, Session, Transport, Network, Data Link and Physical. It is going to explain what all the layers are and how they work in the OSI Model, it is also going to explain what every layer is. It is also going to explain why it was created and what the use for the OSI model is for today. You are going to know why we need the OSI model and how it evolved from the first time. You are also going to find out about the past history about the model and the other name is what called before. OSI Model The OSI model has been used for a long time. Why do we use it? OSI, formally known as the ISO OSI model, is the most standard model for networking communication. The ISO formed the OSI or Open System Interconnection, so that you can communicate and connect with another system over the network without having system specific configuration. The OSI model consists of 7 different layers: Physical, Data Link, Network, Transport, Sessions, Presentation, and Application. One reason why the OSI model was created, is so that the process of communication that were between two end points in a telecommunication network can be split into layers. The main reason why the OSI Model was created was to standardize the networking rules so that all the systems can communicate over the OSI reference model, which was a...

Words: 954 - Pages: 4

Premium Essay

Data Model Tutorial

...introduction to data modeling 3.1 Introduction: The importance of conceptual models same: understand the problem before you start constructing a solution. There are two important things to keep in mind when learning about and doing data modeling: 1. Data modeling is first and foremost a tool for communication.Their is no single “right” model. Instead, a valuable model highlights tricky issues, allows users, designers, and implementors to discuss the issues using the same vocabulary, and leads to better design decisions. 2. The modeling process is inherently iterative: you create a model, check its assumptions with users, make the necessary changes, and repeat the cycle until you are sure you understand the critical issues. In this background lesson, you are going to use a data modeling technique—specifically, EntityRelationship Diagrams (ERDs)—to model the business scenario from Lesson 2. The data model you create in this lesson will form the foundation of the database that you use throughout the remaining lessons. Before you sit down in front of the keyboard and start creating a database application, it is critical that you take a step back and consider your business problem—in this case, the kitchen supply scenario presented in Lesson 2— from a conceptual point of view. To facilitate this process, a number of conceptual modeling techniques have been developed by computer scientists, psychologists, and consultants. ? For our purposes, we can think of a conceptual......

Words: 7007 - Pages: 29

Premium Essay

Osi Model

...The OSI Model The OSI Model The OSI model describes how data flows in a network. From the top, highest level containing applications for the everyday user down to the bottom level of the physical connections, data and information passes through every layer which in turn can talk to the layers above and below it. Every layer is made up of complicated software. When that software and its components receive information, commonly called packets, from another source it checks it and then sends it back through if necessary (Breithaupt & Merkow, 2006, Chapter 12). The OSI Model is comprised of seven layers, each distinctly different but yet each function and communicate with the others. Application layer The application layer is the one most computer users are the most familiar with, whether it is known to them or not. This is where user forward software operates, such as e-mail and the beloved World Wide Web. The application layer handles resources, files, and verifications necessary for these things to operate. Presentation layer The presentation layer is aptly named. Its main function is to present decrypted or encrypted data to the application layer. Examples of this process include viewing video streams or listening to music online. Session layer The session layer creates a session, or connection between processes running between two separate workstations or platforms. A session includes creating the connection between the systems and eventually......

Words: 564 - Pages: 3

Premium Essay

Logical Model

...Entity | Attribute | Data type | Time | DateDate descriptionMonthMonth descriptionYearWeekWeek description | DATE_ID: INTEGERDATE_DESC: VARCHAR(30)MONTH_ID: IINTEGERMONTH_DESC: VARCHAR(30)YEAR: INTEGERWEEK_ID: INTEGERWEEK_DESC: VARCHAR(30) | Product | Product IDProduction DescriptionCategoryCategory descriptionUnit priceCreated | PRODUCT_ID: INTEGERPROD_DESC: VARCHAR(50)CATEGORY_ID: INTEGERCATEGORY_DESC: VARCHAR(50)UNIT_PRICE: FLOATCREATED: DATE | Sales | Store IDProduct IDDateItems soldSales amount | STORE_ID: INTEGERPRODUCT_ID: INTEGERDATE_ID: INTEGERITEMS_SOLD: INTEGERSALES_AMOUNT: FLOAT | Store | Store IDStore DescriptionRegionRegion namecreated | STORE_ID: INTEGERSTORE_DESC: VARCHAR(50)REGION_ID: INTEGERREGION_NAME: VARCHAR(50)CREATED: DATE | Logical/Physical data model: Logical data model: A logical data model describes the data in as much detail as possible, without regard to how they will be physical implemented in the database. Features of a logical data model include: * Includes all entities and relationships among them. * All attributes for each entity are specified. * The primary key for each entity is specified. * Foreign keys (keys identifying the relationship between different entities) are specified. * Normalization occurs at this level. The steps for designing the logical data model are as follows: 1. Specify primary keys for all entities. 2. Find the relationships between different entities. 3. Find all......

Words: 381 - Pages: 2

Free Essay

Data Model

...  Chapter 2 Data Models Chapter 2Data Models Answers to Review Questions 1. Discuss the importance of data modelling. A data model is a relatively simple representation, usually graphical, of a more complex real world object event. The data model’s main function is to help us understand the complexities of the real-world environment. The database designer uses data models to facilitate the interaction amongdesigners, application programmers, and end users. In short, a good data model is a communicationsdevice that helps eliminate (or at least substantially reduce) discrepancies between the databasedesign’s components and the real world data environment. The development of data models, bolstered by powerful database design tools, has made it possible to substantially diminish thedatabase design error potential. (Review Section 2.1 in detail.) 2. What is a business rule, and what is its purpose in data modelling? A business rule is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization’s environment. In a sense, business rules are misnamed: they apply to any organization -- a business, a government unit, a religious group, or a research laboratory; large or small -- that stores and uses data to generate information. Business rules are derived from a description of operations. As its name implies, a description of operations is a detailed narrative that describes the operational environment of an organization.......

Words: 648 - Pages: 3

Free Essay

Osi Model

...OSI Model Application – Used by network applications Provides services to programs that want to use the network Example protocols are: HTTP, FTP, SMTP, DHCP, Telnet, SNMP, POP3 User authentication End user interface, display of data and images Resource sharing and device redirection Presentation – Syntax and semantics of the data Data formatting differences: CR-CR/LF, bit order, integer-floating point Data compression Encryption File formatting standards Character code translation, converted to bit format Session - Establishes communication session Manages session Synchronizes session Dialog control – half duplex/full duplex Terminates the connection Examples: NetBIOS, and PAP Transport – End-end data transfer Message acknowledgement Session mutiplexing Error checking Error handling Segmentation or packetizing De-segmentation, reconstructs packetized data Tracking conversations Congestion/Flow control TCP vs UDP selection Network – Routs packets across the network Subnet traffic control Frame fragmentation Logical-physical address mapping (ARP) Priority of service Creates virtual circuits Packet sequencing Subnet usage accounting Data Link - Connection across a single network Link establishment and termination Frame traffic control Frame sequencing Frame acknowledgement Frame delimiting Frame error checking Media access management Quality of service parameters such...

Words: 250 - Pages: 1

Premium Essay

A Dramaturgical Model of the Production of Performance Data

...DRAMATURGICAL MODEL OF THE PRODUCTION OF PERFORMANCE DATA System informasi mengandung berbagai macam informasi yang sangat berguna dalam menjalankan suatu bisnis, baik untuk mengetahui suatu keadaan atau dalam hal pengambilan keputusan. Berdasarkan artikel ini, penelitian menunjukkan bahwa para pemimpin menggunakan system informasi untuk mengetahui keadaan pasar dan menentukan strategi pasar yang sebaiknya digunakan. Artikel juga menyebutkan bahwa manajer menggunakan system informasi untuk menyediakan laporan secara rinci mengenai kinerja karyawan kepada para pemimpin, selain itu para pemimpin juga menggunakannya untuk mengetahui keadaan perusahaan melalui laporan akuntansi dan juga untuk melihat kinerja para manajer yang berpotensi kelak. Jadi dengan kata lain, para manajer berkeinginan untuk memperlihatkan yang terbaik yang mereka mampu kepada para pemimpin tetapi para manajer harus membuktikan kembali bahwa mereka berpotensi namun keadaan ini membuat kekhawatiran di antara para manajer. Inilah yang kemudian disebut sebagai model dramaturgi dari produksi data kinerja yang nantinya para manajer gunakan untuk mengesankan para pemimpin terhadap kinerja manajer. Dari artikel ini dapat disimpulkan bahwa system informasi digunakan oleh para pemimpin untuk mengetahui keadaan perusahaan dan untuk memberikan penilaian terhadap kinerja karyawannya, termasuk pada manajer. Sedangkan di lain sisi, para manajer menggunakan system informasi untuk memanipulasi......

Words: 353 - Pages: 2

Premium Essay

Osi Model and Tcp/Ip Model

...The following table compares the functions performed at each OSI model layer. Layer | Description and Keywords | Application (Layer 7) | The Application layer integrates network functionality into the host operating system, and enables network services. The Application layer does not include specific applications that provide services, but rather provides the capability for services to operate on the network.Most Application layer protocols operate at multiple layers down to the Session and even Transport layers. However, they are classified as Application layer protocols because they start at the Application layer (the Application layer is the highest layer where they operate). Services typically associated with the Application layer include: * HTTP * Telnet * FTP * TFTP * SNMP | Presentation (Layer 6) | The Presentation layer formats or "presents" data into a compatible form for receipt by the Application layer or the destination system. Specifically, the Presentation layer ensures: * Formatting and translation of data between systems. * Negotiation of data transfer syntax between systems, through converting character sets to the correct format. * Encapsulation of data into message envelopes by encryption and compression. * Restoration of data by decryption and decompression. | Session (Layer 5) | The Session layer's primary function is managing the sessions in which data is transferred. Functions at this layer include: * Management of multiple......

Words: 836 - Pages: 4

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

Words: 845 - Pages: 4

Premium Essay

Data Lifecycle Models and Concepts V8.Docx

...Version 7.0 August 10, 2011 INTRODUCTION This is a compilation of data lifecycle models and concepts assembled in part to fulfill Committee on Earth Observation Satellites (CEOS) Working Group on Information Systems and Services (WGISS) and the U.S. Geological Survey (USGS) Community for Data Integration Data Management Best Practices needs. It is intended to be a living document, which will evolve as new information is discovered. CONTENTS 1. Digital Curation Centre (DCC) Lifecycle Model 2. Ellyn Montgomery, USGS, Data Lifecycle Diagram 3. FGDC Stages of the Geospatial Data Lifecycle pursuant to OMB Circular A–16 4. University of Oxford Research Data Management Chart 5. NOAA Environmental Data Life Cycle Functions 6. Open Archival Information System (OAIS) Framework 7. USGS Scientific Information Management Workshop Vocabulary 8. Peter Fox Lifecycle Diagrams 9. National Science Foundation 10. NDIIPP Preserving Our Digital Heritage 11. What Researchers Want 12. EPA Project Life Cycle 13. IWGDD’s Digital Data Life Cycle Model 14. Scientific Data Management Plan Guidance 15. Linear Data Life Cycle 16. Generic Science Data Lifecycle 17. Cassandra Ladino Hybrid Data Lifecycle Model 18. Ray Obuch Data Management – A Lifecycle Approach 19. USGS Data Management Plan Framework (DMPf) – Smith, Tessler, and McHale 20. BLM Data Management Handbook 21. ARL Joint Task Force on Library......

Words: 6051 - Pages: 25