...Logical Design, Part I Wayne Murphy Strayer University Introduction to Relational Database Management System CIS111019VA016-1132-001 Jean-Robert Bokino January 11, 2013 Logical Design, Part I 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 entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. (4). Describe the need for the enhanced E-R model and how we can create sophisticated models to help us in complex environments. (5). Outline and describe the advantage of using the relational model. (6). Create an E-R diagram using graphical depicting software that could theoretically be used in a restaurant application. Now that you know the purpose of this assignment, I will define three key terms that will be discussed in this assignment. The first term...
Words: 1493 - Pages: 6
...The Advantages of a relational Model According to ACME Global’s website the mission of ACME Global is to “Help clients achieve profitable growth by aligning and improving customer facing processes and by continually seeking ways to improve operational performance"(“ACME Global,”2014) Because of your consultants over 100 clients maintain successful business with financially and operationally sound strategies. To continue this success and expand on that success a relational model would be easy to use. The revision of any information as tables consisting of rows and columns is much easier to understand. This would play a vital role in organization of not just your consultants but when you stop and look at your clients and the data you are responsible to managing along with the common data and information you want to know. An E-R Model provides Flexibility: Different tables from which information has to be linked and extracted can be easily manipulated by operators such as project and join to give information in the form in which it is desired. This would be most beneficial to you when you look at your areas of Strategic Development and Business planning, marketing & Sales Strategy and your Operations and Organization Management. In all of these are areas are key data and resources of ACME Global that would be enhanced by using a relational model. Purpose of an E-R Model Specific to ACME Global Consulting ACME Global along with your partner Deegit, Inc. deliver innovative...
Words: 672 - Pages: 3
...Assignment 2: Logical Design, Part 1 Due Week 2 and worth 50 points You have been hired by ACME Global Consulting to procure requirements for a large database. In developing database management systems, E-R models are used to graphically depict complex relationships between entities. In this assignment, you are to convince a set of clients of the benefits of using an E-R model in developing a database. Write a two to three (2-3) page paper in which you: 1. List the advantages of a relational model specific to ACME Global Consulting. 2. Summarize in your own words the purpose of an E-R model specific to ACME Global Consulting. 3. List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. 4. Describe the need for the enhanced E-R model and how we can create sophisticated models to help us in complex environments. 5. Outline and describe the advantage of using the relational model. 6. Create an E-R diagram using graphical depicting software that could theoretically be used in a restaurant application. Note: The graphically depicted solution is not included in the required page length. Acceptable software used to depict the solution includes any drawing tool, such as Microsoft Visio, Microsoft Paint, open source alternatives or similar drawing tools. You are free to formulate constraints, entities, attributes, etc. Potential entities may include but are not limited to customers...
Words: 449 - Pages: 2
...1. List the advantages of a relational model specific to ACME Global Consulting. Relational models can provide some very significant advantages over other methods. First, they are very easy to read due to the nature of two-dimensional tables. Columns and row format is straightforward and consists of a collection of similar data among rows that allow for the user to easily locate what they need. One of the biggest advantages of the relational model of database design is that its foundation is formal mathematical theory. It allows its concepts to be defined and examined with great precision. In other systems, the calculations may need to be done separately prior to using the database. 2. Summarize in your own words the purpose of an E-R model specific to ACME Global Consulting. The E-R model can provide ACME Global with a specific, but open-ended design that is tailored to the company’s needs. This also allows us to sketch the design of a database informally and incorporate changes in order to avoid problems later on. The E-R model allows for growth beyond its ideas at inception. It lays the groundwork for later database relational designs. 3. List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. Entity: real-world object or thing with an independent existence and which is distinguishable from other objects. Examples are a person, car, customer, product,...
Words: 313 - Pages: 2
...1. List the advantages of a relational model specific to ACME Global Consulting. Relational models can provide some very significant advantages over other methods. First, they are very easy to read due to the nature of two-dimensional tables. Columns and row format is straightforward and consists of a collection of similar data among rows that allow for the user to easily locate what they need. One of the biggest advantages of the relational model of database design is that its foundation is formal mathematical theory. It allows its concepts to be defined and examined with great precision. In other systems, the calculations may need to be done separately prior to using the database. 2. Summarize in your own words the purpose of an E-R model specific to ACME Global Consulting. The E-R model can provide ACME Global with a specific, but open-ended design that is tailored to the company’s needs. This also allows us to sketch the design of a database informally and incorporate changes in order to avoid problems later on. The E-R model allows for growth beyond its ideas at inception. It lays the groundwork for later database relational designs. 3. List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. Entity: real-world object or thing with an independent existence and which is distinguishable from other objects. Examples are a person, car, customer, product, gene...
Words: 523 - Pages: 3
...1 Jon Jones Professor Segura CIS111 Intro to Database Mgt Systems April 20, 2013 The ACME Global consulting will provide software development solutions, offer advice and support and structure within a company. From short to long term project as well as small to large sized businesses and corporations. The main components that apply to this are having a set of domains and sets that represents data structure, Integrity of rules that ensures data protection and operations that will carry on data. The company needs to have an understanding of data and functional needs of the company. The relational model can be used with both databases and the management systems. The relational model would allow the designer to develop the logical structure and specify what needs to be done and provide options for the design. The advantages of the relational model would be simplicity of the concept, implementation design and Ad hoc capability of query implementations. The purpose of E-R model for the ACME global consulting is to inform clients of a powerful database design that the relational model can show. The E-R model consists of components like entities, attributes and relationships for example. The model helps provide a visual representation of the data needs. The relational model can apply to databases and the management systems. By seeing the visual diagrams Acme global consulting would be able to see clearly and understand the data requirements of the clients. It also could...
Words: 641 - Pages: 3
...increased the cost of transmitting voices, data, and images. Answer: FALSE 6) Mobile phones are the most transformative technology in developing economies. Answer: TRUE 7) Today, the cost of transportation, as a proportion of the value of products shipped internationally, has increased dramatically. Answer: FALSE 8) Globalization results in more demanding buyers who shop for the best deals worldwide. Answer: TRUE 9) Which of the following is characteristic of globalization of markets? A) lack of skilled labor B) conservatism C) declining trade barriers D) diminishing gap between the rich and the poor Answer: C Global Operations Report (Scenario) As Vice President of Global Expansion for Pax Telecom, Deva Mikiri is tasked with preparing a comprehensive report on the company's global operations over the past twenty years. Deva assigns three strategists to collaborate on the History portion of the report, which details the rationale behind Pax's decisions to expand operations in particular areas. Rashid Ahl focuses on early expansion to China, which occurred after China began to make its market more accessible to foreign companies. Markus Teller focuses on Pax's expansion to Eastern Europe, which was motivated by increased industry privatization in key countries. Lavonne Jackson focuses on expansion to...
Words: 1231 - Pages: 5
...ACME Global Consulting Brenda Lucas Entity relationship modeling is extremely valuable in a complex data environment. In relational database management system, entity relationship modeling becomes essential when dealing with a large number of entities and/or complex relationships. In addition, some entities that have many different relationships, or even multiple relationships with a single entity, can be difficult to conceptualize without the assistance of a well-thought-out model. As pointed out by Allen (2005), entity relationship modeling provides a highly intuitive reference for developers of a database system. ACME Global Consulting is an organization that services a vast number of clients across many domains. They deal with thousands of orders and products on a daily basis. From their customer service department to their order fulfillment department, the need for an efficient, accurate information system is self-evident. However, when dealing with so much information in such a complex system, the importance of proper planning and design cannot be overstated. There is no area of the system development lifecycle more critical than planning and design. The purpose of the entity relationship model to be developed for ACME Global Consulting is to visualize the entities and relationships that will exist within the relational database. As is discussed by Chilton (2006), it can be difficult to wrap one’s mind around the concept of relational databases at first. It...
Words: 953 - Pages: 4
...ACME Global Consulting Proposal Walterella McNear Professor Thurman Roles CIS 111, Intro to Relational Dbase Management Systems January 23, 2013 Dear ACME, I am sending my recommendations regarding your options for ACME Global Consulting Database Management System (DBMS). In this fast-paced and competitive business world, you want to make the database your company uses simple and easy to use. The E-R Model DBMS will allow your employees to be more efficient and productive in their daily workday schedule. As we all recognize that productivity is one of the many keys to a successful business. Advantages of the Entity Relational Model: a. Structure: The structure of the E-R Model DBMS is the ease of use. This system will allow the users to communicate with each other on the basis that it is not so technical. Your company would have a low percentage rate of mistakes during data entry throughout the daily workforce. This structure also allows employees to communicate and interact with each other more effectively should problems arise. A more efficient workflow would be established due to the different employee groups understanding each other and would be able to solve different issues that may arise within the DBMS. b. Components: Another advantage to having this E-R- Model DBMS is that the components will allow your employee groups to distinguish the differences between these different components in the model. Some of the components are entities that represent...
Words: 515 - Pages: 3
...Running head: BENEFITS OF A DATABASE AND INFORMATION-GATHERING Benefits of a Database and Information-Gathering Techniques Benefits of a Database and Information-Gathering Techniques Hello Mr. ACME Global Consulting interviewing person, I'm Alucard Lazarus, it's a pleasure to meet you. I can offer over a hundred years of experience in consulting, managing employees, customer logistics, and excellent database management system or DBMS knowledge. All of which should make me the ultimate candidate for your organization. Let me explain to you how I can improve upon the current schema for the company’s new restaurant using DBMS. First of all let me explain what I know is DBMS; it’s software that allows data to be manipulated, stored, and retrieved from the data stored which can be accessed by multiple users. The application programs used for those operations are Microsoft Access, SQL Server, and Oracle. The advantages of a DBMS are maintaining what terms are used to search by therefore making searches quick and easy, keeps control of data redundancy (it’s a process from 1NF to 2NF to 3NF), information security feature with keeping those that require certain access to data, has the automatic functions necessary to save and recall data for back up recovery, it makes sure that data can be accessed through any application that the company will use, there are different interfaces for users to get to the data that they need to get to, and it uses whatever rules that the company...
Words: 841 - Pages: 4
...Global Financial Management FIN630 AIU Abstract This paper will discuss the long-term investment projects Acme is considering doing in China. Acme is a US firm that plans to focus on investing in and penetrating markets in China. It will discuss the potential profits as well as the policies that are currently in effect in China. It will give the information on the factors that would be used to consider doing business in China such as import/export restrictions, labor relations, supplier financing, tax rules, etc. Global Financial Management Introduction A long-term investment, which includes stocks, bonds, real estate, and cash, is an account on a company’s asset side of the balance sheet that represents an investment the company intends to hold on to for more than a year (Definition, 2013). The US firm, Acme, wants to focus on investing in markets in China. There are many factors to consider when doing business in any foreign country, China is no different. The first bit of information to look at is the back ground of China. China, whose capital and focal point is Beijing, with over 4,000 years of verifiable history, is believed to have the oldest continuous civilization. The official language of China, which is derived from a Mandarin dialect, is Chinese. China is a Communist country that promotes atheism and a constitution that guarantees freedom of religion (China Introduction, 2013). Culture The second bit of information to look at is the appearance...
Words: 913 - Pages: 4
...the context of the following subject: Portfolio Project Risk & Stock Market M2 EUROPEAN AND INTERNATIONAL PRIVATE BANKING Submitted by: Instructor: KAKAVAND Samaneh EGRET Paul DOU Yan Academic Year 2012/2013 Introduction: Global Economic & stock market Performance: Mixed signals January 2013 is a great month for stock market. Since January, the stock market goes up, so maybe this stock market bulls will keep running in the whole year, especially, the Dow Jones Industrial Average is increasing dramatically, from 12520 in July 2012 to 14275 today. Source: Google Finance One potential reason for the optimism is a positive sense of global economy in the future; the euro zone is not going to break up, because in September 2012, European Central Bank promised unlimited bond-buying to keep the euro together; China has avoided a hard landing, America avoided falling off the fiscal cliff. Additionally, Federal Reserve agreed to keep interest rates down to help encourage investment and decrease the unemployment rate. Based on the above economic performances, we can argue that the share prices will go up, because the global economy is recovering from recession. Since the bonds yields will keep running low in 2013, investment in equity market is a more reasonable choice. However, market risk and uncertain can never be ignored. The biggest reason for caution is the gap between stock-market optimism and economic...
Words: 4577 - Pages: 19
...Benefits of Relational Models to ACME Global Consulting Geoff Roberts Professor Rahat Zafar Intro to Relational Database Management Systems 1/16/13 Businesses thrive on information. To succeed, you must have the most current knowledge to stay competitive in a rapidly changing industry, such as Information Technology. The trick is, not only knowing where to find the information, but how and where to secure it. Databases are the keystones to any business looking for organization and quality management. They will allow your company to track expenses, market trends, employees, equipment, and most importantly, clients. The question? How do I deploy an efficient database? In order to implement a database, it should be planned out to ensure it meets all requirements of the organization. Consider your own company’s needs for a moment. Organizational charts, certifications, client accounts, investments. How are these examples mapped so that the information is readily accessible in an efficient way? The answer, employ Relational Models from which a functional database that meets all level requirements can derive from. This is a major step in becoming a prepared, well organized, and respected consulting firm. A Relational model or entity-relationship diagram (ERD) is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities, within an information system (http://searchcrm.techtarget.com). Relational models help...
Words: 624 - Pages: 3
...operations. 4.> Student management system for Schools and Colleges. Advantages of DBMS 1.> It reduces the data redundancy (duplicate data in the database). 2.> Scalable: DBMS systems are highly scalable i.e. these systems can be scaled to store more data as required in the future. 3.> Multiple accesses: Database software allows data to be accessed by multiple users simultaneously without causing any locks in the database. 4.> Security: In DBMS system we can secure the stored data by providing the access to only authorized user. 5.> Backup and recovery process is very easy. We can take back up of complete data to protect it from any natural disaster, such as earth quake, Strom, Flood etc. How DBMS is supporting ACME Global...
Words: 290 - Pages: 2
...Brian Morgan James.Neiman CIS 111 Benefits of a Database and Information-Gathering Techniques April 28, 2012 Benefits of a Database and Information-Gathering Techniques Database: Database is the collection of data or information, so that it can be easily fetched, managed and update. In database data or information is stored in the forms of tables. Each table in a database has it unique name and table duplication is not allowed. Example of database: Oracle 10g, MySQL, SQL Server, IBM DB2 etc. DBMS terms refer to the database management system. A database management system (DBMS) is a collection of software application package with some computer programs that are used to store, create, fetch, modify and extract the information from the database. Each DBMS system has some set of rules and pre-defined paradigm on which each database is working. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes or Solaris servers. Some of the example of DBMS is 1.> Air lines flight management system. 2.> Employee’s payroll management system for an organization. 3.> Inventory management system for warehouse operations. 4.> Student management system for Schools and Colleges. Advantages of DBMS 1.> It reduces the data redundancy (duplicate data in the database). 2.> Scalable: DBMS systems are highly scalable i.e. these systems can be scaled to store more data as required in...
Words: 777 - Pages: 4
