The success of a project can be severely be impacted if each of the key components is not planned out carefully and correctly. For more and more projects these days, a database is one of these key components. The database, while always given attention, is often not given the full planning that it deserves. This lack of planning at the beginning of a project could potentially lead to additional difficulties for the development team or result in limitation in both functionality and performance once the project is completed. To help with the planning of a database their exists a number of tools and methodologies, many of them follow the plans outlined by Dr. Peter Pin-Shan Chen and use the Entity-Relationship Model as their basis.
Dr. Peter Pin-Shan Chen first presented the Entity-Relationship (E-R) Model in March of 1976, in a widely read paper entitled, “The Entity-Relationship Model – Toward a Unified View of Data”. In this paper Dr. Chen proposed merging three other models, the Network model, the Relational Model, and the Entity Set Model into a single system which could take advantage of the best of all three. (Chen, 1976) This new unified model would be comprised of a number of Entities, which would be defined as a person, a place, an object, or some type of event for which the database is being designed to track and maintain. It is important to understand and note that entity definitions may not be well defined across any entire company as one department could easily define a term different depending upon their point of view. For this reason it is a good idea to ensure that these entities are well defined and that they are not used incorrectly. Entities can have a number of Attributes associated with them as additi...
... middle of paper ...
...inking and the Enhanced Entity-Relationship (EER) Model was created to expand the E-R Model. The EER added a number of new useful concepts that more accurately described the modeled data of this new age. Many other concepts and features have been incorporated into this model, which will continue to grow and adjust as the data that is being modeled adjusts and changes. At its heart however will remain the basic features put forth as the Entity-Relationship Model.
Works Cited
Chen, P. (1976). The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems, 1(1), Retrieved from http://www.csc.lsu.edu/news/erd.pdf
Witt, G. (1997, August). Is data modeling standing still?. Database Programming & Design, 64 . Retrieved from http://go.galegroup.com.portal.lib.fit.edu/ps/i.do?&id=GALE|A19690038&v=2.1&u=mel b26933&it=r&p=CDB&sw=w
problem and it will be used in this case to build the databases. The databases
As defined by Kroenke Database is an integrated, self-describing collection of related data. Data is stored in a uniform way, typically all in one place- for example, a single physical computer. A database maintains a description of the data it contains and the data has some relationship to other data in the databa...
The project would be created on the Linux distribution Ubuntu and should make use of modern design practises such as entity relationship diagram modelling for the database schema. The application itself should be object oriented and be designed with the aid of The Unified Modelling La...
In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.
Key words and phrases (highlighted) were used to determine the appropriate entities and their attributes, and to help determine the kinds of queries that might be useful for key stakeholders.
In order to ensure a successful ERD, several tasks will need to be executed. One of the constraints we are presented with is the potential lack of documentation. One way to overcome this constraint will be to interview subject matter experts and the key players involved in the maintenance process. The first requirement will be to draft an Entity-Relationship Diagram (ERD) based upon the business rules and the entities, which were captured by Smith Consulting. All of Huffman’s hubs will use the database and with that, will need to be robust enough to handle the volume.
Smyth, Z. A. (2005). Implementing EDRM: has it provided the benefits expected? Records Management Journal, 15(3), 141-149. doi:10.1108/09565690510632328
The database application design can be improved in a number of ways as described below:
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
When developing a relational database understanding the logical flow of information and proper planning will improve the probability of the database functioning the way it is intended and producing the desired results. In determining the proper structure of a relational database for a video rental store one must consider what information is stored, the process for renting videos and information on the videos maintained in inventory. Customer, Videos and Video Types are the entity classes that will be discussed and Customer Order is the intersection relation needed to explain the complete process as seen on the Entity Relationship Diagram below.
The reason for the selection of this topic is because it falls under the computer science category. We have been studying databases for four years and so the this topic area will be of great use when venturing into the cooperate world.
With the advancement in database systems and software, Eric Brewer in his new article that:
Relationships: It represents the connection between data objects. For example the relationship between shopkeeper and a
“An Enterprise resource planning (ERP) systems are software systems for business management, supporting areas such as planning, manufacturing, sales, marketing, distribution, accounting, finance, human resource management, project management, inventory management, service and maintenance, transportation, and e-business”.( Haag, Cummings, Phillips, S, M, A (2007). Mangement Information Systems. New Yory, NY: The McGraw-Hill Company Inc..)
E-business and e-commerce are terms that are sometimes used interchangeably, and sometimes they are used to differentiate one vendor’s product from another. In both cases, the e stands for "electronic networks" and describes the application of electronic network technology - including Internet and electronic data interchange (EDI) - to improve and change business processes (Bartels, 2000)