Database system

Please i need different project

Thank you

Question 1: Design an ER-Diagram and write the respected SQL statements (10 marks] . . 1. Draw an ERD for an e-commerce application that receive orders from customers. You can think of Amazon or OpenSouq as examples. The details of the application are as follows: The customer can register in the website. The customer can login, change password, forget password, change his details, and logout. The customer can place orders. Each order will have one or more items. Each item will have some details, such as item code, name, description, qty, price, expiry_date, etc. For each order, we need to know the customer who ordered it, the order date, and the total value, payment details, etc. The customer can pay using cash, credit card, or cash on delivery. The customer can pick-up or ask for a delivery of the order, in the delivery case, we need to know the delivery address, delivery date, delivery fees. The admin of the store can see reports on customers' orders . 2. Map the ERD into a relational model showing the primary & foreign keys. . 3. Writ the SQL statements that are needed for the following: Get all customers Get all orders Get the order details of a certain order Get all customers in a certain city, such as Amman Get all orders of a certain customer Get all orders of a certain customer in a specific month Get all orders of a certain customer that has a specific payment method, such as credit card. Get all orders of a specific payment method, such as credit card. all orders of a certa customer tha was delivered to his address Get the order with the highest value of a certain customer Get the order with the lowest value of a certain customer Get the total value of all orders of a certain customer List all city names, how many orders, and the total values of all orders in those cities . . . . . 4. Writ the algebraic statements that correspond to the SQL statements you wrote in Q3