Premium Essay

Logical Model

In:

Submitted By venkatesh0124
Words 381
Pages 2
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 attributes for each entity. 4. Resolve many-to-many relationships. 5. Normalization.

Physical data model:
It represents how the model will be built in the database. A physical database model shows all table structures, including column name, column data type, column constraints, primary key, foreign key and relationships between tables. Features of a physical data model include: *

Similar Documents

Premium Essay

Converting a Physical Data Model to a Logical Model

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

Words: 1187 - Pages: 5

Premium Essay

Frequent Shopper Part 2

...(SSC) provides information technology (IT) services and consulting, which include developmental solutions, IT integration, strengthening, analysis, design, and implementation (Apollo Group, 2004). SSC will submit a proposal to KFF that details the development processes of the FSP project. This paper is a technical article document that lists the project’s logical and physical models, which includes hardware, network, software, database, controls, and other development related tools. Logical and Physical Models Logical and physical models are representations of the key elements and processes of a software development. The logical model describes the processes, especially data, in as much detail as possible, without giving regard to how the system will be physically implemented. Logical data models include entities and relationships among them and how data flows from one process or entity to another. The physical model, on the other hand, delineates the physical implementation of the system, which answers how the logical model will be implemented physically. The physical model is a modified version of the logical model, intended particularly to work with a specific set of...

Words: 2665 - Pages: 11

Free Essay

Hostel Management System

...Define user documentation Written or other visual information about an application system, how it works, and how to use it. (17) . User documentation refers to the documentation for a product or service provided to the end users. The user documentation is designed to assist end users to use the product or service. This is often referred to as user assistance. The user documentation is a part of the overall product delivered to the customer. The sections of a user manual often include: * A cover page * A title page and copyright page * A preface, containing details of related documents and information on how to navigate the user guide * A contents page * A guide on how to use at least the main functions of the system * A troubleshooting section detailing possible errors or problems that may occur, along with how to fix them * A FAQ (Frequently Asked Questions) * Where to find further help, and contact details * A glossary and, for larger documents, an index realized the importance of documentation many years ago when I joined an organization to head its IT function. The previous IT head had left the organization a couple of months ago. The managing director called me over and voiced his expectation. He told me that all ground work had been done for ordering new set of servers and application packages and that I should act upon it soon. I promised to take a look at the situation and revert with plans. However, when I sat in my department...

Words: 2026 - Pages: 9

Premium Essay

Com 285 Cross Cultural Communication

...article (2009). Discuss your reasons for picking the questions you use. Deadline: ( ), Computer Science - General Computer Science Group Project: MiniQuest Database Objective | Overview | Case Project Overview | Needed Reports | Sample Data | Some Known Assumptions | What Your Team will be Required to Do | Task 1 (Due at the end of Week 3) | Task 2 (Due at the end of Week 4) | Task 3 (Due at the end of Week 5) | Task 4 (Due at the end of Week 6) | Task 5 (Due at the end of Week 7) | Submission of Tasks | Team Member Responsibilities | Assessment | Grading Rubrics Objective The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of th...

Words: 368 - Pages: 2

Premium Essay

Cgd 218 Week 1 Assignment Why Is Visual Literacy Important

...when implementing an ERP system? Do you agree? Back up your opinion. Deadline: ( ), Computer Science - General Computer Science Group Project: MiniQuest Database Objective | Overview | Case Project Overview | Needed Reports | Sample Data | Some Known Assumptions | What Your Team will be Required to Do | Task 1 (Due at the end of Week 3) | Task 2 (Due at the end of Week 4) | Task 3 (Due at the end of Week 5) | Task 4 (Due at the end of Week 6) | Task 5 (Due at the end of Week 7) | Submission of Tasks | Team Member Responsibilities | Assessment | Grading Rubrics Objective The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be covered first during the week or weeks prior to a deliverable, and each task deliverable in the project will be supported through the exercises and labs done in the course. Overview...

Words: 359 - Pages: 2

Premium Essay

