Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use relevant software to create ER diagrams. Also, send the solution in a google drive in its format (extension) instead of pasting the diagram
Please use relevant software to create ER diagrams. Also, send the solution in a google drive in its format (extension) instead of pasting the diagram on Chegg.
Problem Definition-Part 1 of 3 You are contracted to design and implement an online computer store (CompuStore) that sells laptops. CompuStore has three branches and each branch stores its data locally. Customers can purchase online or they can purchase in store at any of the branches. When a purchase is attempted online, the system checks for the item at all three branches and makes the purchase at the branch with the most items that is being purchased. In order to make a online purchase at CompuStore, you have to sign up for an account. You will also have to enter your credit card details. When making a purchase, a credit card payment involves simply connecting to a remote database, verifying the customer information while checking if the customer can make this purchase. This will have to be simulated in the final part of the project. The details of all purchases are stored at CompuStore so that this data can be used in the future to make decisions. CompuStore also stores the details of all customers. A customer should be able to purchase one or more laptops in different quantities. CompuStore also keeps stock of its laptops that are stored in warehouses. At the end of a transaction, a receipt should be generated for the customer. This receipt should have a tracking number that the user can use in another system that is already built to track their items. Finally, only customers that have purchased a particular item should be able to write a review of that item Part 1 Draw an E-R diagram for the above application. Make sure that you state any assumptions that you made and any information that could not be captured in the diagram. You are free to add any additional information that you feel may be useful for this application. However, you must state why you choose to do so. Bonus points will be assigned for any useful entities proposed. Convert the E-R diagram into a set of relations. (NB: Do not attempt to normalize your tables at this time.)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started