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.
The first term is Database (DB), which is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system. Traditional databases are organized by fields, records, and files. To access information from a database, you need a database management system (DBMS). This is a collection of programs that enables you to enter, organize, and select data in a database. The second term, Entity-Relationship Model (ER) is a way of graphically representing the logical relationships of entities or objects in order to create a database. The ER model was first proposed by Peter Pin-Shan Chen of Massachusetts Institute of Technology (MIT) in the 1970s (Ricardo, 2012, p. 19). The third term is relational model, which...
Please join StudyMode to read the full document