Computer Science
studystudent
Week2-EntityRelationshipDiagram2.docxRunning head: ENTITY RELATIONSHIP DIAGRAM 1
ENTITY RELATIONSHIP DIAGRAM 2
Entity Relationship Diagram
Overview
Estations Inc., a company that was formed from the merger of two giant tech companies Major Electric Corp (MEC) and The Electric Car Company (TECC) jointly established a business entity known. The purpose of this business merger was to develop operational stations in areas that were geographically close to the city. Proximity to the town was an essential enabler of the city dweller not only to park their electric cars during daily office hours but also to recharge them. The company intends to utilize the Shelf Software for many of the primary purposes. Also, there is the need to come up with various stations meant for electric car parking while they work in the office. As the cars park, they can also recharge the batteries as this also saves more time. The company is in the process of establishing an exceptional organization upon which I will head significant methods, including management of database, creation, and administration of application as well as software.
The first step upon assuming my roles as the head of the new organization will be to identify the entities. The significant objects include Estations.inc formed from the merger of two major tech giants. The second entity will be the new organization where I will be the head. The fourth entity will be the parking, and the fourth entity will be the creation of application as well as the management of the database.
The other necessary process will be defining the primary keys. The primary keys could be Estation Inc as to the name of the company, the name of the new organization that Estatino envisions to establish, the Car parking program, a code recording system for the electric cars, electric cars, and the employees.
In this ERD paper, I intend to conduct comprehensive research on the contemporary state of Estations Inc. and especially the signs of progress the company wants to make after its merger. As a new entity, the company has envisioned to accomplish various goals including the establishment of a new company, creation of an electric car park, creation of applications as well as the appropriate use of the database to increase profitability. It is also important to note that since its merger, Estation Inc. has recorded an increase in the number of electric parking in areas proximity to the city. Information needs here apply in the sense that the company will need tracking application and devices to track the reserved parking spaces. The Entity-Relationship- diagram below has captured Estation’s information need for the company’s attempt to accomplish its project scope.
Estation Parking ERD System
The figure above shows the proposed ERD system for Estation Inc. electric car parking.
Model Changes and Normalization
Since Estation Inc. is a data warehouse enterprise, ac third standard form of a normalized model is the most appropriate option for this type of data model. Although the model does not depict relational integrities are not encompassed into this model, the ETL (extract, load, and transform) procedures will be utilized in ascertaining that the database is connected within the model (Allan et al., 2019). It is also important to note that Estation has a substantial amount of data detailing from the tracking systems, the parking, electric refilling data, and employees. It is, therefore, best for the company to use the third standard form of data as well as numerous source systems that demand queries for complex businesses with voluminous data such as Estation for appropriate consolidation of data. While I realize various challenges related to the adoption and integration of the 3NF model and particularly performance-related challenges, the advantages of Estation using this model as the company’s data storage system are indeed more significant than the related performance malfunctions (Zhang et al., 2017). Performance similar challenges can also be optimized by the integration of appropriate designs, software, and applications that I intend to create in pursuit of solving the problems.
References
Allan, D., Lau, K. H. T., & Gong, Y. J. (2019). U.S. Patent Application No. 10/216,814.
Zhang, L., Shi, L., Zhang, B., Zhao, L., Dong, Y., Liu, J., ... & Pei, S. (2017). Probabilistic Entity-Relationship Diagram: A correlation between functional connectivity and spontaneous brain activity during resting state in major depressive disorder. PloS one, 12(6), e0178386.
