What is the best example of a scenario in which a new database should be created to support the business? a.) An organization is building an eCommerce website for their customers to purchase products. They would like to have all of the usual features of an eCommerce site setup while allowing their customer service team to help track orders and provide help to customers that call in. b.) An organization would like to create a reporting tool built off of their eCommerce database to identify data analytics around customer purchases on their existing data. c.) An organization would like to create an eCommerce site through a hosting site like Shopify that handles all of the processing of the orders. d.) An organization would like to create a new product line to sell on their existing eCommerce site.

1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.

Answer in your own way

“Supporting a travel agency, TORS maintains tour information and provides reservation facilities for the people who wish to travel on tours via the Internet. The system allows users to view information about the tours available and make a reservation on a tour without asking the employees at the agency. Using the system, a user can cancel an existing reservation that the user made. The system also allows the user to send feedbacks by e-mail to the agency andstores the feedback in the database. Finally, the system allows the employees of the agency to manage customer information and tours such as adding, deleting, and updating information on customers and tours. For security purposes, the employees are required to provide login credentials (ID and password) to access the system.” Draw two system sequence diagrams, one for the success scenario of each use case. (Note : Please give me the sequence diagram for the above question)