“Logical Design, Part 1” Essay

1428 WordsApr 12, 20136 Pages
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 accessibility 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.
Open Document