Need an example of a database schema for an online or ecommerce store and an explanation...

Need an example of a database schema for an online or ecommerce store and an explanation of the how it functions

Solutions

Expert Solution

This Exanple of Database schema is so simple and just at a basic level:

Some basic requirements for the online store, for which this schema made for:

First of all user will register himself/herself on the portal,then there will a list of products which are available to buy. The store will have an inventory of products. Each product has a unique price, but this price should vary depending on sales. Customers can make orders for multiple products at a time, and should be able to see their order history. When the order has been completed, there should be a track and trace number.

Functions:

1)Registeration:

Every one on this online store will have his own account on which his register him/her self and share his information about his address Cell Number e.t.c.

2)Product Management:

After Registeration they will have a list of available products and he/she will start selcting items.

3)Order Management:

After selecting the products there will be a proper order is ready by adding the shippment charges or anything else.

4)Payment Management

After the completion of Order user will have to choose a payment method which could be cash on delivery or by Debit card(online).

5)Delivery System

After the whole work done by user the order will be given to the post office to deliver on the given address.

PLEASE GIVE US A THUMBS UP.

IF YOU HAVE ANY QUERY PLEASE COMMENT BELOW.

venereology answered 1 month ago

Next > < Previous

Related Solutions

Database design of cothing Online Shopping System. Schema represents minimal information required to store information of...

Database design of cothing Online Shopping System. Schema represents minimal information required to store information of a shop and products to sell. Cart information can be stored in session or if wish-list / watchlist is needed, the schema can be simply extended. Enjoy. SQL and methodology.

Listed below is the relational database schema for an online store(SQL/Java): MEMBER(last_name, first_name, email, password, user,street,...

Listed below is the relational database schema for an online store(SQL/Java): MEMBER(last_name, first_name, email, password, user,street, city, state, zip, card_type, card_no, expiration, name_on_card) book_SALE(listing_no, seller, isbn, condition, price) ORDERS(order_no, buyer, order_date, tot) ITEM(order_no, listing_no) BOOK(isbn, title, author, edition, publisher, keywords) The bold attribute(s) in a relation is the primary key of that relation. The italized attributes in some relations denote foreign keys. The seller attribute in the book_SALE relation is a foreign key to the user attribute in the MEMBER...

Listed below is the relational database schema for an online store(SQL/Java): MEMBER(last_name, first_name, email, password, user,street,...

Listed below is the relational database schema for an online store(SQL/Java): MEMBER(last_name, first_name, email, password, user,street, city, state, zip, card_type, card_no, expiration, name_on_card) book_SALE(listing_no, seller, isbn, condition, price) ORDERS(order_no, buyer, order_date, tot) ITEMS(order_no, listing_no) BOOK(isbn, title, author, edition, publisher, keywords) The bold attribute(s) in a relation is the primary key of that relation. The italized attributes in some relations denote foreign keys. Create/Define the table.

The schema for the Academics database is as follows. Understanding this schema is necessary to answer...

The schema for the Academics database is as follows. Understanding this schema is necessary to answer the questions in Part B. DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum*, acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum*, acnum*, descrip) The semantics of most attributes are self-explanatory. For each relation, the primary key is underlined and any foreign keys are denoted by an asterisk (*). Some additional information for relations is given below: DEPARTMENT: Each academic department...

When is the conceptual schema of a database changed?- if we update data in the database...

When is the conceptual schema of a database changed?- if we update data in the database -if we alter the logical structure of the database -if we retrieve data from the database -if we alter the storage structure of the database Which of the following has the same meaning as the outer union? Group of answer choices -the left outer (natural) join -the right outer (natural) join -the full outer (natural) join -the inner (natural) join Assume {A, B} is...

Consider the following database schema: Frequents(kid, store) Sells(store, candy) Likes(kid, candy) Stores(store, city, phone) Kids(kid, city,...

Consider the following database schema: Frequents(kid, store) Sells(store, candy) Likes(kid, candy) Stores(store, city, phone) Kids(kid, city, age) Write relational algebra expression(s) to: a) Find the stores in ’Warrensburg’, for each display only the store name and phone number. b) Find the stores in ’Warrensburg’, which sells ’Hersheys’ or ’Mars’. Your expression must use set union. c) Repeat the above without using set union. d) Find the kids who are 10 years or older and like ’M&Ms’. e) Find the kids...

• Relational Schema Create a relational database schema consisting of the four relation schemas representing various...

• Relational Schema Create a relational database schema consisting of the four relation schemas representing various entities recorded by a furniture company. Write CREATE TABLE statements for the following four relation schemas. Define all necessary attributes, domains, and primary and foreign keys. Customer(CustomerID, Name, Address) FullOrder(OrderID, OrderDate, CustomerID) Request(OrderID, ProductID, Quantity) Product(ProductID, Description, Finish, Price) You should assume the following: Each CustomerID is a number with at most three digits, each OrderID is a number with at most five digits,...

[Q.4] Answer the following questions You are invited as a database architect to develop database schema...

[Q.4] Answer the following questions You are invited as a database architect to develop database schema for maintaining patient information for the NYU medical group (make necessary assumptions for the data requirements if needed). Each physician in the Lehman medical group is uniquely identified by physicianID o Each physician must have first name, and last name, and phone number Each patient is identified by patientID o Each patient must have first name, and last name, phone number, and insurance card...

i need explanation when the energy being store in the capasitor and in the inductor ?

This refer to the “om” database (or Schema) that you will find in your MySQL Workbench...

This refer to the “om” database (or Schema) that you will find in your MySQL Workbench program if you have run the sample database install script. Please save all of your answers in one script (.sql) or type all your answers into Notepad++ and submit them as a single .sql file. Please test your SQL statements in Workbench 1. Using an INNER JOIN, select the order_id, order_date, shipped_date, fname, and customer_phone from the orders and customers tables. The fname is a...

Subjects