Assignment 2: Logical Design Part 1 Essay

Submitted By bwallace12
Words: 722
Pages: 3
Open Document
Assignment 2: Logical Design Part 1

Strayer University
Professor Mark Cohen
CIS-111
January 20 2013

Benefits of Relational Model
A relational model helps to organize data in the form of tables. A relational model is composed of three main components
a. A set of domains and sets which represents data structure.
b. Integrity rules which ensures data protection
c. Operations that will be carried on data i.e. process of data manipulation
For Acme Global Consulting, relational model is a term of great benefits. The company deals in providing software development solutions. The company needs to have a deep understanding functional and data needs of the company. The relational model will provide following advantages to the company
Conceptual simplicity: The model is very simple and helps to simplify data needs of their clients.
Design implementation: The model will help the company to achieve structural and data independence i.e. any changes if made to structure of data will not affect accessibility of data.
Ad hoc capability of query implementation: Relational model provides a very easy and flexible way of data implementation and manipulation.
Purpose of ER model
The purpose of using an E-R model is to create an accurate picture of the real world in a database. Acme Global Consulting, with the help of relational model, can present a powerful database design with information on its clients. The relational model will provide consultants a simple and flexible design making data retrieval, summarization and reporting more efficient. The ER model can also help to verify the data requirements before proceeding towards actual implementation.

This will also increase understanding with existing problems. The ER model will help to provide a visual representation of data for Acme Global Consulting needs. The team of Acme Global Consulting will be able to clearly understand data requirements of the clients and also can easily interacted and discussed with them through visual representations so that data requirements can be verified before taking further steps.
Essential components of an ER Model
E- R Model is an abbreviation for entity relationship model. ER model is a high level data modeling technique which lay down a conceptual design for database. ER models are comprised of a number of components such as entities, attributes; and relationships.
Entity: An entity is a name given to real world concept or item which have physical existence. An example of entity is a student for student management solution.
Attributes: The properties related to a particular entity are known as attributes. Name and address are attributes for an entity student.
Relationship: The term defines how two or more entities are related to each other. There are different types of relationships that exist in ER model.
Keys: There are number of constraints which are employed on data for maintaining integrity and preserving data.
Enhanced ER model
Enhanced ER model is enhancement of the basic ER model which contains classes, data types, generalization, and specialization concepts which are
Show More

Related Documents: Assignment 2: Logical Design Part 1 Essay

Essay on ECE 3561 Lecture 12 VHDL Overview

L9 – VHDL Overview VHDL Overview  Rules for State Assignment Application of rule Gate Implementation  Ref: text Unit 15.8   9/2/2012 – ECE 3561 Lect 9 Copyright 2012 - Joanne DeGroat, ECE, OSU 2 Overview  HDL – Hardware Description Language     A language that allows description of hardware for documentation, simulation, synthesis, verification, … To use an HDL you need a CAD system that supports it. Major CAD systems support VHDL, Verilog, System C, System Verilog CAD systems…

Words 1918 - Pages 8

Unit 1 Essay example

Modern Systems Analysis and Design Unit 0 Course Information Agenda  Information about me and the course         About me Syllabus Others Lab Teams and Class Registration List Important Dates Chapter 1 Lab/Assignment Work To-Do Your Instructor- Leon Pan  More than 8 years university teaching in programming and software development  3 year at UFV 4 years at PUC  1 year at UoR and First Nation University  12 years senior programmer  Experienced with helping students   Education…

Words 2147 - Pages 9

Verilog HDL: A Guide To Digital Design And Synthesis

Verilog HDL: A Guide to Digital Design and Synthesis, Second Edition By Samir Palnitkar Publisher: Prentice Hall PTR Pub Date: February 21, 2003 ISBN: 0-13-044911-3 Pages: 496 Written for both experienced and new users, this book gives you broad coverage of Verilog HDL. The book stresses the practical design and verification perspective ofVerilog rather than emphasizing only the language aspects. The informationpresented is fully compliant with the IEEE 1364-2001 Verilog HDL standard. • • • •…

Words 32844 - Pages 132

Des113 Wk1 Assess BasicTypesetting Exercise Essay examples

format] page. Create a text box at a 1.5-inch margin from the top, a 1-inch margins on each side and a 2.5-inch margin on the bottom. Vertically align display type to the center of the text box. Typeset your name in an 8-point sans serif in the bottom left-hand part of each page, 2 inches from the bottom and aligned flush left to the text box above. Your assignment is to typeset 5 pages of text to the following specifications: Page 1 Text: Truth Specs: 225/225 Times New Roman Regular. Flush left. Look…

Words 613 - Pages 3

Assignment 2: Network Topology Design Essay

Assignment 2: Network Topology Design You are the network manager of a company that has grown from 10 employees to 100 employees in 12 months. Year 2 projected growth is estimated to be 100 additional employees located at a remote location. The aggressive growth has brought about some unique challenges and opportunities. The company has one remote warehouse and no off-site disaster recovery services or servers. The network design remains a non-redundant, flat topology. Your assignment must consider…

Words 969 - Pages 4

Essay on BSA385 Syllabus

SYLLABUS BSA/385 Introduction to Software Engineering Copyright ©2015 by University of Phoenix. All rights reserved. Course Description This course introduces the fundamental, logical, and design considerations addressed during system and application software development. It provides a background in applications software development and testing techniques through a combination of theory and application. Course Dates Feb 27, 2015 - Apr 02, 2015 Faculty Information Name : Email Address : Phone Number…

Words 2781 - Pages 12

HCA4003 Care across Life Stages Essay

MODULE GUIDE 2014/2015 Trimester 2 Health and Social Care Department Contents 1. Overview 2 2. Learning and Teaching Strategy 2 3. Module Communications 2 4. Module Description 2 5. Expected Learning Outcomes and Assessment 3 6. Assessment Deadlines 3 7. Module Calendar 4 8. Formative Assessment 5 9. Indicative Reading 5 10. Guidelines for the Preparation and Submission of Assignments 6 11. Procedures for Examinations…

Words 3306 - Pages 14

Logical Design Part 1

this assignment, I will write a two to three page paper titled “Logical Design, Part 1” whereas I am a recently hired consultant for ACME Global Consulting to procure requirements for a large database. In this scenario, “Logical Design, Part 1”, I will develop a database management systems to convince a set of clients of the benefits of using the Entity–Relationship model (E-R) in developing a database. In addition, my management would like the following points addressed in my design: (1). List…

Words 1449 - Pages 6

NT2580 Graded Assignments Essay

Graded Assignments STUDENT COPY The following sections contain student copies of the assignments. These must be distributed to students prior to the due dates for the assignments. Online students will have access to these documents in PDF format, which will be available for downloading at any time during the course. Graded Assignment Requirements Assignment Requirements documents provided below must be printed and distributed to students for guidance on completing the assignments and submitting…

Words 5302 - Pages 22

MK389 Assignment 2015 Upd Essay

Distributed on: Week 1 Hand in Date: TBC Instructions on Assessment: The assessment is in two parts: Group seminar presentations contribute to 30% of the overall mark The individual assignment contributes to 70% of the overall mark Seminar activities (30%) Students will work in small groups within their seminar and make two assessed presentations on their chosen global brand. Further information on the seminar activities is detailed separately. Final Individual assignment (70%) The individual…

Words 2631 - Pages 11