Cmgt 400 Week 4 Dqs

...article? Why are these areas critical to the organization? Is the author Deadline: ( ), Computer Science - General Computer Science Group Project: MiniQuest Database Objective | Overview | Case Project Overview | Needed Reports | Sample Data | Some Known Assumptions | What Your Team will be Required to Do | Task 1 (Due at the end of Week 3) | Task 2 (Due at the end of Week 4) | Task 3 (Due at the end of Week 5) | Task 4 (Due at the end of Week 6) | Task 5 (Due at the end of Week 7) | Submission of Tasks | Team Member Responsibilities | Assessment | Grading Rubrics Objective The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be covered first during the week or weeks prior to a deliverable, and each task deliverable in the project will be supported through the exercises and labs done in the course. Overview The first thing you need to do is...

Words: 359 - Pages: 2

Free Essay

Cmgt 400 Week 1 Dqs

...several examples of what management could do to protect each example. Deadline: ( ), Computer Science - General Computer Science Group Project: MiniQuest Database Objective | Overview | Case Project Overview | Needed Reports | Sample Data | Some Known Assumptions | What Your Team will be Required to Do | Task 1 (Due at the end of Week 3) | Task 2 (Due at the end of Week 4) | Task 3 (Due at the end of Week 5) | Task 4 (Due at the end of Week 6) | Task 5 (Due at the end of Week 7) | Submission of Tasks | Team Member Responsibilities | Assessment | Grading Rubrics Objective The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be...

Words: 360 - Pages: 2

Free Essay

Critically Assess the Claim That Religious Language Is Meaningless?

...Critically assess the claim that religious language is meaningless? Many philosophers have argued as to whether or not the ways in which we speak about religion are relevant or meaningful. This issue of religious language looks at the way we talk about God, debate ideas and communicate our theist or atheist ideologies. For some, religious language is meaningful and full of purpose while others see it to being incomprehensible and pointless. The verification principle a theory proposed by A.J. Ayer is a key argument, which addresses whether religious language is meaningful or not. Ayer was one of the logical positivists, a Viennese group of philosophers who were inspired by the theories of the early Wittgenstein and he sought to answer what makes a statement ‘meaningful’ as opposed to what makes it ‘true’. Ayer begins his thesis with the claim that language is only meaningful if it can be verified by a sense-observation. If you cannot demonstrate with sense-observations how a statement is true, then the statement is factually meaningless. A ‘putative proposition’ is the name Ayer gives to statements yet to be verified. A putative statement is either verifiable practically or in principle. For instance, a statement such as “that is a red car” is verifiable in practice by looking at the car. However, a statement such as “There is life in another universe” is verifiable in principle but not in practice, as we possess insufficient technology. Therefore Ayer then makes distinctions...

Words: 1356 - Pages: 6

Premium Essay

R Tutorial

...R for Beginners Emmanuel Paradis ´ Institut des Sciences de l’Evolution Universit´ Montpellier II e F-34095 Montpellier c´dex 05 e France E-mail: paradis@isem.univ-montp2.fr ´ I thank Julien Claude, Christophe Declercq, Elodie Gazave, Friedrich Leisch, Louis Luangkesron, Fran¸ois Pinard, and Mathieu Ros for their comments and c suggestions on earlier versions of this document. I am also grateful to all the members of the R Development Core Team for their considerable efforts in developing R and animating the discussion list ‘rhelp’. Thanks also to the R users whose questions or comments helped me to write “R for Beginners”. Special thanks to Jorge Ahumada for the Spanish translation. c 2002, 2005, Emmanuel Paradis (12th September 2005) Permission is granted to make and distribute copies, either in part or in full and in any language, of this document on any support provided the above copyright notice is included in all copies. Permission is granted to translate this document, either in part or in full, in any language provided the above copyright notice is included. Contents 1 Preamble 2 A few concepts before starting 2.1 How R works . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2.2 Creating, listing and deleting the objects in memory . . . . . . 2.3 The on-line help . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Data with R 3.1 Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.2 Reading data in a file . . . . . . . . . . ....

