LOGICIAL DESIGN PART 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 be interactive too. The essential components of the E-R Model are as listed below: Entity- An entity is a given name to a real world concept or item that has physical existence. An entity can represent a person, place event, object or concept.

Attributes - The properties that are related to a particular entity are known as