JaDonna Berger, Kelly Rottler, Stefanie Childree,
Gene Holmes, Greg Miller, Guillermo Blanco
DBM/380
Professor Shalini Devi
May 5, 2015
The most important step when creating a database are detecting the table elements. While analyzing the form entitled “Entities and Attributes for Fleet Truck Maintenance,” the database table elements can be clearly determined. The structure of a database can be defined based on the Entities and Attributes within a table or a relation. Entities may be used to allow the same rule to be applied multiple times to make a determination ("Define an Entity", n.d.). An attribute basically describes what the entity is. The entity-relationship model (or ER model) 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 (TechTarget, 2005-2015).
Entities and Attributes Selection
The clearly defined Entities and Attributes are located within the document entitled “Entities and Attributes for Fleet Truck Maintenance.” Underneath each capitalized entity are its particular attributes. A good example of this would be the entity entitled “Parts-Inventory-Issues,” and below this are the attributes which include: Issue Date, Transaction ID, Quantity, and Purchase Price.
It is important to make sure that all attributes are examined in order to make sure there aren’t any signs of redundancy and to also confirm that the table is logically organized when creating the table. As a result of this, all attributes and entities located within the actually database will have to be revised based on the documents attributes. Any attributes that show signs of repetitiveness will be reorganized or deleted in order to guarantee a consistent database. Each table will include a primary key which will
References: Define an entity. (n.d.). Retrieved from https://docs.oracle.com/html/E38269_01/Content/Data%20model/Define_an_entity.htm TechTarget. (2005-2015). entity-relationship model (ERM or ER model) definition. Retrieved from http://searchsqlserver.techtarget.com/definition/entity-relationship-model