Words: 12833 - Pages: 52

Free Essay

Epistobabble Warfare

...INTRODUCTION The article “Marketing: philosophy of science and “epistobabble warfare” is a commentary by the author Michel Rod published as a qualitative research in an International Journal, Vol. 12 Iss. 2, pp. 120- 129. Throughout the article Rod articulated his viewpoints on the variety of philosophies involved in legitimizing the science of marketing research and sought to establish his own perspective of what he actually believes marketing research should accomplish. This was stated in his thesis statement that: “Rather than argue one particular perspective, it is this paper’s central thesis that no one philosophical perspective does or should have a monopoly on what makes a useful contribution to our understanding of marketing phenomena. “ Consequently, what Rod proposes is that rather than trying to establish an allegiance to any one particular philosophy one should be free to research, understand and articulate all the questions and results that can ‘contribute meaningful information to the study of marketing phenomena’. In other words, whilst Rod understands that a philosophy might be needed to establish foundations of ontology and epistemology to determine the methodology (POEM): - * Type of questions or problem one attempts to answer in their research * The manner in which these questions should be posed…. * The best methodological approach to shed some light on the particular question(s) being posed or the phenomenon of interest being investigated...

Words: 1353 - Pages: 6

Free Essay

Blah Blah

...15.2.2016 Reduction SAT Problem Group 1 1 Reduction 2 Reduction an important concept for understanding the relationship between problems. 3 solving one problem in terms of another 
 
 Example :
 Suppose you have some problem A that you don’t know how to solve. 
 If you can find a way to reduce problem A to some problem B that you do know how to solve, then that’s just as good as finding a way to solve A in the first place. 4 SORTING:
 Input: A sequence of integers x0, x1, x2, ..., xn−1.
 Output: A permutation y0, y1, y2, ..., yn−1 of the sequence such that yi ≤ yj whenever i < j. PAIRING:
 Input: Two sequences of integers X = (x0, x1, ..., xn−1) and Y = (y0, y1, ..., yn−1).
 Output: A pairing of the elements in the two sequences such that the least value in X is paired with the least value in Y, the next least value in X is paired with the next least value in Y, and so on. 5 An illustration of PAIRING. The two lists of numbers are paired up so that the least values from each list make a pair, the next smallest values from each list make a pair, and so on. 6 Solution PAIRING is to use an existing sorting program to sort each of the two sequences, and then pair off items based on their position in sorted order. PAIRING is reduced to SORTING, because SORTING is used to solve PAIRING. 7 3-step Process 1. convert an instance of PAIRING into two instances of SORTING . 2. sort the two arrays . 3. convert...

Words: 790 - Pages: 4

Free Essay

Postivism

...Chapter 8 Logical Positivism I want neither that plutocracy grasping and mean, nor that democracy goody and mediocre, occupied solely in turning the other cheek, where would dwell sages without curiosity, who, shunning excess, would not die of disease, but would surely die of ennui. — Poincar´ (quoted in Runes, ToP, p. 966) e Science itself, therefore, may be regarded as a minimal problem, consisting of the completest possible presentment of facts with the least possible expenditure of thought. — Mach (Newman, WM, Vol. 3, p. 1792) 8.1 Historical Background In this chapter we will look at logical positivism, the most influential phi- Logical Analysis losophy of science in the twentieth century. In spite of the fact that logical positivism has been abandoned by most philosophers of science, its influence continues in many disciplines, including physics, linguistics and psychology. We will be especially concerned with logical positivism’s view of knowledge, which is, roughly: (1) the only real knowledge is scientific knowledge; (2) by a process of logical analysis scientific knowledge can be reduced to symbolic formulas constructed from “atomic facts.” Certainly assertion (1) is nothing new; Socrates said as much when he distinguished “scientific knowledge” 303 304 Empiricism Anglo-American Roots Continental Roots Auguste Comte: 1798–1857 CHAPTER 8. LOGICAL POSITIVISM (episteme) from a “practice” (empeiria); see Section 2.4.3. Furthermore...

Words: 10216 - Pages: 41

Free Essay

Aasdfa

...FULLCHIPDESIGN Digital-logic Design... Dream for many students… start learning front-end… Chip Designing for ASIC/ FPGA Design engineers and Students Legal Disclaimer @TYH :- 4G LTE Long Term Evolution Tutorial, CloudComputing Send 124 people recommend this. Recommend Computer Organization. Memory Organization. Cache Organization. Interrupt controller. Search Binary subtraction Discussion proof of binary subt Search Binary numbers addition is straight forward process while binary subtractions involve three fundamentals. VHDL Test Benches Generate VHDL models from timing diagrams or logic analyzer data. www.syncad.com Binary Numbers 1s_complement 2s_complement Binary Subtraction Binary Sub. Ex's Sign_magnitude SignM EX Gray Coding BCD coding Digital gates NAND NOR & XNOR Theorems Boolean Functions BFunc Examples Minterm Maxterm Sum of Minterms Prdt of Maxterms 2 var K-map 3 var K-map 4 var K-map 5 var K-map Prime Implicant PI example K-map Ex's KMap minimization Binary Subtraction: Suppose, M is Minuend and N is subtrahend Then, M – N can be done based on following three steps: Step 1: Take 2’s complement of N and add it to M. M – N = M + (2^n – N) Step 2: If M is greater than or equal to N then end carry is discarded from the result M –N = M + (2^n – N) – 2^n Step 3: If M is less than N then take 2’s complement of the result and append negative ‘-‘ sign in front M-N = (-) [2^n – (M + (2^n -1))] Example 1 : Perform binary subtraction of two...

Words: 667 - Pages: 3

Premium Essay

Logical Fallacies

...Logical Fallacies Fallacies are all around us. We see fallacies on the television, newspapers, and radio. People around the world experience logical fallacies on almost a daily basis. A fallacy is defined as “errors or flaws in reasoning” (Axelrod and Cooper 620).Fallacies used in advertisements are; band wagon, begging the question, confusing chronology with casualty, either-or reasoning, equivocating, failing to accept the burden of proof, false analogy, hasty generalization, overreliance on authority, oversimplifying, personal attack, red herring, slanting, slippery slope, sob story, straw man. I have gathered four advertisements that have fallacies. The fallacies are slippery slope, overreliance on authority, and hasty generalization. My first finding is an advertisement with the fallacy slippery slope. The advertiser tells people “Use this 3D White collection together and get a noticeably whiter smile in just two days”. Slippery slope is defined as pretending that one thing inevitable leads to another (Axelrod and Cooper 621). The advertisement has the celebrity Shakira smiling with beautiful white teeth. It has three Crest 3D White products a toothbrush, mouthwash, and toothpaste. Advertiser say’s “Reveal your inner rock star with a 3D White smile”. Also, it claims that “life opens up with a whiter smile”. This advertisement is pretending that life will be better if people use its products. It will also supposedly make your teeth glamorous white. The toothbrush...

Words: 872 - Pages: 4

Premium Essay

Secret

...Claveria, Steven M. BSIT - II 1. What is Database Normalization? Database normalization is the process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy. Normalization involves decomposing a table into less redundant (and smaller) tables without losing information; defining foreign keys in the old table referencing the primary keysof the new ones. The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database using the defined foreign keys. The relational model separates the logical design from the physical design: DBMS performance is a matter of physical designer using indexes, view materialization, big buffers, etc. It is not a matter of changing the logical design. A typical example of normalization is that an entity's unique ID is stored everywhere in the system but its name is held in only one table. The name can be updated more easily in one row of one table. A typical update in such an example would be the RIM company changing its name to BlackBerry. That update would be done in one place and immediately the correct "BlackBerry" name would be displayed throughout the system. Example Querying and manipulating the data within a data structure that is not normalized, such as the following non-1NF representation of customers' credit card transactions, involves more complexity than is really...

Words: 527 - Pages: 3