3. Model the enterprise architecture design of the following scenario using Activity diagram modeling notation. A cosmetic company sells its products through their website. Customers must register their details to gain access to the available products. After registration, customers can search for the available products. When selecting their favorite products, they make an order of the type and number of products. If products are out of stock, customers are notified. Otherwise, customers pay the required amount by their credit card. If the credit card covers the total price, the company accepts the transaction and the sales department ships the products to the customer's address. Otherwise, the company does not accept the transaction and the customer has to reenter credit card details with valid amount.

3. Model the enterprise architecture design of the following scenario using Activity diagram modeling notation. A cosmetic company sells its products through their website. Customers must register their details to gain access to the available products. After registration, customers can search for the available products. When selecting their favorite products, they make an order of the type and number of products. If products are out of stock, customers are notified. Otherwise, customers pay the required amount by their credit card. If the credit card covers the total price, the company accepts the transaction and the sales department ships the products to the customer's address. Otherwise, the company does not accept the transaction and the customer has to reenter credit card details with valid amount.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

need diagram only Draw an ER diagram for the following scenario: A designer has a store of designer dresses both for male and female. People can buy as well as take dresses on rent from the store. Each dress in the designer's store, is identified by unique ID. A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc. The designer maintains the name, phone number of people who have taken dresses on rent. The designer also maintains the name, phone number, and address of people who have bought dresses from the store. The designer also collects feedback from the people who have bought or taken dresses on rent from the store. Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed.
Draw EER diagram based on these business rules Customers can only make a reservation for themself and their invited guests. A customer may not make a reservation for other people including such as reselling rooms. A customer cannot use Park Hyatt website to reserve room related to any commercial activity. A customer need to provide the ID card or passport. A customer must check-in after 4 p.m. A customer must check-out before 12 p.m. A customer may select room before do the reservation. A customer can do online payment by credit card or pay while during check-in. A staff must check the customer ID card or passport.
Business System ERD Create an ERD based on the Crow’s Foot model, using the following requirements: An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. An INVOICE can include many detail lines (INVOICE_ITEM), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity. The product’s vendor information is found in a VENDOR entity. You do NOT need to put any fields/attributes into this ERD. Just draw the entities as empty boxes with relationships between them.
4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager. Draw the activity diagram for the above scenario.
MOUNTAIN ADVENTURE: WHITE WATER AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES) MOUNTAIN ADVENTURE is a Montana-based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northwest. You have been hired by MOUNTAIN ADVENTURE to evaluate their processes, risks, and internal controls. The following paragraphs describe Outdoor Adventure’s revenue cycle procedures. Revenue Cycle SALES ORDER PROCESSING PROCEDURES. Customer orders are mailed or e-mailed to the sales department. When the order is received the sales clerk checks the customer’s creditworthiness from a computer terminal by running a validation application. The credit-check program determines if the customer’s account is up-to-date regarding payments and the customer has not exceeded his or her credit limit. Computer controls in the application prevent further processing of any transactions that fails the credit check. Under certain extenuating…
QUESTION 1 Create a UML Sequence Diagram for the following book shop checkout system: Assume that a customer selects the books and taken to the cashier by the customer. To complete the order, the cashier scans each book with the checkout device. Cashier requests for the payment through credit card from Customer. Customer provides a credit card to the cashier. The card is checked by the Bank Muscat at the checkout device. The Bank Muscat confirms the acceptance of the payment. The customer signs the receipt for credit card. The books bought would be shipped to the customer.
A student may register for classes during a specified registration period. To register, a student must see their advisor. The advisor must approve each course that the student has selected. The advisor will use the registration system to determine if the student has met the course prerequisites, is in good academic standings and is eligible to register. If the advisor approves the courses, the advisor enters the student's college id into the course registration system. The course registration number for each course is entered. The course description, course number and section for those courses will automatically display. The system will check for schedule conflicts before saving the registrations. A bill for the courses will print in the Bursar's office. The student should proceed to pick it up. b)Draw a class diagrams which represents the generic objects and relationships described above. Make c)sure to specify multiplicities for all associations shown in your diagrams.----
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
Case 3: Create a sequence diagram based for Belle's Grocer Automated Checkout System. Belle's Grocer is developing its own automated checkout counter. When customers come up to the counter, they will first scan their membership code if they have one or skip this step if they don't. If they have their membership, the screen will show their membership details such as name, membership ID and membership expiry date based on their members database. Customers will then scan their own items, where item info and price will be pulled from the database. The system then calculates total grocery amount and factor in membership discount to generate the end total. Customers check the items and total before checking out. Customer can choose payment of cash or card. Card payment will require customer digital signature. If cash, the system will receive input cash and confirm cash amount with the customer before proceeding to return balance. The Classes involved: 1. Membership 2. Input grocery items 3.…
An E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.
UML Prepare a UML diagram for register a customer complaint. prepare a UML diagram for canceling a reservation
Use the Information below and create a sequence diagram for the use case. Name: Buy Parts Actor: Customer/Store Associate Description: This use case describes the process used to buy parts at the auto parts dealer. Successful Completion: 1. Customer requests auto part 2. Store Associate checks on availability of part 3. Part is available and customer pays cost 4. Customer receives part and stock is adjusted 1. Customer requests auto part 2. Store Associate checks on availability of part 3. Part is not available and customer selects to order part or no part 4. Customer receives part and stock is adjusted (if alternate part ordered) or customer leaves with no part Alternative: Pre-Condition: Customer wants to purchase part Post-Condition: None Assumptions: None