1 / 8

EBM680 Business Case-Revised

TESTAFONG THARSDIOHF

leenaasher
Download Presentation

EBM680 Business Case-Revised

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. Creating ER Diagram Student Name: Leena Asher Task 2  Stratford University ISM521 Database Systems Technology Instructor: Dr. H. Besharatian

  2. Entity Relationship Diagram

  3. Details of ER Tables Introduction: Database of an online E-Commerce Website Tables created: • User details • Order details • Cart details • Product details • Order Information details

  4. Details of ER Tables Five tables have been designed Table 3: Product Details Product Id Product cat Id Product brand Id Product title Product price Product description Product image Brand id Brand name Category name • Table 4: Order Details • Order Id • User Id • Product id • Amount • Card Id • Order status Table 1 : Customer Details • User Id • User Name • User email id • Password • Date of birth • First name, Last name • Mobile number • Address Table 2 : Cart details • User Id • Text Id • Qry • Table 5: Order Master • Order Id • User Id • Transaction Id • Status Id • Order number Id

  5. Entity Relationships in the Tables Explaining the ER (part 1) 4 relationships Usermaster table to Ordermaster table = 1:M products table to order_info table = M:M cart table to products table = M : M usermaster table to cart table = 1 : 1

  6. Entity Relationships in the Tables Explaining the ER (part 2) usermaster table to cart table = 1 : 1 usermaster table share one to one relationship with cart table. Each user can have maximum one cart associated Usermaster table to Ordermaster table = 1:M usermaster table shares one to many relationship with ordermaster as each user can place several orders

  7. Entity Relationships in the Tables Explaining the ER (part 2) products table to order_info table = M:M products table can share Many-to-Many relationship with order_info table.one order can contain many orders and one product can be places in several orders cart table to products table = M : M cart table shares Many-to-Many relationship with Products table.In one cart many product can be associated and one product can be placed in many carts

  8. Project Status This is the Preliminary ER Design This is the start of the Database management project. Project is yet to be fully developed.

More Related