ENTITY RELATIONSHIP DIAGRAM

-
Entity Relationship Diagram (ERD)                                                                                         It is also known as entity relationship model, is a graphical representation that depicts relationship among people, objects, places, concepts or events within an information technology (IT) system. It uses data modelling techniques that can help define businesses processes and serve as a foundation for relational database. (SearchDataManagement,2022)

(Bing.com,2022)


Related Terms Data Base Administrator (DBA) 

It is the information technician responsible for directing and performing all activities related to maintaining a successful database environment. A DBA makes sure an organization databases and related applications operate functionally and efficiently. Data Base as a Service (DBaaS) It is a cloud computing managed service offering that provides access to database without requiring the setup of physical hardware, the installation of software. Most database administration and maintenance tasks are handled by the service provider, enabling users to quickly benefit from the database service. (SearchDataManagement,2022)

Cloud Data Base

It is an organized and managed collection of data in an IT system that resides on a public, private or hybrid cloud computing platform. From an overall design and functionality perspective, a cloud database is no different than on-premises one that runs on an organizations own data centre systems.(SearchDataManagement,2022)

Entities Of ERD

Entities, which are objects or concepts that can have data stored about them. Entities refer to tables used in databases.(SearchDataManagement,2022)                                                                                                                                   

Attributes of ERD

These are properties or characteristics of entities. An ERD attribute can be denoted as a primary key, which identifies a unique attribute, or a foreign key, which can be assigned to multiple attributes. (SearchDataManagement,2022)   


References

  • SearchDataManagement. 2022. What is Entity Relationship Diagram (ERD)? - Definition from WhatIs.com. [online] Available at: <https://www.techtarget.com/searchdatamanagement/definition/entity-relationship-diagram-ERD> [Accessed 8 September 2022].
  • Bing.com. 2022. Entity Relationship Diagram Templates - Bing. [online] Available at: <https://www.bing.com/images/search?view=detailV2&ccid=ayT5hW58&id=87CEDF7166D99F2470F51C859FAC7DB00FEACD53&thid=OIP.ayT5hW58dRm0j7O_cjO81AHaEa&mediaurl=https%3a%2f%2fi.pinimg.com%2foriginals%2fe7%2fbe%2ff4%2fe7bef46ca4f6f225e7be0ed74e4deec4.png&cdnurl=https%3a%2f%2fth.bing.com%2fth%2fid%2fR.6b24f9856e7c7519b48fb3bf7233bcd4%3frik%3dU83qD7B9rJ%252bFHA%26pid%3dImgRaw%26r%3d0&exph=1510&expw=2530&q=Entity+Relationship+Diagram+Templates&simid=607988458423283423&FORM=IRPRST&ck=8524F01262E9976757D87E1636827745&selectedIndex=1&ajaxhist=0&ajaxserp=0> [Accessed 8 September 2022].

                                                                                                                                      









 

Comments

Post a Comment

Popular posts from this blog

Software Development Lifecycle

-
Image
The Software Development Life Cycle (SLDC) it is a structured process that enables the production of high quality, low-cost software, in the shortest possible production time. It defines a detailed plan with stages or phases that each encompass their own process and deliverables. SDLC Methodologies (Bing.com,2022) Lean The lean principle encourage creating better flow in work processes and developing a continuous improvement culture.     Agile       It produces ongoing release cycle, each featuring small, incremental changes from the previous release. It help teams to identify and address small issues in projects before they evolve into more significant problems.                                                                                       ...
Read more

Analyse and compare different examples of product Pages

-
Image
 Differences between Product pages  I have choose two different mobile companies for the differences of the product page. Here is the look of Apple mobile store (Apple (UK),2022) On the other hand I have choose Samsung mobile store (Samsung uk,2022) There is not too much difference between both store pages. Reference: 2022. [online] Available at: <https://www.apple.com/uk/store> [Accessed 8 September 2022 ]. Samsung uk. 2022. Samsung UK | Mobile | Home Electronics | Home Appliances | TV. [online] Available at: <https://www.samsung.com/uk/> [Accessed 8 September 2022].
Read more

Types of E-commerce

-
Image
Types of E-commerce (Bing.com, 2022) The first one is BUISNESS to CUSTOMER, B2C businesses sells directly to their end users. Anything you buy in an online store as a consumer from wardrobe and household supplies to entertainment is done as part of business to customer transaction.B2C includes products and services as well. Examples include Target.com and Macys.com. These go between put buyers and sellers together without owning the product or service.(Big Commerce, 2022) The second one includes Business to Business, a business sells its products or services to another business. Sometimes, the buyer is the end user but the buyer often resells to the consumer. B2B transactions generally have a longer sales cycle. As younger generations enter the age of making business transactions, B2B selling online space is becoming more important. Examples include ecommerce business sites such as Amazon business, Alibaba business. Tires, electronics are usually manufactured by various companies and...
Read more