Logical Design Part 1

Words: 1449
Pages: 6
Open Document
In 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 the advantages of a relational model specific to ACME Global Consulting. (2). Summarize the purpose of an Entity–Relationship Model (E-R) specific to ACME Global Consulting. (3). List and describe essential components of the model such as …show more content…
It is even visible in day-to-day life.
Now that we have established that relational modeling is the most widely used, I will discuss the Entity-Relationship relational model. The benefit of the E-R model to Acme Global Consulting is that it can present a powerful database design for clients. Relational model will provide consultants the ability to implement a simple and flexible design and helps to verify the data requirements before proceeding towards actual implementation. This will also increase understanding with existing problems. E-R model is a high-level data modeling technique, which lay down a conceptual design for database. E-R model is comprised of a number of components such as entities, attributes, relationships, etc. For Acme Global Consulting, E-R model will help to provide a visual representation of data needs. The team of Acme Global Consulting will be able to clearly understand data requirements of the clients and can easily interact and discuss with them through visual representations so that data requirements can be verified before further steps. E-R model will increase communication and helps in integrating with relational database models. This concept will form the basis for future system database designs and make easy to convert clients using the E-R model.
The essential components of an E-R model are: (1). Entity: An entity is a name given to real world concept or item which have physical existence. An example of entity is a
Show More

Related Documents: Logical Design Part 1

Assignment 2: Logical Design Part 1 Essay

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…

Words 722 - Pages 3

Formal Methods In Software Engineering

Formal Methods in Software Engineering Lecture Slides 1 Asim Raza Fall 2012 Beaconhouse National University Lahore Content 80% case studies Pervades computer science, e.g., hardware circuit design, artificial intelligence, knowledge representation, database systems, programming languages, software engineering (design, verification, specification), … Will help you understand application of formal methods in computer science. i.e. Formal specifications in Z Content 20% Theoretical study…

Words 761 - Pages 4

Essay Mgt 3305 Exam 2 Study Guide Spring 2015

Characteristic that can be used to guide the design of service systems service triangle factors that distinguishes service design and development from manufacturing design and development 1. The process and the product must be developed simultaneously. The process is the product. 2. A service operation lacks the legal protection commonly available to products. 3. The service package constitutes the major output of the development process. 4. Many parts of the service package are defined by the…

Words 689 - Pages 3

Chapter 4 -SQL Essay

Conceptual models such as the ERM can be used to understand and design the data requirements of an organization. Therefore, the ERM is independent of the database type. Conceptual models are used in the conceptual design of databases, while relational models are used in the logical design as databases. The ERM forms the basis of an ERD. The ERD represents the conceptual database as viewed by the end user. ERDs detect the database’s the main components: Entity – as an object of interest to as…

Words 2706 - Pages 11

Essay on ECE 3561 Lecture 12 VHDL Overview

systems support VHDL, Verilog, System C, System Verilog CAD systems (just some of them)     Cadence – Incisive Mentor Graphics (Model Sim) – ModelSim, Questa Altera, XILINX Synopsis – Mainly toward synthesis and ASIC production from HDL descriptions 1/8/2007 - L2 VHDL Introcution © Copyright 2012 - Joanne DeGroat, ECE, OSU 3 A brief history of HDLs  The development of today’s HDL began in 1980.      State of CAD – generators and proprietary HDLs VHDL requirements set in 1981 VHDL IEEE…

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

Cs251 Fundamantals of Database Systems Ip 1 - 5 Essay

CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks…

Words 1684 - Pages 7

Creationism In Schools

a bunch of notes on why Creationism should be taught in Public schools. Here you go. School board approved intelligent design, Dover, Penn. To exclude anything but Darwin is fraud Intelligent design: legitimate science? Federal court decides Oct. 2004 Dover, Penn. School board required high school science classed to tell students evolution not only option. Intelligent design as well. Organisms too complex to evolve through evolution alone. Some must be created by designer. Bold new scientific…

Words 515 - Pages 3

System Development Life Cycle Essays

in OMB Circular A-130, Appendix III and the standards and guidance issued by the National Institute of Standards and Technology (NIST)” (National Security Telecommunications and Information Systems Security Committee, 2000, p. 1). NIST Special Publication 800-64, rev. 1, provides an overview of the security considerations for each phase of the SDLC – “Each SDLC phases includes a minimum set of security steps needed to effectively incorporate security into a system during its development. An organization…

Words 1247 - Pages 5

Networks: Routing and Marks Essay

answer eight (8) questions. This examination is worth a total of one hundred (100) marks. Please record multiple choice questions in the multiple choice answer sheet provided. Please record your answers in the examination answer booklet provided. Part A Question (20 Marks) Instructions Answer each of the multiple choice questions by copying the choice into the examination booklet. Only the answer option is required. Example Question: CMIP: a) is the TCP/IP network management standard…

Words 1741 - Pages 7