“Logical Design, Part 1” Essay - 1428 Words

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†¦Next, I will address the advantages of a relational model specific to ACME Global Consulting. Since Acme Global Consulting is a leader in providing software development solutions to other companies, they need to have an in-depth knowledge of their clients functional and data needs. Therefore, a relational model can provide great benefits such as: (1). Conceptual simplicity: the model is very simple and helps to simplify data needs of their clients, (2). 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 accessibil ity of data, and (3) Ad hoc capability of query implementation: relational model provides a very easy and flexible way of data implementation and manipulation. In addition, a relational model helps to organize data in form of tables. A relational model is composed of three main components: (1), a set of domains and sets that represents data structure, (2). Integrity rules, which ensures data protection, and (3). Operations that will be carried on data i.e. process of data manipulation. The experts on relational models say that it is the most widely used and most evolved method of organizing data Today, all major database management systems assume that you will be working in some manner with the relational model (Date, 2012, p.Show MoreRelatedSoftware Architecture By Phillipe Kruchten915 Words   |  4 PagesIn the paper Architectural Blueprints—The â€Å"4+1† View Model of Software Architecture by Phillipe Kruchten, he examines how developers can use multiple views to capture the software architecture and how these views are more desirable than a single viewport that tries to capture everything. Each view, should ideally, address one specific set of concerns. For Kruchten, software architecture is the deliberate assembling of various architectural elements to fulfill the requirements of the system. The intentRead MoreThe Architecture Of Software Intensive Systems1449 Words   |  6 Pages Article 1 summary This article is mainly describing about the architecture of software intensive systems by using multiples of concurrent views, which is allows to study about the various stakeholders , end users,developers,system engineering, project managers,etc.., and to handle indusully functional and non function requirements. Mainly software architecture deals with the design and implementation of high level structure in software.It is the result of combination of many architecturalRead MoreDescription Data Type Format Range Label1154 Words   |  5 PagesLine number of the invoice Number(2) 99 0-99 PK, InvLine_pk InvNum Unique ID for the invoice Number(6) 999999 0-999999 PK, InvLine_pk ProductNum Product ID Varchar2(4) L999 P001-P999 FK, InvLine_prod_fk Quantity Quantity of each product Number(4) 9999 1-9999 Table: Product ProductNum Unique ID for each product Varchar2(4) L999 P001-P999 PK, Prod_pk ProductDes Description of the product Varchar2(40) LL..LL ProductCost Cost price of the product Number(8,2) 999999.99 0-999999.99 Table:Read MoreThe Theory Of Deconstruction And Its Impact On Postmodern Architecture1135 Words   |  5 PagesThrough The Wexner Center to Analysis Deconstructionism 1. Deconstructionism Deconstructionism developed in late 1980s by postmodern architecture. The core theory is deconstruction that eliminates construction then forms it together in different way. The first time of deconstruction speak of was Jacques Derrida in 1920s, after that a lot of architect influenced by him, like Peter Eisenman who designed The Wexner Center in OSU. Deconstruction is the critical of stands on modernist orthodoxy principlesRead Morequestion answer1663 Words   |  7 Pagesand provide an example of each. Aggregation: represents a â€Å"has a† or â€Å"is part of† relationship between entity types, where one represents the â€Å"whole† and the other the â€Å"part†. The relationship represents an association between two entity types that are conceptually at the same type. Example: Has relationship which relates the branch entity to the staff entity. Branch entity is the whole when the staff entity is the part of the branch. See figure 13.9 for better example. Composition: a specificRead MoreSystem Analysis and Design1287 Words   |  6 PagesSystem Analysis and Design Syllabus SYSTEM ANALYSIS AND DESIGN Module 1: Data and Information (3) Types of information: operational, tactical, strategic and statutory – why do we need information systems – management structure – requirements of information at different levels of management – functional allocation of management – requirements of information for various functions – qualities of information – small case study. Module 2: Systems Analysis and Design Life Cycle (3) Requirements determinationRead MoreProcess Modeling, Er Diagram and Logical Data Modeling969 Words   |  4 PagesWhite paper on Process Modeling, ER diagram and Logical Data Modeling Authors Yogini Wagh Process Modeling Process modeling is the concise description of the total variation in one quantity, by partitioning it into a deterministic component given by a mathematical function of one or more other quantities, plus a random component that follows a particular probability distribution. Software process modeling and business process modeling are the techniques for obtaining a better understandingRead Moreâ€Å"a Proposed Human Resource Information System Solution for the Agricultural Development Bank†.1235 Words   |  5 Pagesappraisals as well as performance management, training and recruitment decisions. ï  ® At present, certain HR functions are neglected, inefficiently performed or delayed because of a lack of procedure or official personnel assigned to carrying them out. 1. The Payroll function must be transferred from the accounts department and move from a semi-manual preparation to one which is automatically generated. 2. In addition, there is no means for time keeping and management of sick and vacation leave. 3Read MoreQuestions On Database Management System1123 Words   |  5 Pages Jody Fedor IT2700: Systems Analysis Design Assignment #6 – Review Questions Chapter #6 – Data Design 1. Explain the main difference between a file-oriented system and a database system. A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record. 2. What is a DBMS? Briefly describe the components of a DBMS. DBMS stands for Database ManagementRead MoreDifference Between Computer Organization And Architecture1286 Words   |  6 PagesContents Q 1 .What is the difference between computer organization and architecture? 2 Q 2. Draw the components of a digital computer and identify the function(s) of the different parts. 2 Q 3. Explain the different numbering system with examples. 5 Q 4. What is the instruction set? Differentiate between direct and indirect addressing modes. 5 Q5. Explain the following function? 6 â€Æ' Q 1 .What is the difference between computer organization and architecture? COMPUTER ORGANISATION †¢ Computer Organization