![]() Finally we have to store the items purchased on each order.Repeat the steps above to create the ERD as below.Right-click on ItemVariant entity and select New Column from popup menu, then enter the following columns. Release the mouse button and name it as ItemVariant.Press on One-to-Many Relationship -> Entity and drag it out. ![]() Move the mouse pointer over the Item entity. Let's create ItemVariant entity from Item entity with one-to-many-relationship. a bike jersey will have different size and color. Every Item may contains various variations, i.e.Press Esc key on keyboard to stop editing of the Item entity.Now enter name : varchar(255) and price : float(2) for the next 2 columns. By default a new column will be created and in editing mode upon you confirm the previous column.Enter +ID : int and press Enter to create a primary key column ID with type as int.Right-click on the Item entity and select New Column from popup menu.Name it as Item and press Enter to confirm editing. Then click on the diagram to create an entity. Select Entity from the diagram toolbar.Name the ERD as BikeShop, and press OK to create the blank ER diagram.Enter erd in the search box to locate the Entity Relationship Diagram. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |