Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use relevant software to create ER diagrams and state any assumptions made. Also, send the solution in a google drive (editable format if applicable)

Please use relevant software to create ER diagrams and state any assumptions made. Also, send the solution in a google drive (editable format if applicable) instead of pasting the diagram on Chegg as the image quality reduces and may jeopardize my grade.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Solaris 11.2 System Administration (oracle Press)

Authors: Harry Foxwell

1st Edition

007184421X, 9780071844215

More Books

Students also viewed these Databases questions