1 / 13

ER Diagram For Online Shopping - TAE

We can also call ER diagram the database design for the online shopping system project. The ER diagram is like a picture that contains how all the entities are related to each other. The most important part of the ER diagram is Relationships, Attributes, and Entities.

Himaani
Download Presentation

ER Diagram For Online Shopping - TAE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. T javaTpoint ER Diagram for Online Shopping

  2. Introduction An online shopping system shows how the databases are connected. It also shows how all the databases are logically related to each other.

  3. What is an ER Diagram An Entity Relationship(ER) Diagram is a diagram that represents relationships among entities in a database. It is commonly known as an ER Diagram.

  4. IMPORTANCE OF ER DIAGRAM The ER diagram for the project is the foundation for building the project's database. The ER diagram defines the properties, datatypes, and attributes.

  5. What is an Online Shopping System? It is a type of electronic commerce system that allows the customer to buy goods and services over the Internet. It can be done via a mobile app or web browser.

  6. FEATURES OF ONLINE SHOPPING ENTITY RELATIONSHIP DIAGRAM 1. SHOPPING MANAGEMENT 3. MANAGE TRANSACTIONS 2. CUSTOMER MANAGEMENT 4. TRANSACTIONS AND REPORTS MANAGEMENT

  7. How to Create an ER Diagram

  8. Step 1: Symbol of entity relationship diagram:- 1. Fields: This entity shows how the different types of data are used together for a project. The symbol is used to show how the part of the project is working. 2. Key: It is a technique that is used to categorize the quality of the data. There are two types of keys available for the database. These are as follows. Primary key: It is a set of unique properties that are used for finding the specific entity. A foreign key: It is a type of key made up of a piece of data with too many links to other things.

  9. Step 2: Finalize the entities included Start making your ER Diagram by deciding on all the parts your online shopping system must have. You’ll need to leave the area in your design for these rectangles to be included later.

  10. Step 3: Add the attributes of each entity In a conceptual ER diagram, the details of the different entities are given as attributes. Attributes are things like a thing’s traits, a many-to-many relationship, or a one-to- one relationship. Attributes with multiple values can be given more than one value.

  11. Step 3: Describe the relationships (cardinality) between entities and attributes You will need the entities, their attributes, and the relationships between them to plot the relationships between the ERD. To get the right entity relationship diagram, you will use the information you gathered to build the data structure.

  12. thank you www.tutorialandexample.com

More Related